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.
Try using the Not function:
Filter(InstructorSignUpCal, Not(IsBlank(Instructor)))
Or you can also use the ! operator:
Filter(InstructorSignUpCal, !IsBlank(Instructor))
Try using the Not function:
Filter(InstructorSignUpCal, Not(IsBlank(Instructor)))
Or you can also use the ! operator:
Filter(InstructorSignUpCal, !IsBlank(Instructor))
Awesome, thanks for the quick response! The "!" operator worked.
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
Filter(tableName, !IsBlank(Field))
You can use this:
Filter(tableName, Field <> Blank())
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
198 | |
171 | |
60 | |
32 | |
32 |
User | Count |
---|---|
333 | |
271 | |
103 | |
71 | |
56 |