How to pull list of all office 365 users list in PowerApps?

[dave8]

Hello,

I want to display list of all office 365 users in dropdown list by default.

I have tried, following formula, but it only displays the list of user having "John" character, how can I by default pull list of all Office 365 user?

Office365Users.SearchUser({searchTerm:"John"}).Mail

How can I achieve that?

Thanks

[VijayTailor]

Hi Dave,

you can use formula Like below also.

Filter(Office365Users.SearchUser(), OfficeLocation <>Blank())

Hope it will resolve your issue.

[dave8]

Hi @VijayTailor 

This still doesn't shows all users as it only shows based on search criteria. I require to have list of all default O365 users which could be more than 10K+ users considering that canvas app has 2000 records limitations to fetch.

Thanks,

[VijayTailor]

Hi,
Hope this below solution help you to resolve your issue.

This is the Code Used for that - 
Filter(Office365Users.SearchUser({searchTerm:TextInput3.Text, top:999}), OfficeLocation <>Blank())

Please Find the below link for Demo.

https://drive.google.com/file/d/1QeM2qp9qTWGFqSuTMb7_OHYbneAjF8yz/view