Filter Blank columns data

[Harpreet_Tohra]

Hi 

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",
Or(
'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

[WarrenBelz]

Hi @Harpreet_Tohra ,

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

With(
   {wPlanned:DropdownPlanned_1.Selected.Value},
   Filter(
      YourListName,
      (
         wPlanned = "All" || 
         IsBlank(wPlanned)
      ) ||
      (
         (
            '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.

[Harpreet_Tohra]

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.

 

[WarrenBelz]

@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