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 / Action Condition Failed
Power Automate
Unanswered

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,502 Super User 2025 Season 2 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,502 Super User 2025 Season 2 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,502 Super User 2025 Season 2 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,502 Super User 2025 Season 2 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,502 Super User 2025 Season 2 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

Forum hierarchy changes are complete!

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

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard