gallery

(0) Share

Report

Posted on by DHAGZ

162

Good day

asking for help.

how to count all rows in gallery without pulling the first 100 records

my formula:
CountRows(Gallery1.AllItems)

thanks and advance

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Pstork1 68,739 Most Valuable Professional on at

Like (0)

Report

Galleries are designed to be paged and load records 100 at a time. So if you count the rows in a gallery you will always get the number of records that have currently been loaded through paging. There is no way around that. But you can do a CountRows() on the Data Source itself or whatever filtered set of Items is in the Items property of the Gallery. That will give you the total number of records that will eventually be displayed in the gallery through paging. The one problem is that CountRows() can't be delegated so if its a large data source there is no way to get the total number of records.

Was this reply helpful? Yes No
v-albai-msft on at

Like (0)

Report

Hi @DHAGZ ,
How are things going?
Has @Pstork1 's answer solved your question?
Best regards,
Allen

Was this reply helpful? Yes No