cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Responsive Resident
Responsive Resident

CountRows = 0 but IsBlank = false

I have used often a command like this:

IsBlank(Filter(LocalBusAtt,BusDailyID=6117906))

Which is currently returning false. However if I run this:

CountRows(Filter(LocalBusAtt,BusDailyID=6117906))

I get 0 as result. It seems like I am getting incorrect responses from IsBlank or I have totally misunderstood how it works?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

IsBlank() is used to check if a value is blank (e.g. text string). IsEmpty() is used to check if a table has no records. Filter() returns a table so you have to use IsEmpty() to evaluate this function.

The reason IsBlank() returns true is because an empty table is considered a value whereas the string “” is not.

View solution in original post

2 REPLIES 2
Highlighted
Super User III
Super User III

IsBlank() is used to check if a value is blank (e.g. text string). IsEmpty() is used to check if a table has no records. Filter() returns a table so you have to use IsEmpty() to evaluate this function.

The reason IsBlank() returns true is because an empty table is considered a value whereas the string “” is not.

View solution in original post

Highlighted

Wow, I think I knew that at one point and conviently forgot it. Thanks.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,282)