Unanswered

Display Displayname from SharePoint people field in Powerapps gallery

(2) Share

Report

Posted on by Community Power Pla...

Hello,

I have created a SharePoint list where I have a People column named as "PendingWith". I have connected this SharePoint list to my Gallery in PowerApps. For one of the label in the gallery, when I add the following formula

ThisItem.PendingWith.DisplayName

it showcases an error "Expected text value.PendingWith.Text". How can I fix this?

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (18)

Report

The error is normally caused by the SharePoint people/group column being set to allow multiple values and the label in PowerApps which expects a text string doesn't know what to do with it.

If the multi select is enabled for the column and that is what you want then you can concat the data into a string and display it in a label.

Example: Concat(ThisItem.PendingWith, DisplayName, "; ")

2 people found this reply helpful.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

What a neat trick @Jeff_Thorpe ! Thanks for the solution, worked great. Marking as solution.

Cheers,
AK

Was this reply helpful? Yes No
jkb6011 122 on at

Like (0)

Report

@Jeff_Thorpe - What about when Multi Select is turned off? I have it turned off and receiving error.

Was this reply helpful? Yes No