Workaround to add 4,000+ Rows to load in Table / Gallery

[AFWright]

I have a list of 4,000 customers and 4,000 products that I need to load into two separate galleries. Both cap at 2,000. Is there a way to work around the 2,000 row Table limitation? 

[timl]

Hi @AFWright

@Mr-Dang-MSFT has posted some excellent articles here on how to batch load thousands of records into a local collection. Hopefully, this will guide you in the right direction, but feel free to post back here if you get stuck.

https://powerusers.microsoft.com/t5/General-Discussion/Overcoming-the-500-record-limit-locally/td-p/...

[Drrickryp]

What connector are you using? Excel, SharePoint,etc

[v-xida-msft]

Hi @AFWright,

Which data source do you use within your app? A SP list, Excel table, etc?

Which formula do you use within the Items property of the Gallery controls in your app?

Further, Do you have faced a Delegation issue within your app?

If the Data Source that you used within your app and the formula you used within your Gallery Items property are both delegable, you could delegate the processing of data to your data source.

More details about Delegation in PowerApps, please check the following article:

Delegation in PowerApps

If the Data Source that you used within your app or the formula you used within your Gallery Items property could not be delegated, you could only process about 2000 records locally at most.

Currently, there is no direct way to process/load more than 2000 records locally within PowerApps app. As an alternative solution, please check and see the following blog:

https://blog.coeo.com/davidmorrison/powerapps-500-record-limit-delegation-and-how-to-work-around-it

Best regards,

Kris

[AFWright]

The tables I'm loading are both in Excel and are about 5K rows.

[Drrickryp · Accepted solution]

Hi @AFWright,

If you are just going to use them for as Lookup tables and not expect to edit or add items, you can import them using the Add static data to your app.  It takes seconds and will import tables with as many as 15,000 rows.  You can make a collection and it will hold all 15,000.  If you want to merge the collection with another connector such as Sql or CDS, you can do that with Collect() or Patch(). If you need to edit the Static data though, you are out of luck.  

[AFWright]

This is a super simple solution and seems to work perfectly. Not sure how I missed this previosuly.... Thank you!

[AFWright]

What is the best way to populate the gallery with dynamic content from one drive or an SQL database? Can I use a Lookup function for that?

[Drrickryp]