Combobox Users from Sharepoint List

[Zaneeee12]

I have a Combobox that I want to get a list of users into.  The users are in a Sharepoint List, in a 'People or Group' field.

In my case they are Credit Card Approvers.

But when I run the app, and click the drop down, nothing drops down.  I also cant type in to search.

(I tried to copy this - Solved: Combo Box populated with values from user list in ... - Power Platform Community (microsoft.... )

Any ideas please?

[v-xiaochen-msft]

Hi @Zaneeee12 ,

If you want to use the search function of combo box control, please set the IsSearchable property to true.

// Test is a 'People or Group' column.

It should be noted that this method can only search but not open the drop-down list.

If you want to expand the drop-down list and search for users, I will suggest you another method.

(Use Office365Users connector)

1\ Add a combo box control and set its Items property to:

Office365Users.SearchUser({searchTerm:"",top:500})

2\ Set the combo box control's IsSearchable property to:

true

If you use an edit form and use SubmitForm() function to submit data, you could use this formula on Update property of your person datacard.

{Claims:"i:0#.f|membership|"&DataCardValue2.Selected.Mail,Email:DataCardValue2.Selected.Mail,Department:"",DisplayName:"",JobTitle:"",Picture:""}

// DataCardValue2 is the name of my combo box control.

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

[Zaneeee12]

Thanks for this @v-xiaochen-msft   I tried the top option, but it gave me a list of all users, not just those users in that column already.  Is there a way to limit it?

The bottom option looks like its designed to give me all users, which is not what I am after.  So i did not try that.

[indhaa]

Hi

You could create an Office365group and add the users. In the inverted commas you need to add the group ID

[Zaneeee12]

thanks @indhaa , I am looking to use a more user controlled/dynamic list from sharepoint.   Does this mean its not possible to filter a list of users from a list in sharepoint?

[v-xiaochen-msft · Accepted solution]

Hi @Zaneeee12 ,

Now, I know your needs. 

Please try this formula on Items property of combo box control:

AddColumns(LIST106.Test,"aa",Test.DisplayName)

// LIST106 is the list name. 'Test' is a Person column. 

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

[indhaa]

I think you can prompt the user from SharePoint People/group group but i haven't used it in my app.
I use office365group because it is easier for me to manage the access from AD. 

I have to test it too

[Zaneeee12]

This worked great thank you @v-xiaochen-msft .  Perfect.

To expand on this, is it possible to add two columns then add them to a collection ?