Send an email based on Excel date - stopped working

[sarahkelley]

Hi all - 

I put together a flow that sends an email reminder to staff 30 days prior to the expiration date of certifications, based on an Excel spreadsheet.

It worked perfectly until this morning - I hadn't made any changes to the flow. I had made a few changes to dates in the Excel spreadsheet, but that shouldn't have caused the flow to stop working. 

It hangs up on the Condition that compares Expiration Date to this formula: 

formatDateTime(addDays(utcNow(),30),'MM/dd/yyyy')

I added 2 Compose sections to see what was actually getting passed through the variables, and I saw exactly what I expected to see: two dates in the proper format. When the same, the Condition is met and the flow should kick out an email, but the flow is throwing an error on the Condition.

I was in the spreadsheet editing when the flow ran this morning, so maybe that did something? I have no idea. 

Any help is greatly appreciated! 

[mgrachii]

Can you share the actual error you are getting ? A screenshot of what Power AUtomate is telling in the condition?

[sarahkelley]

Strange thing - I ran it once just now to reproduce the error, and it ran fine, no problem. 

I changed a date in the spreadsheet to meet the condition (to see if an email would go out) and it failed again.

Here's a screenshot: 

[sarahkelley · Accepted solution]

Figured it out - it wasn't failing on the condition, it was failing because there was an error in the "send an email" piece. Moderators - I can leave the original post up if the flow would be helpful to someone.

[v-LilyW-msft]

Hi @sarahkelley 

Thanks for your posting and glad that your issue is solved.

Please consider accepting your reply as an answer so that this thread will be marked for other users to easily identify!

If there is anything else we can do for you, please feel free to post in the forum.

Best Regards.