Unanswered

Collect user list for offline app

(0) Share

Report

Posted on by AngusWalker

168

I am building an offline app but need to collect a list of all the Office365 users.
I can collect the first 999 users with

ClearCollect(
 employees,
 Office365Users.SearchUserV2(
 {
 top: 999
 }
 )
)

but how do I collect the rest? (we have about 3500 users)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

AllanDeCastro 412 Most Valuable Professional on at

Like (0)

Report

Hello,
Hello,

Have you tried to define a value greater than 1000 ?

According to the documentation, this is not a limit of 1000, but a default value, maybe the documentation is not correct, but would love to confirm it first with you:

Was this reply helpful? Yes No
AngusWalker 168 on at

Like (0)

Report

@AllanDeCastro Yes. I tried 2000, but then I get nothing.

Was this reply helpful? Yes No
AllanDeCastro 412 Most Valuable Professional on at

Like (0)

Report

I would recommend you to open a Support Request so, as I'm not sure that the documentation is aligned.

Was this reply helpful? Yes No
AngusWalker 168 on at

Like (0)

Report
@AllanDeCastro it says that 1000 is the maximum, but I guess someone at Microsoft used a < instead of a <= because the most you can get is 999.
There are lots of examples if you google it (And search on here) where it shows 999 is the max.

However, I have discovered there is a skipToken that returns the next 999:
Clear(employees); Collect( employees, Office365Users.SearchUserV2({isSearchTermRequired: "No", top: 999}).value ); Set(employees1_skip, Last(Split(Office365Users.SearchUserV2({isSearchTermRequired: "No"}).'@odata.nextLink',"=")).Value); Collect( employees, Office365Users.SearchUserV2({isSearchTermRequired: "No", skipToken: employees1_skip}).value ); Set(employees2_skip, Last(Split(Office365Users.SearchUserV2({isSearchTermRequired: "No", skipToken: employees1_skip}).'@odata.nextLink',"=")).Value); Collect( employees, Office365Users.SearchUserV2({isSearchTermRequired: "No", skipToken: employees2_skip}).value ); ...
However, I am getting all the service and resource accounts, so I am finding thousands more records than just the 3500 I need.
I can filter the records I need but only after I capture them all.
I need to construct some sort of loop, but without being able to use 'Set' in a 'ForAll' loop, this is proving difficult.

Was this reply helpful? Yes No