Skip to main content

Notifications

Community site session details
Power Automate - Building Flows
Answered

Approval Workflow - Automatically Selecting Approver from SharePoint List

Like (0) ShareShare
ReportReport
Posted on 24 Apr 2020 14:45:19 by

I'm looking at working on an approval workflow and I'm trying to figure out how I can get it to select an approver from a SharePoint list based on various parameters. 

 

Essentially the workflow will be triggered by a user selecting a file from a SharePoint library and it will then need to look at the department, team and document type assigned to said file and then automatically assign (an) approver(s) based on the stage of the approval (initial approval by line managers [document approver 1 & 2]/director level approval [director approver] and then publishing approval [publishing approver]) from the SharePoint List.

 

Document Library:

doc library.png

Approvers List:

approver list.png

I had found something previously regarding a department and approver list variable and then using a get item's action with a filter which was able to drill down and pick an approver using one variable (just department) [find screenshots of this solution below] but now I'm trying to find this based on more variables I'm not certain where to go from here.

initializing variables.png

set department variable.png

get items based on department.png

append to string variable.png

 

Any help/suggestions would be greatly appreciated

  • Verified answer
    alrezac Profile Picture
    on 24 Apr 2020 at 19:31:54
    Re: Approval Workflow - Automatically Selecting Approver from SharePoint List

    Hi Jake,

     

    Looking through your issue here as long as you dont mind hard coding the user you want to send the approval to you could really simplify the complexity of your Flow. Using a switch you could have it go down a tree of options down to a specific user designated for that tree path. From there it would create an approval task and assign it to that person. Once that approval task is done it would do that again and assign it down a tree based on the files department and document type.

     

    Regards,

     

    Alex

     

    -------

     

    Community Support Team _ Alex Rezac
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Building Flows

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 196 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 181 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 169

Overall leaderboard
Loading complete