cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Return items that do not have a blank value

On my default browse screen i am using the following formula, Filter(InstructorSignUpCal,IsBlank(Instructor)) which only shows items that do not have a instructor filled in that field. Its a people picker field. I want another browse screen to show items where the Instructor field is not blank. I tried using Filter(InstructorSignUpCal,If(IsBlank(Instructor),false)) but that doesnt work. It must be something small i am missing here. Any help would be appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
Power Apps
Power Apps

Re: Return items that do not have a blank value

Try using the Not function:

Filter(InstructorSignUpCal, Not(IsBlank(Instructor)))

Or you can also use the ! operator:

Filter(InstructorSignUpCal, !IsBlank(Instructor))

 

View solution in original post

4 REPLIES 4
Power Apps
Power Apps

Re: Return items that do not have a blank value

Try using the Not function:

Filter(InstructorSignUpCal, Not(IsBlank(Instructor)))

Or you can also use the ! operator:

Filter(InstructorSignUpCal, !IsBlank(Instructor))

 

View solution in original post

Anonymous
Not applicable

Re: Return items that do not have a blank value

Awesome, thanks for the quick response! The "!" operator worked. 

marcoselias Advocate I
Advocate I

Re: Return items that do not have a blank value

I get a delegation warning when using the !IsBlank() function on a SQL Server data source. Is there a way to avoid such warning while being able to filter out (or in) NULL values?

Power Apps
Power Apps

Re: Return items that do not have a blank value

You can use this workaround suggested by @Meneghino at https://baizini-it.com/blog/index.php/2017/09/28/powerapps-and-azure-sql-database-current-issues/ - instead of using

Filter(tableName, !IsBlank(Field))

You can use this:

Filter(tableName, Field <> Blank())

 

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,530)