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

Announcements

News and Announcements icon
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.

Screenshot (41)_1.png
Screenshot (40)_1.png
Categories:
I have the same question (0)
  • Manish Solanki Profile Picture
    15,167 Moderator 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.

    Screenshot (42)_1.png

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 604

#2
Valantis Profile Picture

Valantis 502

#3
Vish WR Profile Picture

Vish WR 417

Last 30 days Overall leaderboard