Answered

Load Office365User table in power apps

(0) Share

Report

Posted on by Bingqiling

321

I'm working in a corporate environment.
I want to retrieve employee information records from the Office365User table from the gallery or data table in POWER APPS. The table called Office365User cannot be viewed in the dataverse.
please tell me what to do

What I currently checked is Office365User().SearchUser(), which contains data.
Employee name, email, etc.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

royg on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Bingqiling,
The Office365Users.SearchUser function has a built limitation of 999 results. You should either consider passing a parameter to filter the query or move it to Power Automate where you can add a Search for Users V2 action which can be paginated, and the threshold can be set to higher volumes,
Your Flow can return the full array (note that in larger organizations this can cause a performance issue).

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Roy

Was this reply helpful? Yes No
Bingqiling 321 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @royg
Is there a way to load Office365User table records using gallery or data table in power apps?
Why can't I connect?

Was this reply helpful? Yes No
Verified answer

royg on at

Like
a
(1)

Report
Copy link

Link copied!

You could use it to get all the users in your organization as long as there are less than 999 (the connector limit).
Set the Items property of your Data Table to:
Office365Users.SearchUserV2({isSearchTermRequired: false}).value
Remember to add the fields you want to display in the table in the Properties panel / Edit Fields

if you have more than 999 users you might want to try the approach suggested by @v-xiaochen-msft :
https://powerusers.microsoft.com/t5/Building-Power-Apps/GET-ALL-USER-FORM-OFFICE-365/td-p/1570631

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Roy

Was this reply helpful? Yes No