Posts

Showing posts from December, 2025

Salesforce Fact #963 | Access formula fields from Create Records

Image
With the Winter'26 release, we can now access sobject fields from the Create records element without an additional Get records. This also works fine for local formula fields(not for cross object formula fields). This is similar to the Formulas.recalculateFormulas() function but doesn't consume any SOQL query. In this example, we have a formula field on case which calculates a date 10 days plus the Createddate. In the flow, we are creating a case record and referring the same field from the Create Record reference, it shows the value correctly. Reference:  https://admin.salesforce.com/blog/2025/improve-automation-with-winter-26-flow-features-be-release-ready Attached are the screenshots.

Salesforce Fact #962 | SOQL syntax error in Get Records while using IN operator and sorting

Image
We need to be careful while using the IN operator in Get Records element along with sorting of the result by a field. If the text collection is null which is used in the Id filter, the underlying SOQL throws a syntax error. As a best practice, it is always preferred to check if the collection var is null or not. This also avoids one SOQL query. Attached are the screenshots. Reference:  https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000JfvwISAR

Salesforce Fact #961 | 1st monday and last friday validation in screen flow

Image
We can implement a validation in screen flow using the formula resource to select a date other than the first monday and last friday of the month. Attached are the screenshots.