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.
Solved! Go to Solution.
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?
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
You can use this:
Filter(tableName, Field <> Blank())
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.