function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Sree KrishnanSree Krishnan 

Formula Field should trigger a flow

Hi,
Can anyone help on below Issue.

I have a Formula (DateTime) Field which is calculating based on the Created Date. It is like,
DatetoTransfer = CreatedDate + CASE(WEEKDAY(DATEVALUE(CreatedDate)), 1,8,7,9,7).
Also, i have another Formula (Checkbox) field. It is like,
TodaysTransferDate = DateToTransfer = Now().

Now I need to trigger a Flow When TodaysTransferDate = Current Date Time. 

Any thoughts?
HarshHarsh (Salesforce Developers) 
Hi Sree,
Flow can’t fire based on formula field changes.
  • Formulas CAN be used in trigger conditions before save flow triggers
  • Formulas CAN be used in trigger conditions after save flow triggers
  • Formulas CAN be used in decisions in before save flow triggers IF the Resource uses the Prior Value                                                    (e.g. {!$Record__Prior.IsActive__c}). But you can NOT use formula values from the newly changed record.
  • Formulas CAN be used in decisions after save flow triggers
  • Formulas CAN be used as the source value in Assignment Updates in before save flow triggers IF the Value uses the Prior Value           (e.g. {!$Record__Prior.IsActive__c}). But you can NOT use formula values from the newly changed record.
  • Formulas CAN be used as the source value Update records elements after save flow triggers
please refer to the below link.
https://tddprojects.atlassian.net/wiki/spaces/SF/pages/1643085893/Formulas+in+Flow+Triggers

Please mark it as Best Answer if the above information was helpful.

Thanks.