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

Answered

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)

Sort by

Waegemma 583 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
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,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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