Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Filter Blank columns data


I have made a gallery with 6 columns and applying filter on all. There are some values which are missed in the records that will be updated in the gallery only. like to give the status etc.

But as I am applying filter on that status column. It is only showing records with status already given. I want my gallery to show all empty records as well. This is my filter code for status column.

Filter (If(
DropdownPlanned_1.SelectedText.Value = "All",
'Select type'.Value = "Planned",
'Select type'.Value = "Unplanned"

DropdownPlanned_1.Selected.Value = 'Select type'.Value)



Can anyone help me to solve this??

Thanks in advance

Super User III
Super User III

Hi @Harpreet_Tohra ,

I am not sure on the exactly result you want, but this should be close

         wPlanned = "All" || 
      ) ||
            'Select type'.Value = "Planned" || 
            'Select type'.Value = "Unplanned"
         ) && 
         wPlanned = 'Select type'.Value


Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.


Hi @WarrenBelz  I tried but it doesn't work.  you can have a look at my screenshot. There is one record in which I have not give any status. I want my gallery filter to show that record also. That record should show as it has all values except the status value. Kindly help me to do this If possible.


@Harpreet_Tohra ,

What field is Status in? I cannot guess your logic but the code I gave you allows for a blank field in the dropdown

Helpful resources

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users


We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (66,132)