cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JR-BejeweledOne
Super User
Super User

Display SharePoint peeople-picker values

I have a PowerApp that is being used to display information.   A location will be selected from a dropdown and the requested information will then be displayed. 

 

I need to display the contents of a People-Picker column from the SharePoint source list.   This column may contain multiple people.  Once I changed the column to allow multiple selections, it broke the display.   

 

How can I display the contents of this People-Picker column when there are multiple values?

 

 



If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.
1 ACCEPTED SOLUTION

Accepted Solutions

Hi @JR-BejeweledOne 

 

To display email address separated by a comma, you can use:
 
Concat(ThisItem.'Contact Name',Email,",")
 
This returns a text value.
 
Hope this Helps!
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

6 REPLIES 6

Hi @JR-BejeweledOne 

 

Can you share more details about the control that you are referring to? Also, are you getting any error message? If, so please share the error message. Also, please make sure in case of multiple selection, the default is set using the "DefaultSelectedItems" of the combobox control.
 
Hope this Helps!
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

This PowerApp is displaying information contained in a SharePoint list.   It is not going to be submitted or updated by the end user.  It is for display purposes only.  The only interaction with the end user is for them to select a value from the dropdown.  When they select that, it will display the information for that item.

 

What I am trying to do is to display the information contained in a SharePoint People Picker column that has multiple values in it.  I am getting an error in the 'Items' formula.

 

Peoplepicker3.png

 

peoplepicker1.png

 

peoplepicker2.png

 

 



If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.

Hi @JR-BejeweledOne 

 

To display email address separated by a comma, you can use:
 
Concat(ThisItem.'Contact Name',Email,",")
 
This returns a text value.
 
Hope this Helps!
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

That solved part of it.   It now gives me the email addresses but it looks like this: 
Any idea how to get rid of the quotation mark and the extra space top and bottom?

peoplepicker4.png



If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.

Hi @JR-BejeweledOne 

 

Is this an person type field? I don't understand why you are getting the " and extra spaces if this is a person field. To remove the extra spaces and quotations, you can use the expression:
 
Substitute(Substitute(Concat(ThisItem.'Contact Name',Email,","),Char(34),"")," ","")
 
Hope this Helps!
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

I edited my original response and it apparently didn't go through.  My apologies. 

 

I had an extra label on the canvas that I couldn't see and it was interfering.  Once I removed it, all was well.   Your solution was spot-on!   Thanks again.



If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (4,318)