I have a Record-Triggered Flow on an Account with a Scheduled Path that uses a Date Formula field as the Time Source. Specifically, the Time Source is set to 'Start Date' with an Offset Number of 1 minute after. However, this Scheduled Path is not being executed as expected. And I cannot see it being scheduled under Time-Based Workflow.
While debugging the flow, everything appears to be fine and is being executed.
I noticed that if I use the 'Record CreatedDate' or 'LastModifiedDate' instead of the 'Start Date' formula field, the Scheduled Path works well. And I can it scheduled under Time-Based Workflow.
Does this mean that we cannot use a Formula Date field as the Time Source for a Scheduled Path in a Record-Triggered Flow?
If anyone has faced a similar problem or has any resources or advice, I would appreciate any help. Thank you in advance!
Best Answer
Formula Fields in Salesforce are only calculated when you access them, so there's no concept of the value in a Formula Field changing. That means they won't run triggers when they change and they won't be able to trigger a flow either.
For example, you could have a formula field that had the formula
TIMENOW(). It would be impossible for Salesforce to keep checking every time that formula changed its value.