cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

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?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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
Highlighted
Dual Super User III
Dual Super User III

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!
Highlighted

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

 

 

Highlighted

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

Highlighted

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

Highlighted

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!
Highlighted

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.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (11,742)