How to retrieve more than 999 users from the AZ using Office365Groups.ListGroupMembers connector?

(1) Share

Report

Posted on by Tomasz Kasinski

As per topic?

Any call to a group with less than 100 users works as a charm. However when I try to use a sort of pagination (remember this is about Canvas app not Power Automate) in a style like below, somehow the collection ends up with 300 users! When I change sequence to (11) I end up with exactly 1100 users. This seems impossible as the group contains only 1096 users.

Cheers

// Loop to fetch members in batches of 500

ForAll(
Sequence(3), // 3 batches needed for 1096 members
Collect(
Users,
Office365Groups.ListGroupMembers("xxxxxxae-xxxx-xxxx-xxxx-xxxxxxxxxxxx", { Top: 500, Skip: (Value - 1) * 500 }).value
)
);

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

IAmIntractable 280 on at

Like (0)

Report

You may have to embed a flow and call the Graph API to get more data. Seems like all the built-in features try to limit results.

Was this reply helpful? Yes No
Tomasz Kasinski 39 on at

Like (0)

Report

Sorry for a confusion. I should have add - how to do this in Canvas apps only without flows and graph calls. So the answer is "not possible" ?

Was this reply helpful? Yes No
timl 36,411 Super User 2025 Season 2 on at

Like (1)

Report

Hi @Tomasz Kasinski

If you use the technique that's shown in the documentation, does that make a difference (ie, to parse the $skipToken value from the @odata.nextLink)?

https://learn.microsoft.com/en-us/connectors/office365groups/

Was this reply helpful? Yes No
Suggested answer

DavidZoon 738 Most Valuable Professional on at

Like (0)

Report

The easiest way is to use an embeded flow, trying to use pagination in power apps directly will first of all be very complex to set up and moreover, the loading time of the collections will be longer than via a flow

Was this reply helpful? Yes No
Tomasz Kasinski 39 on at

Like (1)

Report

timl (sorry the {at} interface does not pick your name :(

I tried that early on and it seems broken as no matter how many pages I will paginate it always only return the first page almost as the $skiptoken is a dead command. Top works fine even some weird combination of Top:100 Skip:100 + 100*value seems to do something only to realise the first 100 users are returned per EACH page meaning I end up with the collection of the same 100 users replicated as many times as there are pages.

Was this reply helpful? Yes No
Tomasz Kasinski 39 on at

Like (1)

Report
For the sake of clarity I used the simplest approach and the below code does return 999 users as expected:

Collect( Users, Office365Groups.ListGroupMembers("xxxx-xx-xx-xxxx-xx", {'$top':(999)}).value

Problem the documentation does not contains information about additional properties or switches (Office 365 Groups - Connectors | Microsoft Learn). I bet I am missing something.

Was this reply helpful? Yes No
timl 36,411 Super User 2025 Season 2 on at

Like (1)

Report

Hi @Tomasz Kasinski

Thanks for the update

With regards to the ListGroupMembers method, there doesn't appear to be any another properties or switches apart from $top. The Intellisense in the designer also doesn't suggest anything other than $top.

It's unfortunate that the $skiptoken method didn't work for you. At this point, perhaps you might consider raising a support ticket? If this method doesn't work as documented in the official MS Learn documentation, I would hope that MS fixes this or finds you a suitable workaround.

Was this reply helpful? Yes No