web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Apply to Each not work...
Power Automate
Unanswered

Apply to Each not working with a date condition

(0) ShareShare
ReportReport
Posted on by 332

I'm working on a flow that is supposed to Get Items from a SharePoint list and send an email for each item where a date in the column NewDateReported equals today's date.

 

Capture.JPG

 

Capture2.JPG

 

I've verified that the output format of the NewDateReported column is 'yyyy-MM-dd' by running the flow without the condition and looking at the output. However, when I run the flow the "send email' action is not triggered, even though there are two items on the list that match today's date. The error message I receive says "ActionBranchingConditionNotSatisfied. The execution of template action 'Send_email_with_options' skipped: the branching condition for this action is not satisfied."

 

If I format the NewDateReported field in the condition action to match the 'yyyy-MM-dd' format, the first item matching today's date triggers the "send email" action. Then the flow runs for a half-hour or so with nothing else happening, until I cancel it. There are only 245 items on my SharePoint list, so it really shouldn't take that long.

 

Does anyone have any ideas? 

Categories:
I have the same question (0)
  • SudeepGhatakNZ Profile Picture
    14,394 Most Valuable Professional on at

    That sounds strange!

    Are you able to add an email action in the no branch and include the formatDateTime(NewDateReported,'yyyy-MM-dd') in the subject line along with the ID of the List item?

    Be prepared to receive a flurry of emails, but you would at least know if it is the loop that is causing the delay or the condition goes into a hung state and just not proceed.

     

     

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 378 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 273 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 135 Most Valuable Professional

Last 30 days Overall leaderboard