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

Community site session details

Session Id : mb7HStnpKqzHF1gbDW5iWW
Power Automate - Building Flows
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 25 Aug 2023 04:04:56 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.

I have the same question (0)
  • ManishSolanki Profile Picture
    15,089 Super User 2025 Season 2 on 25 Aug 2023 at 04:26:22
    Re: Get values from Multi select Person/group field sing Power automate

    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 25 Aug 2023 at 04:41:50
    Re: Get values from Multi select Person/group field sing Power automate

    @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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 655 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 371 Moderator

#3
chiaraalina Profile Picture

chiaraalina 276

Last 30 days Overall leaderboard
Loading complete