cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Flow ran successfully, but the condition action did not happen

Hello

 

I built a flow to Send an email to a list of registered participants reminding them to fill out a short satisfaction survey after they attend an event with the information coming from a Sharepoint calendar. It says the flow runs but it does not complete the action

 

What I want it to do is the following:

 

  1. Send an email 1 day after the event end date to the names that appear in the column Inscriptions with the Subject that appears in the column Nom de l'événement and in the body addd the url that appears in the column Description

 

When I test the Flow, I get the message that it ran successfully but that an Action BranchingConditionNotSatified yet there is an event in there yesterday so it should have generated an email if the formula is to add one day to the Event Enddate.

 

What am I missing?

 

Action branching not satisfied.PNGFlow Part 1 Jul 16_LI.jpgFlow Part 2 Jul 16.PNG

 

Can you please  help me as I am a novice and know no code.

Thanks in advance

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Flow ran successfully, but the condition action did not happen

Hi @Hockeymom

 

If you want to send an email 1 day after the event end date, then UTC now should one day biger than the event end date, so you should sub one day from the UTC now and the compare the date with the event end date.

 

You could modify the expression as below:

@equals(formatDateTime(items('Apply_to_each')?['EndDate'], 'MM/dd/yyyy'), formatDateTime(addDays(utcNow(), -1), 'MM/dd/yyyy'))

 

I have create a flow as below:

Capture.PNG

The flow would run successfully as below:

Capture.PNG 

 

 

 

 

Best regards,

Alice

View solution in original post

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Flow ran successfully, but the condition action did not happen

Hi @Hockeymom

 

If you want to send an email 1 day after the event end date, then UTC now should one day biger than the event end date, so you should sub one day from the UTC now and the compare the date with the event end date.

 

You could modify the expression as below:

@equals(formatDateTime(items('Apply_to_each')?['EndDate'], 'MM/dd/yyyy'), formatDateTime(addDays(utcNow(), -1), 'MM/dd/yyyy'))

 

I have create a flow as below:

Capture.PNG

The flow would run successfully as below:

Capture.PNG 

 

 

 

 

Best regards,

Alice

View solution in original post

Highlighted
Frequent Visitor

Re: Flow ran successfully, but the condition action did not happen

Thank you Alice

 

I realize now that I may have to work with hours instead of days, because it may happen that there is more than one event per day. So would it work the same way for hours if say I want to send the email 1 hour after the event ends?

 

Would the formula be ok like this :

@equals(formatDateTime(items('Apply_to_each')?['EndDate'], 'MM/dd/yyyy HH:mm'), formatDateTime(addHours(utcNow(), -1), 'MM/dd/yyyy HH:mm'))

 Thanks for your help

Highlighted
Community Support
Community Support

Re: Flow ran successfully, but the condition action did not happen

Hi @Hockeymom,

 

Yes.

The expression should like your provided.

 

Best regards,

Alice

Helpful resources

Announcements
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,963)