Share
ReportWhat is the maximum row count for galleries ? We heard it was 50. Yet we see over 70 rows in a gallery list.
Thank you
Categories:
You’re offline. This is a read only version of the page.
What is the maximum row count for galleries ? We heard it was 50. Yet we see over 70 rows in a gallery list.
Thank you
Can you make your formula delegable? (will depend on your datasource and field types) https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview
As I say, if the formula is delegable you will get the first 100 rows, then when you scroll to the end of the gallery the next 100 will be loaded and so on.
If you can't make the formula delegable, increase your non-delegation limit (under advanced settings, max is 2000) and/or put some more filters in place so the numer of rows is more managable.
500 is the default max count in Powerapps. You can up the count in your App Settings under Advanced Settings but it is recommended to stay at the 500 and use some filtering options to limit your list more.
It will go a little slower if you up that amount. But if you raise it then that will show more.
the gallery where I want to display the values, only appears after filling a text box on another screen and only after pressing a button, and should only appear if the lines contain this value and another condition.
my table has more than 5000 rows.
the formula I am using is as follows:
Sort(Filter(oc;Password.Text=pin;estado_oc<>"Concluido");data;Descending)
but only the first 500 lines appear to me
Thanks
Tiago
If you have a delegable formula populating the gallery it will initially load the first 100 rows, then, as you scroll to the bottom of the list it will trigger the gallery to get the next 100 rows (so the gallery now holds 200 rows). This will repeat (another 100 rows each time you get to the bottom of the list).
Not sure of the total maximum but I've managed to get over a thousand rows to display in experiments - basically more than makes sense to display from a UX perspective (if you have more than a few hundred, make the user specify some kind of filter first, scrolling through lists that long is a bad user experience).
It is 500 (that is the default data row limit for non-delegable queries). You can raise it in the advanced settings but that is not recommended...it will make it slow.
It is best to try and filter what you can if you get over 500.
#1
WarrenBelz
146,668
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
All responses (
Answers (
