Unanswered

CountIf Error

(0) Share

Report

Posted on by Phineas

5,325 Super User 2025 Season 2

Why is this formula not working?

I want on AppStart the formula to count the number of items in an SPList column and return it to a PA label field. I'm getting an error on the ' = ' sign.

CountIf(PendingReviewCollection,PendingReview="Pending",true)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

rubin_boer 4,841 Super User 2024 Season 1 on at

Like (1)

Report

@Phineas change CountIf(PendingReviewCollection,PendingReview="Pending"~~,true~~) to CountIf(PendingReviewCollection,PendingReview="Pending")

Was this reply helpful? Yes No
kameshm 59 on at

Like (1)

Report
Hi @Phineas ,
What is the column type for "PendingReview"?. If the column type is Choice, you have to change the countIF formula like below.
CountIf(PendingReviewCollection,PendingReview.Value="Pending")

Was this reply helpful? Yes No
Verified answer

Anonymous_Hippo 1,247 Super User 2024 Season 1 on at

Like (0)

Report
Hello @Phineas ,

Can you try both of these formulas

Set(VarCountIf,CountIf(PendingReviewCollection,PendingReview="Pending"))

Set(VarCountIf,CountIf(PendingReviewCollection,PendingReview.value="Pending"))

Se if any of this works

🙂

Was this reply helpful? Yes No