cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AFWright
Helper III
Helper III

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

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

 

View solution in original post

8 REPLIES 8
timl
Super User
Super User

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
Super User
Super User

What connector are you using? Excel, SharePoint,etc
v-xida-msft
Community Support
Community Support

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.

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

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

 

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

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?

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

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Solution Authors
Top Kudoed Authors
Users online (3,493)