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.
Pieter Veenstra
Is your business still running on paper trails, sprawling Excel files, or ageing Access databases? There’s a better way — and I can show you exactly what it looks like. I’m the Technical Director of Vantage 365, a Microsoft solutions consultancy working with clients across the UK, the Netherlands, and worldwide. For over 30 years I’ve been turning messy, manual business processes into clean, automated systems that save time, reduce errors, and give teams the visibility they need to make better decisions. SharePains is not just any blog run by a Microsoft MVP. Have you ever used Try-Catch in Power Automate? The original post about Try-Catch in Power Automate can still be found on this site, https://staging.sharepains.com/2018/02/07/try-catch-finally-in-power-automate-flow/ Or have you ever used the Pieter’s method to avoid variables and speed up your flows? https://staging.sharepains.com/2020/03/11/pieters-method-for-advanced-in-flows/ You can contact me using contact@staging.sharepains.com
Leave a Reply
You must be logged in to post a comment.