cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Aiyaa
Frequent Visitor

Sequential approval from multiple choice column

Hello everyone, 

 

As the title suggests, I'm basically trying to make a sequential approval from a multiple selection allowed choice column.

 

So I have a choice column that allows multiple selections, and this column contains approvers' names. 

What I want to be able to do is, once a user selects approvers' names in the sharepoint list, it will send approval in order, sequentially. For example, let's say approvers' names are 1, 2, 3, 4, 5, 6, 7, 8. If a user selects 1, 4, 7, then an approval will first go to 1, then once 1 has approved the approval, it will go to 4 and once 4 has approved the approval, then the approval will go to 7. 

 

I have tried and searched but I can't seem to be able to find the solution for this.

Please help. Thank you. 

 

 

 

6 REPLIES 6
manuelstgomes
Super User
Super User

HI @Aiyaa 

 

You need to get the item from SharePoint and loop all the names. Then send an approval and wait to each of them. Since the approval waits before continuing, then you'll be able to send the approvals one by one.

 

Here's a mock Power Automate with this.

2019-12-27 16_29_29-Edit your flow _ Power Automate.png

 

Is this what you need?

 

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

Cheers
Manuel

Hello Manuel,

Thank you for the reply. 

 

I believe an issue might be grabbing an email address of the approvers. Again, the choice column (with multiple selections allowed) consists of only names, not email addresses. How would I also be able to grab that? I know I'd have to use search for users but where should I put it? 

 

Hi @Aiyaa 

 

You need to change in sharepoint to a "People" column. Then you can get that information. Something like this:

2019-12-27 16_23_38-Create Column.png

 

Then you can get the email, department, etc.

 

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

Cheers
Manuel

I agree, except the users might choose anyone they'd like because person/group column will let you choose anyone of our employees. That's why we went for choice column so that we can limit the approvers and plus the users know who the approvers are. 

Hi @Aiyaa 

 

Makes perfect sense. Then you need to do an extra step. You need to find that person first and then fetch the email. Something like this.

2019-12-27 17_03_47-Create your flow _ Power Automate.png

 

Notice that, since we're searching by name, even if we search limiting to 1, we get an array so we need to use a "Apply to each".

 

Makes sense?

 

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

Cheers
Manuel

 

Hello Manuel,

 

How did you get this dynamic content "Name?" 

I'm not able to find this.

Also, because we're bringing multiple names from the sharepoint list, how would we separate the names and find email addresses for each of them? 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,954)