What is the max row count for galleries ?

(0) Share

Report

Posted on by vsslasd

349

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

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

rebeccas 2,591 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
macielt08 6 on at

Like (0)

Report

Hello,

how can I make this filter with various conditions.

Thanks
Tiago

Was this reply helpful? Yes No
PaulD1 2,914 on at

Like (1)

Report

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

Was this reply helpful? Yes No
macielt08 6 on at

Like (0)

Report

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

Was this reply helpful? Yes No
rebeccas 2,591 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
PaulD1 2,914 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
macielt08 6 on at

Like (0)

Report

My datasource is google sheets. How do i delegate my formula.

Sorry, but I'm new to powerapps and I'm learning how much I'm doing.

Thanks

Was this reply helpful? Yes No