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

Highlighted
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
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

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

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,200)