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.
Highlighted
AGS94
Level 8

Re: Filtering Product Dropdown List Using Multiple Checkboxes

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

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

Power Automate 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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (6,029)