ForAll() question

[T_Findeisen]

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

[KeithWhatling · Accepted solution]

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.