Unanswered

Collection row limits

(0) Share

Report

Posted on by rio688

Hello All,

I am currently developing an app and am using an SQL table as one of my main data sources, the table has about 3500 rows and my delegable functions all work fine, I have now been tasked with trying to make this app work in an offline mode, everything I have found would imply that I would need these fields to be a local collection instead, however before I go writing a collection of 3500 rows can someone confirm for me what the maximum number of rows in a collection can be (I was planning to write this as a Collect() on visible of the first page.

Thanks

Dan

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

v-monli-msft on at

Like (0)

Report

Hi @rio688,

Collections can hold as many records as you want.

From the documentation Unserstand Delegation(https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview), you could see that:

Imported Excel workbooks (using the "Add static data to your app" data source), collections, and tables stored in context variables don't require delegation. All of this data is already in memory, and the full PowerApps language can be applied.

Regards,

Mona

Was this reply helpful? Yes No
rio688 24 on at

Like (0)

Report

Hi Mona

Many thanks, If I use the Add static data from an Excel workbook I presume that I can use this offiline?

Regards

Daniel

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report

Hi Daniel, Yes - any static data that you add from Excel will be available offline.

Was this reply helpful? Yes No
redsch 5 on at

Like (0)

Report

Hey guys,
That's actually not true. I'm just facing a 15k rows limitation of a static data import (32k records). No search, filter functionality beyond the record number 15001. Any idea how to fix this?
Cheers,
Balazs

Was this reply helpful? Yes No
tdotson66 2 on at

Like (0)

Report

redsch - Did you every find a solution for this limitation? I have the same issue.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (2)

Report
Hi all,

There is a hard static data import max per table of 15000. In experimenting with US postal code table, 42,523 rows, I split it into 3 tables and imported all three into one app. I set up formula as follows in the magnifying icon:

Clear(allzip);Concurrent(ClearCollect(zip1,Search(Table1,TextSearchBox1.Text, "City")),ClearCollect(zip2,Search (Table2,TextSearchBox1.Text, "City")) , ClearCollect(zip3,Search(Table3,TextSearchBox1.Text,"City"))) ; Collect(allzip,zip2); Collect(allzip,zip2);Collect(allzip,zip3)

I set the Gallery Items property to allzip. After typing a city in the searchbox, and clicking on the magnifying glass the gallery filled almost instantaneously with data from all three tables.

Was this reply helpful? Yes No
redsch_ 5 on at

Like (0)

Report

@tdotson66 I didn't. I had to switch to a sharepoint list as a data source, which is working fine, but slow AF.

Was this reply helpful? Yes No
redsch_ 5 on at

Like (0)

Report

@Drrickryp Thanks mate, nice workaround, I might actually give this a shot. It would be nice to see something from MS about this though. All I can find is that "no limits" BS.

Was this reply helpful? Yes No
maxtarneberg 116 on at

Like (0)

Report

@v-monli-msft

If there is no limit to collections, why am I getting this warning in the App Checker?
This loads from a Sharepoint List

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (1)

Report

Hi @maxtarneberg

This is because with the ClearCollect function, it isn't possible to retrieve all rows from the Inspection2020 list.

Because the list could be very large, PowerApps will only collect a maximum number of rows that is specified in the 'non delegable query limit' setting in your app. This is 500 rows by default, but we can increase it to a maximum of 2000.

Was this reply helpful? Yes No