Unanswered

Countrows returns different values from gallery or collection depending on same data-source

(0) Share

Report

Posted on by Gilmour1

Here's one of those things... Probably some silly mistake I've made...

If I run Countrows on my gallery, the value it returns is 100, if the gallery draws data from a SP list, or 216 if the gallery draws data from a collection from the same SP list. Here's how:

Case 1

MyGallery Items: Filter(MyList, ColumnA=Value1)

Countrows(MyGallery.AllItems)=100

Case 2

MyCollection = MyList

MyGallery Items: Filter(MyCollection, ColumnA=Value1)

Countrows(MyGallery.AllItems)=216

Note: the SP list has 288 items total; the row limit setting for the app is 2000

Thanks for shedding some light!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

BCLS776 8,994 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Galleries initially load data 100 records on external data sources for performance reasons, which is why you get a CountRows() = 100 on the gallery's AllItems. Scrolling through the items will trigger the gallery to load more.

You are better off running the CountRows() on the same filter used to populate the gallery's Items property, to get an accurate count up to the row limit of the app.

Hope that helps,

Bryan

Was this reply helpful? Yes No
timl 37,246 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Gilmour1

Countrows(MyGallery.AllItems) will return a count of the number of rows in MyGallery.

The rows in the gallery are loaded in batches. If you open MyGallery, scroll to the bottom and continue scrolling until all 216 records are loaded, Countrows(MyGallery.AllItems) should then return a count of 216.

Was this reply helpful? Yes No
Bartelli 75 on at

Like
a
(0)

Report
Copy link

Link copied!

I found a video by Shane Young that will help: https://youtu.be/gtNCYMdOOag?si=EHS2YoFROAf2LgAo

Please let me know if this resolves your counting issue. Thanks!

Was this reply helpful? Yes No