CountRows with Filter on multiple columns

(0) Share

Report

Posted on by JanDras

Hello,

I'm trying to combine multiple conditions to the CountRows:

CountRows(Filter('Source'; Column1 = Concat(varSelected; Nadpis) && 'Column2' = startTime))

I need to get back number of rows that fulfill the two(three, four) conditions. If I do one condition at a time, it works fine but it doesn't work when I start adding criteria.

What is the proper syntax?

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

charlessexton 11 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

You don't need to have apostrophes on your column name unless there are spaces in it. So 'Column2' should be Column2.

Was this reply helpful? Yes No
JanDras 85 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, I renamed it just for the sake of the post, in the original the column names do have spaces.

Was this reply helpful? Yes No
charlessexton 11 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

When you say that it doesn't work, in what way doesn't it work? CountRows gives you an error? CountRows states there are zero items?

Was this reply helpful? Yes No
JanDras 85 on at

Like
a
(0)

Report
Copy link

Link copied!
Source:
Column1 Column2 Column3
Name1 StartTime1 EndTime1
Name2 StartTime2 EndTime2

I am trying to create an if() condition that would prevent the users creating a duplicate entry.

If I use:
CountRows(Filter(Source; Column1 = Name1))
The output is 1 (and it's right.
but once I use:

CountRows(Filter(Source; Column1 = Name1 && Column2 = startTime1))

The output is 0 but the row that matches the conditions exist.

Was this reply helpful? Yes No
charlessexton 11 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Have you looked at the output from Column2 and startTime1 to make sure they're the same as each other? They will need to be the same type and format in order to match. They have to be exactly the same.

Was this reply helpful? Yes No