Lookup on multiuser people picker in SharePoint - displaying usernames

(0) Share

Report

Posted on by nemanjasovic011

240

Hello,

I have screen with a control that looks up SharePoint people picker display name. This column in SharePoint has been changed to multiuser. The app collapsed and I had to fix the formula,. New, adjusted formula seem to be recognizing that there are two users in SharePoint field(please see the screenshot) but it is unable to display username.displayname value of each user.

How can I make sure that display name is shown in the text value for each user in the SharePoint multiselect people picker field. .

Thank you

If(
 'Task Status'.Text = "Not Started" || ID_var = 0,
 "Determined by Brand",
 LookUp(
 ActiveLAFRequests,
 ID = ID_var,
 Concat(
 'Label Buyer'.DisplayName,
 ","
 )
 )
 
)

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

nemanjasovic011 240 on at

Like (0)

Report
Copy link

Link copied!
This is the answer:
f( 'Task Status'.Text = "Not Started" || ID_var = 0, "Determined by Brand", LookUp( ActiveLAFRequests, ID = ID_var, Concat( 'Label Buyer',DisplayName, "," ) ) )

Was this reply helpful? Yes No