cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sarahkelley
Regular Visitor

Send an email based on Excel date - stopped working

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! 

 

Flow1.PNG

 

Flow2.PNG

 

Flow3.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions
sarahkelley
Regular Visitor

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.

View solution in original post

4 REPLIES 4
mgrachii
Resolver I
Resolver I

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

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: error.PNG

 

sarahkelley
Regular Visitor

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.

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.

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (1,071)