Powershell and Flow

Have you ever been silly enough to develop a flow that creates a lot of approval actions in Microsoft Flow?  I have! Now you need an easy way to cancel them all in this post I’m going to go through the steps.

 

I’m going to use PowerApps PowerShell. If you haven’t used this before the you will have to install this first.

Installing PowerApps PowerShell

The following two lines of PowerShell will install the right PowerShell modules for you ( make sure that you run PowerShell as administrator) :

Install-Module -Name Microsoft.PowerApps.Administration.PowerShell
Install-Module -Name Microsoft.PowerApps.PowerShell -AllowClobber

Get the Environment

Get-FlowEnvironment

This will list all your environments. Now find the right EnvironmentName for your flow

Get all the approvals

Get-FlowApprovalRequest -EnvironmentName Default-3985c6b6-11d8-4c13-84a9-1847f555ae47

This will list all the approvals for your environment. If you need to filter by flows then you might need to go through some more steps.

Delete all the approvals in your environment

To delete all the requests you could now run the following script:

$Requests = Get-FlowApprovalRequest -EnvironmentName Default-3985c6b6-11d8-4c13-84a9-1847f555ae47

foreach($Request in $Requests) {

Deny-FlowApprovalRequest -EnvironmentName Default-3985c6b6-11d8-4c13-84a9-1847f555ae47 -Comments "Cancelled" -ApprovalId $Request.ApprovalId -ApprovalRequestId $Request.ApprovalRequestId
}

Note that this will delete all your requests.If you don’t want to delete all the requests then you might have to add some filters to the Get-FlowApprovalRequest lines.

 

 

By Pieter Veenstra

Business Applications and Office Apps & Services Microsoft MVP working as a Microsoft Productivity Principal Consultant at HybrIT Services. You can contact me using contact@veenstra.me.uk.

8 thoughts on “Cancel all your approvals in Microsoft Flow using PowerShell”
  1. Pieter, this is awesome. Wondering if you have any idea to cancel a particular Flow Approval instance from PowerApps.

    tommy

  2. Hello Pieter,

    I believe P1 license is required for the above Powershell cmdlets to work,
    Please correct me if I am missing anything.Thank You !

  3. Could someone help. This is very useful but I want to filter only approvals with the title ‘VSRA Approval 2’. I do not want to cancel all the other approvals in course. How can I filter on the Title property to get just these approval flows to be cancelled? Thank you.

    1. You would have to filter

      Get-FlowApprovalRequest -EnvironmentName Default-3985c6b6-11d8-4c13-84a9-1847f555ae47

      so you could use the folllowing:

      Get-FlowApprovalRequest -EnvironmentName Default-3985c6a6-11d8-4c13-84a9-1847f555ae47 | Where { $_.Title -eq “VSRA Approval 2” }

  4. This is a great solution, and I want to delete them all. There a several that were all used for testing. The script prompts for an ApprovalID and an ApprovalRequestID: for each of them. Suggestion on how I mitigate that?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.