Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Ken Ng]

Hi All,

I’m relatively new to PowerApps, and appreciate all the help this forum has provided me these last few months. I’m stuck on an urgent issue I need resolved..

I have a ListBox pulling from a collection called “employeeCollection” which has data fed from a SP table called “DAR – Resource List”, roughly about 650 records long. Currently the listbox is only able to display up 500 rows, with the last record showing “Maximum Number of Items Reached.” To be safe, I increased my App’s “Data Row Limit” to 1,000 which unfortunately hasn’t fixed the issue. 

I’m at a lost here, and I’m not quite sure how to fix this – please help!

ClearCollect(employeeCollection, 'DAR - Resource List');?

[Brian Scott]

I do not know off the top of my head if that is a hard limit, but I would say you do NOT want to bring in that much data to a collection. First it will take a very long time to load all that data. Second the device will have to store all that data, which will be an issue on mobile devices.
Is there a reason you can not use the SP table directly? The app will be more responsive. You don’t really want users to scroll through 650 items to find something – right? I assume you will be filtering that data. Is there a way you can pare the data down before you populate the ListBox?

——————————
Brian Scott
Chief Creative Officer
Concord NC
——————————
——————————————-

[Ken Ng]

Hi Brian, 

Out of curiosity, I went ahead and created a listbox with a direct pull from SP, yet it’s still displaying only 500 records. There still seems to be a limit set, despite increasing my Data Row Limit setting.

——————————————-

[Brian Scott]

It could be – I would say 500 entries in a ListBox is FAR too many. How would someone select something from a list of 500? It is bad enough when you have to select from 50 states. I would think a practical limit for a user would be closer to 20.
Why do you need that many items to choose from. Just being curious – we might be able to give you some alternatives.

——————————
Brian Scott
Chief Creative Officer
Concord NC
——————————
——————————————-

[Larry Heimendinger]

Power Apps has a hard limit of 2000 records.  The default is 500, and that value can be changed on settings.  When you are editing an app, click on Settings across the top menu, then scroll down on the General tab and modify the Data row limit.

That said, you can specify a filter option on a collect or clearcollect command to selectively retrieve rows from your data set based on some criteria.  Or, as I sometimes have to do because of app requirements, after i collect records, I use a removeif command to remove some records from the collection.

Often the question you asked goes in the other direction: how do I get more than 2000 rows from my data set?  There are some techniques to do this but beyond the scope of your question.

From your response, which I just saw, you are asking about a list box.  Might a combo box also work?  If so, you can make it searchable so that a text string the user begins to type filters down the entries.

——————————
Larry Heimendinger
larry@techevents.com
EverettWA
——————————
——————————————-