How to show a SharePoint multi select people picker on a screen

(1) Share

Report

Posted on by FW-07051511-0

160

Hello,

I have a SharePoint column that is a multi-select people picker. I am not using forms. I have figured out how to patch the people from the Power Apps screen but now I cannot figure out how to display the multi-select people on the screen.

I don't know if I need a combo box setting DisplayMode.View and populate the combo box or what.

Can someone point me in the right direction?

EDIT: I am using all modern controls.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Suggested answer

Haque 3,653 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @FW-07051511-0,

To display a multi-select People Picker SharePoint column in Power Apps (without using forms), you typically use a Gallery or ComboBox to show the selected people.

Since the SP multi-select people column stores an array of person objects, you need to bind your control to that array and display the relevant fields (like DisplayName or Email).

For Gallery or ComboBox : Set the Items property of the Gallery or ComboBox to the multi-select people column of the selected record, for example:

Gallery.Items = ThisItem.PeopleColumn

Show DisplayName or Email: Inside the Gallery or ComboBox, let's add a Label control and set its Text property to:

ThisItem.DisplayName //-- or ThisItem.Email

Let's follow this solve thread here.

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

Was this reply helpful? Yes No
FW-07051511-0 160 on at

Like
a
(0)

Report
Copy link

Link copied!
@Haque

I am not quite following you recommendation. Can you explain further with the use of a combo box. I have a combo box

Items = Office365Users.SearchUserV2({isSearchTermRequired:true,searchTerm:Self.SearchText}).value

but I cannot figure out how to show the already selected users. I guess I don't know what would go into DefaultSelectedItems

Was this reply helpful? Yes No
Verified answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @FW-07051511-0,

Since your ComboBox Items property is returning Office365 user records.

DefaultSelectedItems must also receive the same Office365 user record structure.

Try below code - DefaultSelectedItems

ForAll(varSelectedRecord.YourPeopleColumn As _obj, LookUp(Office365Users.SearchUserV2({searchTerm: _obj.Email, isSearchTermRequired: false } ).value, Mail = _obj.Email ) ) //varSelectedRecord.YourPeopleColumn - Replace with your variable name and column name //varSelectedRecord - User your variable //YourPeopleColumn - User your column name

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Just mention @Kalathiya and I’ll be happy to assist.

✔️ If this answer helped you, please tick “Does this answer your question?” so it can be marked as the Verified Answer.

💛 A Like always motivates me to keep contributing!

Was this reply helpful? Yes No
FW-07051511-0 160 on at

Like
a
(0)

Report
Copy link

Link copied!

@Kalathiya

Below is a screenshot of my attempt but it is giving me an error "Expected table value"

Was this reply helpful? Yes No
Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @FW-07051511-0,

Syntax error: ‘Value V should be lowercase’ in Office365User lookup code due to this you are getting Expect table error.

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

Was this reply helpful? Yes No
FW-07051511-0 160 on at

Like
a
(0)

Report
Copy link

Link copied!

@Kalathiya,

Good eye. Thank you.

Was this reply helpful? Yes No