cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lam01007
Advocate IV
Advocate IV

How to retrieve multiple users from a multiple user field and put in 'Assigned to'?

hi all,

 

I would like to retrieve multiple users from a multiple user field in SharePoint List.

My requirement is very simple:

1. User can new an eForm(SharePoint List Item) and defined multiple approvers in a single person field in the eForm (I am using PowerApps to new an eForm, this part is OK for me)

2. Base on this person field value, MS Flow will assign multiple approval tasks for these approvers at the same time.

3. The flow will waiting for all of approvers to response.

 

1. I have aPerson column (allow multiple selection)

2. Under the edit Flow page, add "Start and wait for an approval" with the type "Approve/Reject - Everyone must approve", when I select the "Approvers Email" in "Assigned to" field, the "Apply to each" will auto generated and include the "Start and wait for an approval".

 

3. However, if use "Apply for each", it did not meet our required on "Approve/Reject - Everyone must approve", since each iteration will running on different instance. Our goal is want the Flow can retrieve multiple users from single fields and input in "Assigned to", logically look like this:

Any function / workaround can do this?

 

Thanks,

 

Lam

2 ACCEPTED SOLUTIONS

Accepted Solutions
yashag2255
Dual Super User II
Dual Super User II

Hi @Lam01007 

 

You can do this by creating an array of all the users and then pass it in the approval and this will ensure that all the users must approve the request.
 
Please refer to attached screenshot:
 
Here, testperson is the name of field in SharePoint list. You need to use the Approvers field.
MicrosoftTeams-image (45).png
 
Expression Used on Approval:
join(variables('Users'),';')
This will concatenate the list of users separated by a semi-colon.
 
Hope this Helps!
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

hi yashag2255,

 

Thanks for your reply and suggestion, and I found another simple solution for it, just use "Select" as below:

flow4.png

View solution in original post

3 REPLIES 3
yashag2255
Dual Super User II
Dual Super User II

Hi @Lam01007 

 

You can do this by creating an array of all the users and then pass it in the approval and this will ensure that all the users must approve the request.
 
Please refer to attached screenshot:
 
Here, testperson is the name of field in SharePoint list. You need to use the Approvers field.
MicrosoftTeams-image (45).png
 
Expression Used on Approval:
join(variables('Users'),';')
This will concatenate the list of users separated by a semi-colon.
 
Hope this Helps!
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

hi yashag2255,

 

Thanks for your reply and suggestion, and I found another simple solution for it, just use "Select" as below:

flow4.png

Hello Lam,

I can't get this one working... I think it is because of the Select.

What do you put inside it exactly? For me it appears the "From" and then for the "Map" there are two fields to fill in.

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

AI Builder AMA June 7th carousel (up on May 25th, take down June 8th) (1).png

'Ask Microsoft Anything' about AI Builder!

The AI Builder team invite you to ask questions and provide helpful answers at our next AMA.

Users online (1,517)