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?
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
Check out the community blog page where you can find valuable learning material from community and product team members!