Skip to main content

Notifications

Power Automate - Building Flows
Suggested answer

How to get all the flows that runs failed in the environment (not the admin)

Like (0) ShareShare
ReportReport
Posted on 14 Jan 2025 07:17:29 by 36
Hi Everyone,
 
Is there any way to get all the flows (that created under account or under environment) failed and notify to MS teams or send the email? 
As I know, there are some ways that we can add the step in the flow to get notify.

(27) Power Automate: Retrieve all running Flows | LinkedIn

as I found this forum, so I think it might be some ways to get all the flows that runs failed and notify.

Please advise,
 
Thank you,
Tan Punsuwan
  • Nuiii Profile Picture
    Nuiii 36 on 16 Jan 2025 at 09:22:09
    How to get all the flows that runs failed in the environment (not the admin)
     
    Thank you for your suggestion again,
     
    Just to update, I have only 1 flow access from the Dataverse table.
     
    However, I got the flow works.
     
    I used, List My Flows action (from Power automate Management) with the Environment ID
     
     
    and Invoke an HTTP request action to each flow from the output List My Flows action and filter them with "Failed" Status.
     
     
    Cheers,
  • Mark Nanneman Profile Picture
    Mark Nanneman 831 on 15 Jan 2025 at 13:34:50
    How to get all the flows that runs failed in the environment (not the admin)
    @Nuiii,

    If you have access to your environment's dataverse tables at make.powerapps.com you can always go there and check the "Flow Runs" table to make sure you're getting all the rows you need in your flow.





  • Nuiii Profile Picture
    Nuiii 36 on 15 Jan 2025 at 03:35:11
    How to get all the flows that runs failed in the environment (not the admin)
    Hi Mark @Mark Nanneman​​​​​​​,
     
    Thank you for your advice.
     
    I don't know why when I filtered the List rows with the status, it won't return the flow runs as expected. But when I filtered with endtime it's get all the flows that has endtime as filtered. Moreover, on mine it lists only 1 flow (as I see only 1 flow name in the output)
     
    Please advise,
  • Suggested answer
    Mark Nanneman Profile Picture
    Mark Nanneman 831 on 14 Jan 2025 at 19:52:19
    How to get all the flows that runs failed in the environment (not the admin)
    One thing you could try is to set up a recurrence flow that checks the "Flow Run" Dataverse Table on a schedule.  Just have it filter for status eq 'Failed' and also filter for flows with an endtime gt some past time to get all the fails since the last run.

    E.g.
    status eq 'Failed' and endtime gt @{addDays(utcNow(),-2)}

    Here's a blog post I wrote on how I built a flow to list failed flow runs from the Dataverse "Flow Runs" table and send deep links to each failed flow in an email and teams approval:
    https://marknanneman.wordpress.com/2025/01/14/send-a-list-of-recently-failed-flows-via-teams-and-email-using-the-dataverse-flow-runs-table-in-power-automate/

    Flow Run table:
    Example failed flows:


    Example action in power automate to list the recently failed flows 


    If this helped you, please click "Does this answer your question" and give it a like to help others in the community (+ close the ticket)!

    Power Platform Developer | LinkedIn: Mark Nanneman | Blog: Power Stuff  | YouTube: Mark's Power Stuff  | Buy me a coffee

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

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #11 New Opportunities…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,593

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,403

Leaderboard
Loading started