Filter Data Table with Radio Buttons, Checkbox and Search

[DanM19]

In need of some help for an app I’m building. So I have a data table which I want the filter on. 

I have managed to successfully write 2 independent formulas which are working when applied to a Radio control and a checkbox but I have no idea how to put them together so it will work. Also I want incorporate a search box to filter on as well. 

This is the formulas I have working but as I said only separately.

Filter('Standalone Assets', If(Checkbox1.Value = true, Internet.Value = "Yes", !IsBlank(Internet.Value))

If(RadioStandaloneHardwareType.Selected.Value <> "All", Filter('Standalone Assets','Model:HardwareType'.Value=RadioStandaloneHardwareType.Selected.Value), 'Standalone Assets'))

This is what I’m trying to sort out;

 

[WarrenBelz]

Hi @DanM19 ,
I see you are filtering on a complex column type - try this

Filter(
   AddColumns(
      'Standalone Assets', 
      "wType",
      'Model:HardwareType'.Value
   ),
   Checkbox1.Value && 
   (Internet.Value = "Yes" || !IsBlank(Internet.Value) &&
   (
     RadioStandaloneHardwareType.Selected.Value = "All" ||
     wType=RadioStandaloneHardwareType.Selected.Value
   )
)

I am not sure on your intended logic on the top filter, but I am sure you will get the idea

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.

[DanM19]

Hi @WarrenBelz,

Thanks for taking some time to look at this problem for me.

I tried the formula you suggested. Unfortunately it only seems to show any items when the Internet Connected checkbox is checked, otherwise nothing. Also the filter between PC and Laptop seems to show a few of both types which seems strange.

[WarrenBelz · Accepted solution]

@DanM19 ,

Firstly filtering on Lookup columns, especially the "secondary" values is not a good practice, so it may not return exactly what you are after. I did not quite get your logic right on the second bit

Filter(
   AddColumns(
      'Standalone Assets', 
      "HType",
       Model:HardwareType'.Value
   ),
   If(
      Checkbox1.Value, 
      Internet.Value = "Yes", 
      !IsBlank(Internet.Value)
   ) && 
   (
      RadioStandaloneHardwareType.Selected.Value = "All" ||
      HType=RadioStandaloneHardwareType.Selected.Value
   ),
   'Standalone Assets'
)

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.

[DanM19 · Accepted solution]

Thank for the help @WarrenBelz.

I made some small modifications to the last one you sent me and it’s all working now! Here’s what I ended up with,

Filter(

   AddColumns(

      'Standalone Assets',

      "HType",

       'Model:HardwareType'.Value

   ),

   If(

      Checkbox1.Value = true,

      Internet.Value = "Yes",

      !IsBlank(Internet.Value)

   ) &&

   (

      RadioStandaloneHardwareType.Selected.Value = "All" ||

      HType=RadioStandaloneHardwareType.Selected.Value

   ))