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

  • Community Power Platform Member Profile Picture
    on 29 Apr 2020 at 09:02:50
    Re: Approval Workflow - Automatically Selecting Approver from SharePoint List

    No worries now, I've managed to work it out myself. Thanks for the help 😊

  • Community Power Platform Member Profile Picture
    on 27 Apr 2020 at 10:37:32
    Re: Approval Workflow - Automatically Selecting Approver from SharePoint List

    Hi Alex,

     

    Thanks very much for your swift response and apologies to be a pain but could you possibly provide a basic example of how I could start using a switch to determine the relevant user?

     

    Regards,

     

    Jake

  • 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.

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

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

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,743 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,079 Most Valuable Professional

Leaderboard
Loading started
Loading started