Skip to main content

Notifications

Power Automate - Building Flows
Answered

Building approval process with N number of approvers, depending on requester details

(1) ShareShare
ReportReport
Posted on by
Hello,
I am creating an approval process that requires all more senior management to approve.  Depending on the requester's management level, this could be 1-6 levels of approvals, all required to be in sequential order.
Variables have all been set, but I am wondering how to assign the approvals without having to create 6 different conditional streams.
(I tried Assigned To, but if a field is blank, it errors out) 
 
Ex
1. Requester: Supervisor
    Approvals in order: Manager ⇒ AGM ⇒ GM ⇒ SM ⇒ MD ⇒ VP
 
2. Requester: SM
    Approvals in order: MD ⇒ VP
 
 
 
  • Verified answer
    FLMike Profile Picture
    FLMike 29,419 on at
    Building approval process with N number of approvers, depending on requester details
    Hi
     
    One option would be to do this
     
    1. Have a sharepoint list that has mappings like you showed (which was perfect), where the line key is the MD, or VP or whatever string you have.
     
    So in your flow, figure that out
     
    then in the list, you would have the ; seperated list of email addresses it would go to, depending on which Key you found
     
    2. Use that value in the Email (to)
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard