cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
natb123
Regular Visitor

select approvers for certain values

Hi wondering if anybody could help 

 

ive made a flow where when a form is submitted they select who they need approval from based on the value of their request, at the moment the approval is just going to one person who is having to re-assign, below is my flow if anyone can help as im new to this 

 

Thanks 

natb123_0-1657789240937.png

natb123_1-1657789308521.png

natb123_2-1657789381197.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
MarconettiMarco
Super User
Super User

Hello @natb123 ,

as per my understanding, you want to automatically assign the Approval to a specific person based on the request amount.

I think you can easily to it by referring to a specific SharePoint list where you store the Approver:

1. Create a SP list like below (the Approver is a "Person or Group" column type):

MarconettiMarco_0-1657791494722.png

2. in your flow add the "Get items" action in which search for Amount equal to the value passed from the Forms response and add the Top Count equal to 1:

MarconettiMarco_1-1657791590408.png

3. Add the "Get item" action in which add the following expression in the Id in order to avoid the Apply to each loop:

first(outputs('Get_items')?['body/value'])?['ID']

MarconettiMarco_2-1657791614907.png

4. Start your approval by adding the "Approver email" value grabbed from the Get item action:

MarconettiMarco_3-1657791697385.png

 

With this approach you don't need the Switch control.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

 

 

 

 

View solution in original post

1 REPLY 1
MarconettiMarco
Super User
Super User

Hello @natb123 ,

as per my understanding, you want to automatically assign the Approval to a specific person based on the request amount.

I think you can easily to it by referring to a specific SharePoint list where you store the Approver:

1. Create a SP list like below (the Approver is a "Person or Group" column type):

MarconettiMarco_0-1657791494722.png

2. in your flow add the "Get items" action in which search for Amount equal to the value passed from the Forms response and add the Top Count equal to 1:

MarconettiMarco_1-1657791590408.png

3. Add the "Get item" action in which add the following expression in the Id in order to avoid the Apply to each loop:

first(outputs('Get_items')?['body/value'])?['ID']

MarconettiMarco_2-1657791614907.png

4. Start your approval by adding the "Approver email" value grabbed from the Get item action:

MarconettiMarco_3-1657791697385.png

 

With this approach you don't need the Switch control.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

 

 

 

 

Helpful resources

Announcements
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 (4,122)