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

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,047)