web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps CountA error: Cannot c...

Power Apps

Unanswered

CountA error: Cannot compare text

(0) Share

Report

Report

Posted on by Celia

60

Hi community,

I have used this formula before, and this worked:

CountA(Filter('Task DB';Priority.Value = "High").Priority)

Now I am working on another table and changed the formula to:

CountA(Filter('Action Tracker';'Task Status'.Value = "New").'Task Status')

But this time it is not working.

Does anyone see what I am doing wrong?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Waegemma 583 Super User 2024 Season 1 on at

Like (0)

Report
Hi @Celia ,

Have you tried :

CountIf('Action Tracker';'Task Status'.Value="New")

Greetings,
Marc

Was this reply helpful? Yes No
Verified answer

iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report

Are you using CountA because you don't want to include blanks?

I would put the inner part of your formula into a gallery

Filter('Action Tracker';'Task Status'.Value = "New").'Task Status'

..then you can see how many values match that filter, as it may be that the issue is not the counting, but that the values are not present.

Was this reply helpful? Yes No

Join the conversation