web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How can i use countif ...

Power Apps

Answered

How can i use countif when in condition i want compare another column

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi, I have a question, can I use CountIf, if I want to check if there is a value specified for this record in another column?

For example:

 CountIf(Shortages.Item, 'Production Line'.Text = "A")

Production Line is a column like Item in Table named Shortages

Categories:

Building Power Apps

All responses Img

All responses (6)

Answers Img

Answers (1)

Sort by

JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

It's going to depend on where you are trying to put this formula. Is this a selected item in a gallery?
ShockWave 10 on at

Like
a
(0)

Report
Copy link

Link copied!

In text label
JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

You indicated that this is for the current record. How are you telling the text label that you have a record selected? Is the label in a gallery or table for the current record?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

In the gallery
Verified answer

CU-18081211-6 9,272 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous ,

Yes ... The formula is quite good, but is a little bit slow for large data sources, as Countif() function iterate through entire data sources checking the formula.

CountIf(Shortages, 'Production Line'.Text = "A")>0

For better results, use:

IsBlank(LookUp(Shortages, 'Production Line' = "A"))

The result will be true if there is no record in Shortages table with condition fulfilled.

Hope it helps !
JR-BejeweledOne 5,836 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
To build on what @gabibalaban said, if you just need to see if the production line column for the selected record is blank.

IsBlank(ThisItem.'Production Line')

Join the conversation