Modern combobox with form and people picker

(1) Share

Report

Posted on by SEA87

Hello,

I have edit form (classic version) that i modernized by switching from classic combobox to modern version.

For choices column everything is working fine, but for people picker column the combobox is showing nothing, even if i have few people selected in my sharepoint list.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Akah Mandela 445 on at

Like (3)

Report
Copy link

Link copied!
I think You need to set the Items property of the combo box to a formula that retrieves the person field values from the list, and also set the DisplayFields property to show the relevant information, such as DisplayName or Email.
For example, you can use this formula in the Items property of the combo box:
Distinct('YourSPList'.PersonField, PersonField.DisplayName)
This will return a list of distinct display names from the person field in your SharePoint list. You can also use other properties of the person field, such as Claims, Department, JobTitle, etc.
Then, you can use this formula in the DisplayFields property of the combo box:
["DisplayName"]
This will show the display name of the person in the combo box. You can also add other fields, such as Email, JobTitle, etc.

Was this reply helpful? Yes No
SEA87 19 on at

Like (2)

Report
Copy link

Link copied!

Thank you @mandela. The distinct function worked perfectly.

Was this reply helpful? Yes No
DublinOH_User 150 on at

Like (2)

Report
Copy link

Link copied!

Hello;
This is not making sense to me. There is not a 'DISPLAYFIELDS' property for a modern form people picker value field, not for the data card.
In what property field can the display, email, claims be set? For a modern people picker sorced from a Sharepoint list?

Was this reply helpful? Yes No
Suggested answer

JS-22091932-0 2 on at

Like (1)

Report
Copy link

Link copied!
The answer above solved for pulling data into the Items box, but there were blank entries when I used the dropdown control.

If you're getting blank entries on the combo box like I was, change your Items property to:

RenameColumns(Distinct('YourSPList'.PersonField, PersonField.DisplayName),Value,DisplayName)

Was this reply helpful? Yes No