Issue looking for power automate flows that are running

[CarlWillis]

Hello,
I am looking to use M365CLI as a method to cancel all running flows for one that has been overloaded. I'm using the script located here: https://ashiqf.com/2021/05/16/cancel-all-your-running-power-automate-flow-runs-using-m365-cli-and-rest-api/

The script is a little inefficient in that the flow list should return only ones that are running rather than the full list and then filter ones in running status.

Looking at the CLI here: https://pnp.github.io/cli-microsoft365/cmd/flow/run/run-list/ there is an option for filtering by status (--status)

There is a sample command: m365 flow run list --environmentName Default-d87a7535-dd31-4437-bfe1-95340acd55c5 --flowName 5923cb07-ce1a-4a5c-ab81-257ce820109a --status Running

When I try the --status Running with my environment/flowname it says that status is invalid option.

I've also tried using --query [?status == 'Running'] but the JMESPath query doesn't seem to work because the JSON being returned is invalid (seems to be on the API and URI items)

I'm using version 6.2.0

What am I doing wrong?

[milanholemans]

Hi @CarlWillis

The issue here is that we don't have versioning in our docs (yet). We indeed enhanced this command with the status parameter, but this is currently still in beta. The docs are showing the current beta release state of the CLI. If you would like to see the docs of the state you are in, you can append --help to your command and the docs of that version will be printed in your console.

If you would like to use this status parameter for this command, you can do 2 things:

• Install the current beta release by running the command npm i -g @pnp/cli-microsoft365@next
• Wait until next week. Usually we bring out a new stable release on the last day of the month.

Hope this answers your question.

[CarlWillis]

Thanks!

Will the next version also address the issue with JMESPath query not working as well?

[Jwaegebaert]

Hey @CarlWillis, for the query issue. When using this in command, u should make sure that your query is surrounded by quotes. A bit like this --query "[?status == 'Running']"