cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
AFWright
Level: Powered On

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

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? 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

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

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.  

Static.PNG

 

8 REPLIES 8
Super User
Super User

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

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/...

Super User
Super User

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

What connector are you using? Excel, SharePoint,etc
Community Support Team
Community Support Team

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

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

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
AFWright
Level: Powered On

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

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

Super User
Super User

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

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.  

Static.PNG

 

AFWright
Level: Powered On

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

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

AFWright
Level: Powered On

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

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?

Super User
Super User

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

9E22BED7-BFAC-4EEF-81E4-5B797B0EAD40.gif