cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BrianHFASPS
Level 8

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
mdevaney
Level 8

Re: CountRows = 0 but IsBlank = false

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
mdevaney
Level 8

Re: CountRows = 0 but IsBlank = false

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

BrianHFASPS
Level 8

Re: CountRows = 0 but IsBlank = false

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

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 328 members 5,773 guests
Please welcome our newest community members: