Answered

Count rows that contain "A", "B" or "C" as value

(0) Share

Report

Posted on by CU12090750-0

I have a dataset that looks like this:

ID	Property	Status
1	red	A
2	blue	A
3	yellow	B
4	red	C
5	blue	D
6	yellow	D

I want to count the number of rows that contains either A, B or C and show that count in my app.

CountIf(dataset; Status = "A" || Status = "B" || Status = "C")

I have tried this and a number of variations, but nothing works. This formula tells me CountIf is not supported by this connection.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Ethan_009 4,838 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @ErikKjellman ,

You can try the following code:
CountRows( <DataSource>, Status = "A" || Status = "B" || Status = "C" )

Hope this helps

Was this reply helpful? Yes No
vikas1606 206 on at

Like (0)

Report
Copy link

Link copied!

hi @ErikKjellman
Can you try the below statement?

CountRows(Filter(MyDataset, MyColumn = "A" || MyColumn = "B" || MyColumn = "C"))

Was this reply helpful? Yes No
CU12090750-0 on at

Like (0)

Report
Copy link

Link copied!

Forgot to mention that my dataset is a sharpoint list. I get an error saying it expects 1 argument, not two. If I remove the second argument it counts my rows, but I need them filtered.

Was this reply helpful? Yes No
CU12090750-0 on at

Like (0)

Report
Copy link

Link copied!

It is the same problem, it says that this connection does not support CountRows

Was this reply helpful? Yes No
vikas1606 206 on at

Like (0)

Report
Copy link

Link copied!

@ErikKjellman , If CountIf and CountRows not working then could you try the Sum function as mentioned below?

Sum(
dataset,
If(
Status = "A" || Status = "B" || Status = "C",
1,
0
)
)

Was this reply helpful? Yes No
Verified answer

CU12090750-0 on at

Like (0)

Report
Copy link

Link copied!

So it turned out that the problem was related to the fact that the column was a text type. I changed it to a Choice type, and added .Value to my data column, like so:
CountIf(Dataset; Status.Value = "A" || Status.Value = "B" || Status.Value = "C")

Was this reply helpful? Yes No