cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
T_Findeisen
Level: Powered On

ForAll() question

Hello everybody,

 

I don't have a coding question but a funtionality question.

I need to display records from a table (eg: {Company; Record}), since there are more than 2000 results and I cannot filter it more I am doing the Following:

I create a grouped collection of the Companys called CollA.
Afterwards I use ForAll(CollA, Collect(CollB, Filter(Table, Company = ColA.Company))).

This attaches all records for the current company to CollB.

 

My question is the following:
Does a collection also have a 2000 record limit or is that limit only for queries that directly access the online server?

 

Best regards,

Thimo

1 ACCEPTED SOLUTION

Accepted Solutions

Re: ForAll() question

Check out this post and the comment from Mr Dang 

 

https://powerusers.microsoft.com/t5/General-Discussion/Collection-Limit/td-p/35223

 

I read somewhere that collections can slow down performance if they are huge, but they don't have a limit, only whats returned in terms of records is 2000.

 

You could try to nest your collections inside each other so records in a record. That might make navigating them a little eaiser.

 

 

View solution in original post

1 REPLY 1

Re: ForAll() question

Check out this post and the comment from Mr Dang 

 

https://powerusers.microsoft.com/t5/General-Discussion/Collection-Limit/td-p/35223

 

I read somewhere that collections can slow down performance if they are huge, but they don't have a limit, only whats returned in terms of records is 2000.

 

You could try to nest your collections inside each other so records in a record. That might make navigating them a little eaiser.

 

 

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 315 members 4,907 guests
Please welcome our newest community members: