Power Platform Community Forum Thread Details

Filtering Office365 users not returning all users

I have a multi select Combo Box with Items set to Office365Users.SearchUserV2({searchTerm:ComboBox2.SearchText,top:999}).value

This allows multiple users to be selected, and when the save button is pressed the results are written to a collection , and then patched to a dataverse table as a separate record for each user saved in the Operational Director column, along with an application name taken from a variable VarSelectedAppsRecord. This works ok, and I am able to select users without any problem, and save them to dataverse.

I then want to be able to edit the selection via an edit button, so I have set DefaultSelectedItems of the ComboBox2 to Filter(Office365Users.SearchUser({top:999}),DisplayName in Distinct(Filter('Applications Database - OppDirs','Application Name'=VarSelectedAppsRecord.'Application Name'),'Operational Director'))

so that the ComboBox2 can be populated with the users names saved earlier. I have also set the items to Office365Users.SearchUserV2({searchTerm:ComboBox2.SearchText,top:999}).value

so you can also select new users.

I then have a Gallery to display the results, i,e User Photo, Display Name , E-mail, and office, I have set the image property of the User Photo to - If(!IsBlank(ThisItem.Mail),Office365Users.UserPhotoV2(ThisItem.Mail),NoEmailImage) to get round the blank photo error that i got.

This is when I have a problem in that not all the users names are populated in the ComboBox2 , I have been looking into this and think that the issue is the limit of office365 only searching 999 users, so not all the users are found. I understand that there is an office365.searchusersV2 , which I was hoping might have a bigger limit, but I am unable to change the above filter to V2 and make it work. I am new to PowerApps and i am stuck as to how to get this to work, so any help would be appreciated.

Categories:

General Questions

Quick Links

Subscribe to this forum!