web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Collection only collec...

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:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

WarrenBelz 154,755 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
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 447 Moderator on at

Like (2)

Report
Copy link

Link copied!
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
Copy link

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

2 people found this reply helpful.

Was this reply helpful? Yes No

Join the conversation