Answered

GET ALL USER FORM OFFICE 365

(0) Share

Report

Posted on by Gorilla_8

I already tried with the user filter from the office 365 connector, but I want to get all users and their data (there are more than 5000 users)

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (1)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Gorilla_8 ,

Could you tell me:

Did your formula return a nextlink?

Best Regards,

Wearsky

Was this reply helpful? Yes No
Gorilla_8 on at

Like (0)

Report
Copy link

Link copied!

@v-xiaochen-msft

Yes, indeed, what I do?

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Gorilla_8 ,

The function has a parameter called skiptoken.

Please try to add the whole nextlink or a part of it into this parameter.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Gorilla_8 on at

Like (0)

Report
Copy link

Link copied!

ok, @v-xiaochen-msft so what I do with this information?

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Gorilla_8 ,

Best Regards,

Wearsky

Was this reply helpful? Yes No
Gorilla_8 on at

Like (0)

Report
Copy link

Link copied!

Ok, @v-xiaochen-msft

This my code:

Clear(colAllUsers);;ClearCollect(colAllUsers; Office365Users.SearchUserV2({skipToken:"RFNwd......"}).value)

He returned 999 users, not all users...

If I try with this:

Clear(colAllUsers);;ClearCollect(colAllUsers; Office365Users.SearchUserV2({searchTerm:""; skipToken:"RFNwd......"}).value)

The same result

How can I get all users?

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Gorilla_8 ,

It will return 999 users at a time.

You need to use a new nextlink to get more users.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Gorilla_8 on at

Like (0)

Report
Copy link

Link copied!
@v-xiaochen-msft

Ok, so I do this:

Clear(colAllUsers);; ClearCollect( colAllUsers; Office365Users.SearchUserV2( { top: 999 } ).value; ClearCollect( colAllUsers; Office365Users.SearchUserV2( { top: 999 } ).value; ClearCollect( colAllUsers; Office365Users.SearchUserV2( { top: 999 } ).value; ClearCollect( colAllUsers; Office365Users.SearchUserV2( { top: 999 } ).value ) ) ) )

And returned 1998, is somenthing wrong?

Was this reply helpful? Yes No
Gorilla_8 on at

Like (0)

Report
Copy link

Link copied!

@v-xiaochen-msft

I checked and its duplicate the users

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (4)

Report
Copy link

Link copied!
Hi @Gorilla_8 ,

I did a sample for you.

1\ Add a button control and set its onselect property to:

Clear(Col);Set(varNextlink,Blank());Set(varNextlinkTemp,Blank());Set(varSkiptoken,"");With(Office365Users.SearchUserV2({searchTerm:""}),Collect(Col,ThisRecord.value);Set(varNextlink,ThisRecord.'@odata.nextLink');Set(varSkiptoken,Mid(varNextlink,Find("skipToken",varNextlink)+10)));Set(varNextlinkTemp,varNextlink)

2\ Add a toggle control and set its Default property to:

If(varNextlinkTemp=Blank(),true,varNextlinkTemp=varNextlink,false,true)

Set the toggle's OnCheck property to:

Set(varNextlinkTemp,varNextlink)

Set the toggle's OnUncheck property to:

If(varNextlink=Blank()&&varNextlinkTemp=Blank(),Blank(),With(Office365Users.SearchUserV2({searchTerm:"",skipToken:varSkiptoken}),Collect(Col,ThisRecord.value);Set(varSkiptoken,Mid(ThisRecord.'@odata.nextLink',Find("skipToken",ThisRecord.'@odata.nextLink')+10));Set(varNextlink,ThisRecord.'@odata.nextLink')))

Set the toggle's visible property to:

false

Best Regards,

Wearsky

Was this reply helpful? Yes No