cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AGS94
Level 8

Filtering Product Dropdown List Using Multiple Checkboxes

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.

 

Capture.JPG

3 REPLIES 3
Community Support Team
Community Support Team

Re: Filtering Product Dropdown List Using Multiple Checkboxes

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: Numbers7153.PNG

 

Best regards,

Community Support Team _ Phoebe Liu

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
AGS94
Level 8

Re: Filtering Product Dropdown List Using Multiple Checkboxes

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

Highlighted
Community Support Team
Community Support Team

Re: Filtering Product Dropdown List Using Multiple Checkboxes

Hi @AGS94 ,

Have you solved your problem?

 

Best regards,

Community Support Team _ Phoebe Liu

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,525)