Dynamic Approvals in Power Automate | SharePoint List based Approval Tutorial

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