cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

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
Highlighted
Community Support
Community Support

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.
Highlighted
Resolver I
Resolver I

Re: Filtering Product Dropdown List Using Multiple Checkboxes

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

Community Support
Community Support

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
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,881)