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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Action Condition Failed
Power Automate
Answered

Action Condition Failed

(0) ShareShare
ReportReport
Posted on by 44

Hi, I don't really understand power automate that well but I am trying to build a flow to send an email reminder out 28 days before a document expires and then 7 days.  The data is on an excel document.  My flow works but I get an error when it comes to the sending an email out.  Can anybody help?  If I can get this to work then it would help me cut my work down quite considerably.  My other similar flow (used lists instead of excel) worked fine but now has the same error.  In the UK our clocks went forward at the weekend and I noticed the parameters properties start time and end time is showing 1 hour behind our current time.  Could this have anything to do with it?

fyogaff_1-1712084193456.png

 

fyogaff_0-1712084157421.png

 

Categories:
I have the same question (0)
  • creativeopinion Profile Picture
    10,508 Moderator on at

    @fyogaff Can you explain the need for the two branches? Are you able to switch to the Classic Designer mode and toggle open each action and take a screenshot of that?

     

    If you are running the List Rows Present in a Table action on the same Excel table, you only need to run that action once. 

     

    In the meantime, you might find this YT Tutorial helpful: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

     

    In this Power Automate tutorial, I explore 5 frequently asked questions that pop up when troubleshooting a flow. If you’d like to to level up your Power Automate flow skills and learn how to troubleshoot your Power Automate flow—this tutorial is for you!

     

    IN THIS VIDEO:

     How to troubleshoot a false Condition action result

     How to get dynamic content when it isn’t selectable from the list of dynamic content

     How to troubleshoot an Apply to Each action that isn’t looping through

     How to troubleshoot a skipped Apply to Each action

     How to troubleshoot a Filter Query

     How to use a SharePoint yes/no column in a Filter Query

     How to use Compose actions to troubleshoot a Power Automate flow

    How to troubleshoot multiple emails being sent

     How to troubleshoot multiple Teams messages being sent

     

    Hope this helps!

    If I helped you solve your problem—please mark my post as a solution .
    Consider giving me a 👍 if you liked my response!

    👉 Level up your Power Automate skills by checking out my tutorials on YouTube
    👉 Tips and Tricks on TikTok and Instagram

  • fyogaff Profile Picture
    44 on at

    I have just updated my question as power automate is still showing 1 hour behind the UK time - not sure if that has any relevance.  I don't actually need the branch and can delete this.  Will have a look at your YT.

    Thanks

     

  • creativeopinion Profile Picture
    10,508 Moderator on at

    @fyogaff It would help to see your flow in the Classic Designer (in edit mode). 

  • fyogaff Profile Picture
    44 on at

    That's easier in classic - you learn something new everyday 🙂fyogaff_0-1712084882497.pngfyogaff_1-1712084947403.png

     

  • creativeopinion Profile Picture
    10,508 Moderator on at

    @fyogaff Can you show the advanced options of the List Rows Present in a Table action? Do you have a filter query in this action?

  • fyogaff Profile Picture
    44 on at

    fyogaff_0-1712085881209.png

    I deleted the branch and switch to classic and it is now saying it was successful however I haven't received the email.

  • creativeopinion Profile Picture
    10,508 Moderator on at

    @fyogaff I'm assuming that's because your List Rows Present in a table action isn't returning any items.

     

    Whenever I use a Filter Query in a List Rows Present in a Table action, I always like to return the count of items returned in a Compose action. This is helpful when building a flow and can also be used to troubleshoot your flow.

     

    Insert a Compose action. Add an Expression. Use the length() function.

    creativeopinion_1-1712086253774.png

     

    Select the Dynamic content tab and insert the body dynamic content from the Filter Array action into the length() function.

    creativeopinion_2-1712086277597.png

    Run a test and review the output of the Compose action. If the output is 0, this means that no items were returned from the List Rows Present in a Table action.

     

    Also, whenever working with dates/times in Excel, you should always set the DateTime format to ISO8601.

    creativeopinion_0-1712086223941.png

     

     

     

  • fyogaff Profile Picture
    44 on at

    added compose and it returned 0 outputs but I changed the date and it should pull through 1 row.  I also changed the DateTime format to ISO8601.

  • creativeopinion Profile Picture
    10,508 Moderator on at

    @fyogaff Sorry, it's unclear to me. Is your List Rows Present in a table action returning rows now or not? 

  • Verified answer
    fyogaff Profile Picture
    44 on at

    Sorry, it was my error.  I was doing a trial with the wrong dates on my excel document.  It now works and thanks for the tip on 'compose', it's very useful.  

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 273 Super User 2026 Season 2

#2
trice602 Profile Picture

trice602 149 Super User 2026 Season 2

#3
11manish Profile Picture

11manish 144 Super User 2026 Season 2

Last 30 days Overall leaderboard