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

Filter Blank columns data

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

3 REPLIES 3
Super User III
Super User III

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.

 

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.

Capture.PNG

@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

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

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)