I am trying to get an email sent to the person in a list “who” field when condition the “Next_work_due” date is today’s date. As a sanity check for testing, I have also temporarily set up an email to the “who” person when the condition is NOT met.
In my Condition, I have dynamically selected the Next_work_due field, set it to “is equal to” and then today’s date is formatted as:
I get no error message and the flow is reported as Succeeded. I receive an email letting me know there are no date matches.
In the Run History, the Apply To Each box Condition box is greyed.
The Next_work_due field is set to Date only in the list. The only entry in the list so far is for today’s date.
Please can anyone help get this working, it’s driving me bonkers!
Thanks in advance.
Solved! Go to Solution.
Right before your condition, add a compose step, put the dynamic content of Next_work_due field. Then check the format against how your condition is working. The compose is just to aid in the troubleshooting.
you need to formatdatetime with the incoming date as the same format for today. This way, they will be exactly the same.
also, on your formatdatetime(utcnow(),'MM-dd-yyyy') needs the ' ' on either side of the format
Added Compose and checked it - the date input and output are 2020-11-27. I have changed the Next_work_due and UTCnow() format to yyyy-MM-dd to match the format output of Compose. Still no joy....
The Condition is now inspectable (it was greyed out before) and it shows the expression result is false. Any ideas?
Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
Check out the new Power Platform Community Connections gallery!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.