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())
Check out the on demand sessions that are available now!
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
Features releasing from October 2020 through March 2021
Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!