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

Multiple Values Person/Names Column

Hi Folks,

 

I have a person column in SP it contains multiple value, I am trying to get that value using Flow via variable, it gets the value but only the last one. Can you assist me with this?

 

Thanks!

4 REPLIES 4
DeepakS
Super User
Super User

Hi @Erramos12 

Multiselect person field will return an array of users claims. so you need to add a loop or filter to get all the values.

MU.PNG

 

items('Apply_to_each_2')?['MultiSelectPerson']

 

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

oThanks @DeepakS for the response can you assist me further, I'm a new with power automate. this is my flow where should I put the code you have recommended items('Apply_to_each_2')?['MultiSelectPerson']Flow2.PNG

 

 

Hello,

You cannot use a Set variable inside a Apply to each loop, unless you set the loops concurrency to 1.
You can set the loops concurrency to 1 by clicking the 3 dots next to the apply to each shape and select settings.
Or
Use the compose action shape as DeepakS picture shows. (Compose actions are not affected by concurrency parallelism.

Thanks.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





v-alzhan-msft
Community Support
Community Support

Hi @Erramos12 ,

 

Could you please explain more details about your requirement for the flow?

 

Best regards,
Alice       
 
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,776)