Filtering collection for records where a column has null values

I have a simple collection called colDataSet where 'display_id' column could be a null. I need to filter for and display all records in a Gallery using the colDataSet where display_id is null.

I tried the following in the 'Item's property of the Gallery, but none is returning records where display_id column has null:

Filter(colNullRecords, !(Value(display_id)), project) // returns 4 records where display_id = 0, but I need to filter for when display_id is null

Filter(colNullRecords, !IsNumeric(Value(display_id)), project) // not returning anything

Filter(colNullRecords, IsBlank(Value(display_id)), project) // not returning anything

Filter(colNullRecords, !(display_id), project) // returns 4 records where display_id = 0

Filter(colNullRecords, !IsNumeric(display_id), project) // not returning anything

Filter(colNullRecords, IsBlank(display_id), project) // not returning anything

If there is any post out there for how to filter for nulls in collections, please point me to that.

Thanks much!

3 comments

Learn Power Apps

skool.com/learn-power-apps

A community of people who are enthusiastic about and trying to learn about Microsoft's Power Apps!

🏛️ Power Apps Template Building

Leaderboard (30-day)

+21