IF with CountRows not working

(0) Share

Report

Posted on by iwonder

1,142

I have the following If Statement that fails.

If(
CountRows(
Filter(
colPelletRecords,
Facility = SelectedFacility.Text,
Line = SelectedLine.Text
)
) = 0,

Notify("What the heck"),//Other stuff)

The True part of the statement is fired every time even though the CountRows() = 1. I put the CountRows part as the Text parameter of a label and it's showing 1.

Why does the False part not get triggered in the IF statement?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

iwonder 1,142 on at

Like (0)

Report
Copy link

Link copied!

After a lot of time trying to figure this out I realized my problem is higher up... the code posted works as expected.

Thanks

Was this reply helpful? Yes No
KroonOfficeSol 587 on at

Like (0)

Report
Copy link

Link copied!

Just to make your app perform faster use First() around your filter formula. Only need to know if there is at least one match right 😉

And use IsEmpty() instead of CountRows().

Was this reply helpful? Yes No
iwonder 1,142 on at

Like (0)

Report
Copy link

Link copied!

Thank you SO MUCH for the pointers!!!

have a great day

Was this reply helpful? Yes No