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.
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.
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?
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.
@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.
If there is no limit to collections, why am I getting this warning in the App Checker?
This loads from a Sharepoint List
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.