Unanswered

SharePoint Person or Group column without searching

(0) Share

Report

Posted on by JsL

I have a SharePoint custom list with a Person or Group column, and I've customized the edit form for the list in PowerApps.

On the Edit form for items in this list, the combobox for the Person or Group field requires that you type some or all of a person's name to make people appear so you can select them. Instead, I want to set up a combobox or dropdown that just lists all of the people that can be selected when clicked without having to type anything.

These are the current settings for the column in the list:

Does anyone know how to set up a dropdown like this for a person/group column?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

zaphod88 502 on at

Like (0)

Report

I don't think that is possible by default. How do you maintain the permissions for your Sharepoint site? If you use a security group, you could use the Office365Groups connector to list all members. I think you could also create a dynamic AzureAD group that contains all users to list the members in PowerApps. On-prem group members aren't listed (empty collection), at least in my case.

Was this reply helpful? Yes No
JsL 2 on at

Like (0)

Report

@zaphod88 Thanks, that put me on what looks like the right track.

Using the Office365Groups connector's ListGroupMembers function to get a list of members for the Item field of the ComboBox, I can get it to show the people I'm looking for and behave as a dropdown without it making you start typing to display people.

I was able to get the selection to save into the field using this code for the data card's Update property:
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims:"i:0#.f|membership|" & Lower(PersonComboBox.Selected.mail),
DisplayName:PersonComboBox.Selected.displayName,
Email:PersonComboBox.Selected.mail,
Department:"",
JobTitle:"",
Picture:""
}
It looks like I have two issues left to figure out at this point:

First, I haven't figured out how to get the form to load with the current value from the field, so the combobox always loads with nothing selected, even when this person field has a value for the item being edited.

Second, if I submit the form without selecting someone in the combobox, it seems like the form fails to submit any changes at all. I would guess there's an error with the update trying to make a person from nothing, but I haven't figured out how to send "this person field should be blank" yet.

Was this reply helpful? Yes No
zaphod88 502 on at

Like (0)

Report

For first question: You have to do a lookup to your O365 Users collection:
LookUp(O365Coll, ThisItem.[PersonPickerField].Email = mail)

Second: Yep, got that problem as well. I "solved" it by adding an If() clause to see if there is a value selected in the ComboBox and if yes, it is updated (patched), if not not. So maybe you have to take it out of Form submit and add a Patch() to your submit button.
It is also tricky to set people pickers blank. Here is another thread with several approaches in it:
https://powerusers.microsoft.com/t5/Building-Power-Apps/Clearing-out-people-picker-field/td-p/200069

Was this reply helpful? Yes No