cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Hockeymom
Level: Powered On

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
Community Support Team
Community Support Team

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
Community Support Team
Community Support Team

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

Hockeymom
Level: Powered On

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

Community Support Team
Community Support Team

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

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

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