web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Apps
Answered

gallery

(0) ShareShare
ReportReport
Posted on by 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:
I have the same question (0)
  • Verified answer
    Pstork1 Profile Picture
    69,554 Most Valuable Professional on at

    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.

  • v-albai-msft Profile Picture
    Microsoft Employee on at

    Hi @DHAGZ ,

    How are things going?

    Has @Pstork1 's answer solved your question?

    Best regards,

    Allen

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 477

#2
WarrenBelz Profile Picture

WarrenBelz 341 Most Valuable Professional

#3
11manish Profile Picture

11manish 317

Last 30 days Overall leaderboard