cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AGS94
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
v-yutliu-msft
Community Support
Community Support

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.

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

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
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (2,007)