Filtering Product Dropdown List Using Multiple Checkboxes

[AGS94]

I am trying to create a "product selection" tool using checkboxes as the filter. Ultimately I am trying to get it to work conceptually like a common website shopping cart filter.

Notes:

• The resulting filtered product list will be feeding a dropdown in the form of item numbers.
• I am sure things like cascading dropdowns, etc. would make this much easier, but it would be a compromise for the end user. Checkboxes would make for a far better user experience (but big headache for me :-).
• The actual products are far more complex than jackets, and the dropdown list will ultimately feed subsequent dropdown lists, but robustly filtering these checkboxes are the area I am currently struggling with most.
• I have seen other similar "multi-checkbox" filtering questions posted but did not find one quite like this request.

Examples:

• No selection returns all jackets
• If Red and Blue are selected, all red and blue jackets are shown
• If Red, Blue and Zip are selected, all red and blue jackets with zippers are shown
• If Blend and Red are selected, all red jackets made from blended materials are shown.
• etc.

[v-yutliu-msft]

Hi @AGS94 ,

Could you tell me are color,component and material three fields?

If so, you could try this formula:

(color is checkbox1-3, component is checkbox 4-6, material is check box 7-9)

Set checkbox1-3's OnCheck and OnUncheck:

ClearCollect(a,{color:"Red",value:Checkbox1.Value},
               {color:"Blue",value:Checkbox2.Value},
               {color:"Green",value:Checkbox3.Value})

Set checkbox4-6's OnCheck and OnUncheck:

ClearCollect(b,{component:"Button",value:Checkbox4.Value},
               {component:"Snap",value:Checkbox5.Value},
               {component:"Zip",value:Checkbox6.Value})

Set checkbox7-9's OnCheck and OnUncheck:

ClearCollect(c,{material:"Cotton",value:Checkbox7.Value},
               {material:"Wool",value:Checkbox8.Value},
               {material:"Blend",value:Checkbox9.Value})

Set the drop down's Items:

Filter(tablename,color in Filter(a,value=true).color,
                 component in Filter(b,value=true).component,
                 material in Filter(c,value=true).material
       )

Set the drop down's Vlaue: Numbers

Best regards,

Community Support Team _ Phoebe Liu

[AGS94]

Thank you Phoebe. I will take a closer look at your recommendation.

[v-yutliu-msft]

Hi @AGS94 ,

Have you solved your problem?

Best regards,

Community Support Team _ Phoebe Liu