Get flow runs

(0) Share

Report

Posted on by da1vea

185

Hey all,

I have been trying to find a way to get the status of a flow run (and possibly the last 3).

Has anyone got this working? I came across this article and it works for some things. I couldn't get the custom connector to work (I even imported the example from github). What did work was getting the flow run details under the heading "Authorization code flow for token generation" but it relies on getting a code from your browser address to then get the access token (its a one-time code)

Has anyone got a working solution?

Thanks,
David

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
Hi @da1vea,

Personally I prefer a command line tool (PowerShell or CLI) for this because they have out of the box commands for this type of things.

For example the CLI for Microsoft 365 module has a flow run list command. Below is an example how you could retrieve the last flow runs of a single flow in a specific environment and output the results to a csv file.

m365 login m365 flow run list --environmentName Default-d87a7535-dd31-4437-bfe1-95340acd55c5 --flowName 5923cb07-ce1a-4a5c-ab81-257ce820109a --output csv --asAdmin

Was this reply helpful? Yes No
da1vea 185 on at

Like (0)

Report

Hi @Expiscornovus ,

Thanks for your reply but I am wanting to run this in Power Automate so I can feed the results back to Power Apps. I was thinking Azure runbook but would prefer to keep the actions in Power Automate unless I am completely missing your suggestion as I noticed this requires node.js?

With the custom connector I keep getting authorization failed

Was this reply helpful? Yes No
Steve79 4 on at

Like (1)

Report

As far as I'm aware, you can't run Microsoft 365 CLI from an Azure Runbook. But, you can do it from an Azure Function which is what I've done as I have a whole host of Power Automate reporting setup using a Function which outputs to a Blob file and is ingested into a BI dashboard.

This great article from Martin Lingstuyl explains how you can set it up: Blimped | Configuring the CLI for Microsoft 365 in Azure Functions

Was this reply helpful? Yes No