cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

People Picker filter

Hi All, 

I try to insert a combobox with the members of my company (150employees). I don't know how to do. This is what I already try : 

1. Create a Distribution list with the 150 persons.
Items = Office365Groups.ListGroupMembers('id').value
Problem : The limit of the combobox is 100 items. 

2. Create a SharePoint People or Group column and insert it in PowerApps. 
Problem : it gives the name of the 40K world group members

2b Properties of the people or group = not all users but a sharepoint group. 
Problem : If I add the distribution list to the group, the combobox is made up of the DL and not the members of the DL. 
Problem ; I don't want to add them individually into the SP group because it would be a lot of work to add a new employee (there is a big turnover). And I didn't find a way to sync with a DL. 

3. Copy all the members into an Excel file and select the Excel file as the Data source of the combobox. 
Problem : the search field doesn't reset so you can see what the previous entry type. There is no solution for now. 

Does anyone could help me ? 
Thanks a lot  !! 


1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: People Picker filter

Hello Martindeter,

 

The following should work in the current release, or in the release the one that should go publick in a couple of days:

ComboBox1.Items = Office365Users.SearchUser({searchTerm: TextInput.Text}) where Text Input control holds the search string.

The following should work in a release that should go public in the second half of April:

ComboBox1.Items = Office365Users.SearchUser({searchTerm: ComboBox1.SearchText})

View solution in original post

16 REPLIES 16
Highlighted
Microsoft
Microsoft

Re: People Picker filter

Hello Martindeter,

 

The following should work in the current release, or in the release the one that should go publick in a couple of days:

ComboBox1.Items = Office365Users.SearchUser({searchTerm: TextInput.Text}) where Text Input control holds the search string.

The following should work in a release that should go public in the second half of April:

ComboBox1.Items = Office365Users.SearchUser({searchTerm: ComboBox1.SearchText})

View solution in original post

Highlighted
Anonymous
Not applicable

Re: People Picker filter

Thanks for your answer !

Highlighted
Anonymous
Not applicable

Re: People Picker filter

Any update on this. We are eagerly waiting on the single combobox solution as the other method is very confusing for users. Was this working previously and was broken or was never working?
Highlighted
Microsoft
Microsoft

Re: People Picker filter

Hello diggity,

 

I just added a ComboBox and a Text Input control, with the following formula and it worked fine for me. 

ComboBox1.Items = Office365Users.SearchUser({searchTerm:TextInput1.Text})

 

Can you please provide the details of the issue you see?

Thanks,

Highlighted
Anonymous
Not applicable

Re: People Picker filter

correct this is working but not a good solution.  We do NOT want two boxes to serve the purpose of one. 

 

This is what we want to work.

 

ComboBox1.Items = Office365Users.SearchUser({searchTerm: ComboBox1.SearchText})

 

Highlighted
Microsoft
Microsoft

Re: People Picker filter

As mentioned in my previous message. that fnuctionality should be released in the second half of April. I'm sorry I cannot provide a precise release date.

Highlighted
Super User II
Super User II

Re: People Picker filter

Hi all.

 

Yes, the same is happening on my side. It used to work fine with the combobox, but now the searchtext seems to be reset as soon as the search starts. This can be seen by viewing the searchtext as a label.

 

Looking forward to this being resolved, we are using comboxes for address lookups quite extensively.

Highlighted
Super User II
Super User II

Re: People Picker filter

Good day everyone.

 

We noticed that even though the above method of using the Office365.SeachUser is broken current, if you tie the items back to a SharePoint list column and have SharePoint do the lookup, it works great.

 

a) Create a SharePoint list with a person field that allows username selection. We usually have a generic SharePoint site that we use for PowerApp system related configuration which is ideal for this list.

b) Add the SharePoint list as a datasource to your PowerApps, even though you are not planning to write any data to it.

c) In your Combobox - Items:

Choices('SharePointDataSourceName'.PersonLookupColumnName)

d) Set the SearchFields to:

["Claims"]

e) Set the DisplayFields to:

["DisplayName","Email","Picture"]

 

This also seems to be delegating some of the work to SharePoint and is quite a bit faster than doing the Offic365users.Search in the items property directly.

 

The multi-select also works better than it did with the previous method.

 

Have a great day everyone!

 

 

Highlighted
Anonymous
Not applicable

Re: People Picker filter

This is a good option but i cannot find a way to return the userid of the user from this search and this is something that we need.  Is there a way to do so with this method?  Additional any update on the below method working? We are now in May and this still does not work.

 

ComboBox1.Items = Office365Users.SearchUser({searchTerm: ComboBox1.SearchText})

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (3,200)