19. What is the data row limit for a collection in Power Apps?

A collection itself does not have a fixed row limit.

However, the number of records that can be stored in a collection depends on how the data is loaded.

When Loading from a Data Source

If you create a collection from a data source using a non-delegable query, Power Apps applies the Data row limit for non-delegable queries setting.

By default: 500 records, Can be increased up to 2,000 records

Example:

ClearCollect(MyCollection, SharePointList)

If the query is non-delegable, only the first 500 or 2,000 records (based on your app setting) will be loaded into the collection.

When Creating Records Manually

If you manually add records using Collect() or ClearCollect() without querying a large external source, there is no practical hard-coded limit — performance becomes the real constraint.

Important Clarification

• The limit is not on the collection itself.
• The limit applies to how many records Power Apps retrieves from a data source when delegation is not supported.

Interview-Ready Answer

A collection does not have a fixed row limit, but when data is loaded from a non-delegable source, Power Apps applies the app’s data row limit setting (default 500, maximum 2,000).