Alert noticed to change from CountRows To CountIf

(2) Share

Report

Posted on by MIA

I am using the below code on the label text properties,

CountRows(WarrantyDataGallery.AllItems) & " of total Records : " & CountRows(colAllWarranty)

The code is bringing the correct result, and it was working since years without any warning, today I noticed below warning:

CountRows may return a cached value.
Use CountIf(DataSource, true) to get the latest count.

Please guide, it need to replace the code the suggested method?.

Categories:

Using Apps Using Formulas

All responses (3)

Answers (0)

Suggested answer

timl 34,939 Super User 2025 Season 1 on at

Like (0)

Report

Alert noticed to change from CountRows To CountIf

Hi MIA

There's no need to change to CountIf(DataSource, true) in the scenario that you mention.

This warning is designed for cases where the data source is Dataverse, CountRows is used without filtering, and the record count exceeds 50k records. Under these circumstances, Power Apps returns a cached count which may not be accurate. CountIf(DataSource, true) would be the way to achieve an accurate row count.

There are more details in the documentation here.

https://learn.microsoft.com/en-gb/power-platform/power-fx/reference/function-table-counts
MIA 22 on at

Like (0)

Report

Alert noticed to change from CountRows To CountIf

Dear Mr. Mike,

As I mentioned in my earlier post that where ever there was CountRows used, all the places the alert is showing. BUT it was working since years without any alert.

Just to update you, I change on one of the label text :

Before Code was :

CountRows(colAllList)

Changed to :

CountIf(colAllList, true)

Found, brings the same result, and Alert mark disappears.

At this stage confused and looking forward to an advise, What to do?.

change all the CountRows to CountIf

Please guide further.

Regards
Suggested answer

Michael E. Gernaey 41,027 Super User 2025 Season 1 on at

Like (0)

Report

Alert noticed to change from CountRows To CountIf

Hi

That is new to me, I haven't seen that, although I believe multiple people mentioned it.