web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Apps - Building Power Apps Collection only collec...

Power Apps - Building Power Apps

Answered

Collection only collect 100 records

(1) Share

Report

Report

Posted on by TG-23080511-0

12

I'm trying to collect data from all users in an azure group.

The group consists of 323nusers but I'm only able to get 100 users in the collection. Anyone know why?

On Start on app:

ClearCollect(membersSVG, Office365Groups.ListGroupMembers("***************").value)

Categories:

General Questions

Using Apps Using Formulas

Connecting to Data

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

WarrenBelz 151,875 Most Valuable Professional on at

Like (1)

Report
Collection only collect 100 records

Hi TG-23080511-0

Try (I have used 500 as it is enough and is probably your Data Row Limit, but you can go to 999)
ClearCollect( membersSVG, Office365Groups.ListGroupMembers("**************",{top:500}).value )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
Yogesh Murugan 443 Moderator on at

Like (2)

Report
Collection only collect 100 records

The Office365Groups.ListGroupMembers function in PowerApps has a default limit of 100 items when retrieving group members. This is a common limitation with this connector in PowerApps
Using Top to ignore this limit

ClearCollect( membersSVG, Office365Groups.ListGroupMembers("**************",{top:999}).value );

Was this reply helpful? Yes No
Verified answer

MG-10091308-0 7 on at

Like (0)

Report
Collection only collect 100 records

ClearCollect( YourCollectionName, Office365Groups.ListGroupMembers("**************",{'$top':NUM}).value );

2 people found this reply helpful.

Was this reply helpful? Yes No

Join the conversation