cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Continued Contributor
Continued Contributor

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

Re: Display SharePoint peeople-picker values

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

Re: Display SharePoint peeople-picker values

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
Continued Contributor
Continued Contributor

Re: Display SharePoint peeople-picker values

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

Re: Display SharePoint peeople-picker values

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
Continued Contributor
Continued Contributor

Re: Display SharePoint peeople-picker values

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

Re: Display SharePoint peeople-picker values

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
Continued Contributor
Continued Contributor

Re: Display SharePoint peeople-picker values

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
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,872)