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 / How can I track failed...
Power Automate
Suggested Answer

How can I track failed flows in Excel?

(1) ShareShare
ReportReport
Posted on by 22
Hi
I plan to record the results of all "flow" runs in Excel. If everything goes smoothly, Excel will record invoice information I need, and I hope it will record "failure" when a run fails.
Currently, my idea is to add an "if" condition in every step, but since there are many steps, this is too cumbersome.
Is there a simpler method?
Thank you.
 
Categories:
I have the same question (0)
  • Suggested answer
    trice602 Profile Picture
    15,886 Super User 2026 Season 1 on at
    Hi,
     
    You're on the right track; you don't want to write an if statement after every step.  What you can do is put your key actions into a Scope action and then add your add a row in a table action.  This is setup as a configure run-after on failed or timed out.  This way this works for every action inside your scope; if any of them fail or timeout, it will add a row as failed.
     
     
    ------------------------------------------------


    If this was helpful, please like and/or mark as a verified answer to help others find this too!


    Always glad to help! 💯💯💯💯💯

    Tom 

    Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

     


     
  • CW-23070243-0 Profile Picture
    22 on at
    @trice602
    Thanks for your kind help. 
    But how to set up "run after" after a "Condition" ?
    in the picture below, sometimes "Body" is empty it will cause error in "Condition" step. My idea is if the "body" is empty, execute the YES step, but it seems that leaving it blank after " is equals to" here does not work.
  • trice602 Profile Picture
    15,886 Super User 2026 Season 1 on at
    Hi,
     
    Add the expression is equal to null for your body conditional check.
     
     
    ------------------------------------------------


    If this was helpful, please like and/or mark as a verified answer to help others find this too!


    Always glad to help! 💯💯💯💯💯

    Tom 

    Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

     


     
  • CW-23070243-0 Profile Picture
    22 on at
    @trice602
    It may be because I didn't provide you with the complete picture, I tried it out, and the following error occurred,
    ”customerId text“ is from AI builder.
    could you please help me with it ?


  • Suggested answer
    trice602 Profile Picture
    15,886 Super User 2026 Season 1 on at
    Hi,
     
    This error is not related to the issue we are working on but rather the conditional row above.  Her's what I recommend:
     
    1)  Mark this as a solution for the original question - how to write a condition to check if the attachment is an Excel file or not.
     
    2)  Create a new thread and ask for help with the AI contains text condition.
     
     
    ------------------------------------------------


    If this was helpful, please like and/or mark as a verified answer to help others find this too!


    Always glad to help! 💯💯💯💯💯

    Tom 

    Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

     


     
  • trice602 Profile Picture
    15,886 Super User 2026 Season 1 on at
    Hey there!
     
    I am following up on this post how can i track failed flows in excel? in this category building flows from 11/11/2024.  I know the post is a little older, but it is a common question here so wanted to take a moment and follow-up. I see there have been 5 replies and 1 likes and asking if your question has been answered.  If so, please help the community out by completing one or more of the following actions!  Thanks in advance!
     
    Easy as 1-2-3 ‼️💯⭐😎🆒🙏
     
    1) Mark a reply as a verified answer - this is essential, and it helps others with the same general question find this thread. ✅
    2) You can also mark one of more replies as a verified answer.  Please take a moment and give the author credit for volunteering their time. ✌️
    3) Like one or more replies.  Kudos always greatly appreciated! 👍
     
    Pro tip:  if you found your own solution or workaround, feel free to add a reply to your own post and mark it as the solution too!  The goal is to get this thread marked with a verified answer by anyone that finds one or more replies helpful!
     
    Again, thanks in advance for reading and responding, always glad to help!  Tom 💯💯💯💯💯
  • trice602 Profile Picture
    15,886 Super User 2026 Season 1 on at
    If I can help with anything else please let me know or tag me in a future post, I enjoy reading and answering questions.  Always glad to help!  Tom 💯💯💯💯💯

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 315 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 273 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 117 Super User 2026 Season 1

Last 30 days Overall leaderboard