web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : 2sOP+JAh1V1JRvRwVZWG4i
Power Apps - Microsoft Dataverse
Unanswered

Filtering Office365 users not returning all users

Like (0) ShareShare
ReportReport
Posted on 23 Feb 2024 11:12:06 by

Hi

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:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Featured topics

Loading complete