web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Count rows that contai...

Power Apps

Answered

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

(0) Share

Report

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 Img

All responses (6)

Answers Img

Answers (1)

Ethan_009 4,838 Moderator on at

Like (0)

Report
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

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

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

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

@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

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

Join the conversation