Announcements
I need to pull all office 365 users globally...I know Power Apps only read up to 2000 items, I want to use a collection for all users globally.
I tried this:
Filter(UsersOffice365.SearchUser(); Not(Blank()))
Hi @Gorilla_8 ,
Just to make sure I am understanding this, you want to connect all Office365Users into a collection?
---If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions.
Thanks!
Hardit Bhatia
Microsoft Business Applications MVP
Microsoft Certified Trainer MCT
Blog | Twitter | LinkedIn | Facebook | YouTube | Email
@PowerAddict Yes! I Wanna get all the data of Office365Users
What happens when you do this?
ClearCollect( colUsers, Office365Users.SearchUserV2().value )
@PowerAddict .value is not avaliable
Then you are probably using the SearchUser function. Try using the SearchUserV2 function. I think it gives 1000 records by default.
@PowerAddict
With SearchUserV2 worked thanks, but I need more than 1000, I need all users...
Can you please state your exact use case? I am curious to know why you would need more than 1000 users. If its a searchable combo box, you can always enter the search criteria in this formula to reduce the number of users that meet the criteria.
Exactly what I need, I'm going to use a combobox to pull all users, but when I search for the user, it doesn't appear due to the limitation of 1000 users.
So when he selects the user the email will come in another field to use in Power Automate
What is the Items property of your combo box?
UsuáriosdoOffice365.SearchUser({searchTerm:ComboBox2_1.SearchText;top:999})
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.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 413
WarrenBelz 355 Most Valuable Professional
timl 315 Super User 2026 Season 1
