Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Request approval by department

I'm trying to set up an approval process for files.  The flow should notify the approvers for each department, and if all approvers approve the file, the status of the file should be set to "approved."


The tricky part is that I'd like the user to be able to specify which departments require approval.


I created a SharePoint list called "Approvers", which lists each department and the users able to approve files:

SharePoint Approvers List.png


Starting with the template Request approval (everyone must approve) for a selected file, I modified the "For a selected file" trigger as shown:

For a selected file.png


I can get a list of the approvers by department by doing this:

Get approvers by department.png


But how do I modify the block below to select only the desired departments?

For each department.png


Much thanks,

Adam J.


Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (3,377)