Office 365 Groups on returning 100 records

(1) Share

Report

Posted on by iKettle

113

Hi Guys, i have been trying to increase the number of records returned for groups in office 365, but its not giving more. Here is the formula i have tried

ClearCollect(colGroupUsers, Office365Groups.ListGroupMembers(txtGroupID.Value, {top:500}).value)
 
I have also tried 999 as the value etc... Anyone knows how to overcome this issue?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Pstork1 69,556 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

The maximum is 100 records and there is no way to increase it. Its hard coded into the connector. The normal fix for that is to use a ComboBox and set a Search field. You can still only get 100 records, but you can filter it to be records you want. To add more than 100 to a Collection you'll need to filter them and call Collect multiple times. For example, If you filter using StartsWith() you can get up to 100 records for groups that start with 'A', then 'b', etc.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

--- Disregard ---

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,877 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @iKettle

You can give a try for below code

Clear(colGroupUsers);

Set(
varMembers,
Office365Groups.ListGroupMembers(txtGroupID.Value)
);

Collect(colGroupUsers, varMembers.value);

While(
!IsBlank(varMembers.'@odata.nextLink'),
Set(
varSkip,
Mid(
varMembers.'@odata.nextLink',
Find("$skiptoken=", varMembers.'@odata.nextLink') + 11,
Len(varMembers.'@odata.nextLink')
)
);

Set(
varMembers,
Office365Groups.ListGroupMembers(
txtGroupID.Value,
{skiptoken: varSkip}
)
);

Collect(colGroupUsers, varMembers.value)
)

Please mark as answer if my suggestion helps.
Subscribe here for More Useful videos : https://www.youtube.com/@rampprakash3991

Was this reply helpful? Yes No