Hi folks,
I’m trying to create a Scheduled flow that runs every day to check for when an Open Contract Date on the Account object matches today’s date.
We have around 200 contracts that we monitor, all with various dates.
Desired Flow outcome:
If the Contract Open Date = today, send an email alert listing these specific Contracts for review.
The problem I have is within the very first Start element in choosing the Account object: you cannot institute criteria that grabs contracts that ONLY match today’s date. Even when I create a Resource of a Formula for today’s date, I cannot use that Resource as part of my criteria in the Start element.
Even when I add a Get Records element after the Start element to narrow the scope of the record set (using a Formula – grab only those Contracts where the Open Date = Current Date), my Flow grabs every single account, presumably from the Start element (because I cannot use a Formula there).
Any insight / examples is greatly appreciated! Thank you!
In order to debug you'd have to say as a new autolaunched Flow from memory as you can't debug scheduled flows.
