web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get values from Multi ...
Power Automate
Unanswered

Get values from Multi select Person/group field sing Power automate

(0) ShareShare
ReportReport
Posted on by 559

Hi All,

I am building an flow to get Values from SharePoint. I have a column called Project Team in SharePoint which is a multi selection Person or group type. I am using Get items to get the Values from the SharePoint list. If I try to get the Project Team column values using create a HTML table from the Get items or Using Append to Array variable it is creating a Apply to each separate block every time. Even though it creates Apply to each it is not getting proper values. I have attached the screenshot for the same. 

Any help/suggestion on this would be greatly appreciated.

 

Thanks in advance.

Categories:
I have the same question (0)
  • ManishSolanki Profile Picture
    15,091 Super User 2025 Season 2 on at

    Hi @Uthhra 

     

    Pls refer the below sample flow:

     

    We will use "Select" action to collect the display name from multi select people field which is an array inside "Apply to each" action.

    ManishSolanki_0-1692937059009.png

     

    next, click 'Switch Map to text mode' button present on the extreme right side of "Map" property:

    ManishSolanki_1-1692937135159.png

    We will write an expression to get the display name of each user from the multi select field (array):

    ManishSolanki_2-1692937282779.png

    Below expression needs to be entered into the expression window as highlighted in the above screenshot:

    item()?['DisplayName']

     

    Now, we have collected all the names, and we can use another expression with join() function to create a single string of comma separated names:

    ManishSolanki_3-1692937444494.png

     

    You can use the output of Compose action in "Create HTML table" action to show the users names from multi people field:

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

    Thanks

     

  • Sri Profile Picture
    559 on at

    @ManishSolanki 

    It is working but if I give the output of the html table in a mail part I am getting the name with the bracket. And the column Overall Status is a multi line text which is coming along with the Div part and the Overall RAG is a choice column which has three choices (Red, Amber, Green). Which ever color values comes it must have the same background color. Both is also creating separate blocks again.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard