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 Apps / SP online list - Perso...
Power Apps
Answered

SP online list - Person or Group - Mulitple selection is set to Yes.

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi,

I have below SP online list. In Name column Mulitple selection is set to Yes.

Column Type

Title       Single line of text            

Name    Person or Group

 

SP list ItemSP list Item

 

SelectedItem is a collection in powerapps, it contains sharepoint Item.

 

people3.PNG

 

PowerApps CollectionPowerApps Collection

 

  1. How do I show comma separated Display Names in label. I am Not able to write a formula using Concat. Name column table is confusing.
  2. Since it is in a table format I am not able to it display list content Gallery either.
Categories:
I have the same question (0)
  • Jeff_Thorpe Profile Picture
    6,085 Super User 2024 Season 1 on at

    This assumes the values are in a como box called DataCardValue13.  
    Example:
    Left(Concat(DataCardValue13.SelectedItems, DisplayName & "; "), Len(Concat(DataCardValue13.SelectedItems, DisplayName & "; "))-2)

    In this example we are concatenating the display name of the selected items in the combo box into a string separated by a semi colon. Then we are cleaning up the string by removing the trailing semi colon.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi Jeff, Values are not in the combobox. Values are in the collection. I have one more snapshot in original message for clarity. 

  • Verified answer
    Jeff_Thorpe Profile Picture
    6,085 Super User 2024 Season 1 on at

    Looking at your screenshots I think the collection is called SelectedItem and it only has one row. The column in the collection that has the user names is "Name".  If that is correct then the formula would look like this:

     

    Left(Concat(First(SelectedItem).Name, DisplayName & "; "), Len(Concat(First(SelectedItem).Name, DisplayName & "; "))-2)

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi @Jeff_Thorpe 

    That is correct.

    Left(Concat(First(SelectedItem).Name, DisplayName & "; "), Len(Concat(First(SelectedItem).Name, DisplayName & "; "))-2)

    This is working perfectly fine.

     

    Could you please also help me in displaying list contents in gallery without use of Collection?

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    This worked in gallery!! Thanks a lot.

    Left( Concat(ThisItem.Name, DisplayName & "; ") , Len(Concat(ThisItem.Name, DisplayName & "; "))-2)

    people - gallery.PNG

     

  • Sam110 Profile Picture
    3 on at

    Thank you, I'm looking for this code too. BTW what -2 mean? Or is this the number of name to be displayed on the label? 

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 366 Most Valuable Professional

#2
11manish Profile Picture

11manish 184

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 99 Super User 2026 Season 1

Last 30 days Overall leaderboard