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.
Check out the on demand sessions that are available now!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
Features releasing from October 2020 through March 2021