cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Harpreet_Tohra
Frequent 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

1 ACCEPTED SOLUTION

Accepted Solutions
WarrenBelz
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.

 

View solution in original post

4 REPLIES 4
WarrenBelz
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.

 

View solution in original post

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

@WarrenBelz  It worked . Thanks Sir

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (32,066)