Dynamic Approvals in Power Automate | SharePoint List based Approval Tutorial 04-04-2022 06:16 AM

[RezaDorrani]

Hello everyone,

In this step-by-step Power Automate tutorial video, we will explore creating a dynamic Power Automate Approval workflow process based on an Approval Matrix (SharePoint Configuration List). The SharePoint list will drive the entire approval pattern. List will track information like Approval required, Manager Approval needed, Approval Type (First to respond or Everyone must Approve) & the Approver list (multiple approvers).

Power Automate Dynamic Approvers: The entire Approval flow in Power Automate will be driven from the Approval Matrix. Updates to the configuration list will dynamically update the approval pattern.

Power Automate Dynamic Approval Type: We will also provide the user an option to select the Approval Type / Pattern - "First to respond" or "Everyone must Approve".

Topics covered:

✔️ Build an Approval Matrix

✔️ Dynamic approvers & approval type selection from Configuration List

✔️ Build Power Automate flow to drive the Approval Scenario

⬇️ Download sample Dynamic Approval workflow from Approval Matrix:

https://github.com/rdorrani/Microsoft-Flow/tree/master/ApprovalMatrix 

Expression for Dynamic Approval Type

if(equals(outputs('ApprovalInfo')['ApprovalType/Value'],'Everyone must Approve'),'BasicAwaitAll','Basic') 

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

watch?v=R18_qYVPWl4

[demzem]

solved

[LyonsCDK]

Reza, thank you for this great instructional video!!  I'm relatively new at Automate. I've created standard flows, but I'm working on my first approval flow request.  This looks like what our customer wants, but our process doesn't have a topic that will drive the approval.  Instead, it is based on whether the person checks yes that either development is affected (YN), architecture is affected (YN), or both are Y.  In our case, we have 4 scenarios.  In scenarios 2-4, all must approve.  Can this be done with your flow as the backbone?

1. Main approver (both questions below = N)

2. Main approver + development manager (Does this change request affect the dev/engineering team? Y)
3. Main approver + architecture manager (Does this change request affect the Architecture team? Y)
4. Main approver + architecture mgr. + development mgr.  (both questions above = Y)