cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
PowerApps Staff CarlosFigueira
PowerApps Staff

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
PowerApps Staff CarlosFigueira
PowerApps Staff

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
Level: Powered On

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?

PowerApps Staff CarlosFigueira
PowerApps Staff

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
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 (Last 30 Days)
Users online (5,434)