cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Filter gallery by 5 multi select combobox

Hi All,

i would like to achieve the functionality to be able to filter my gallery with the help of 5 multi select combo box.

Requirement  : On-visible of the screen gallery should show all items within the gallery however , when the user selects any combo box  or combination of these combo box it should filter the gallery data.

 

Thank you in advance!

Cheers!!

2 REPLIES 2
mdevaney
Super User III
Super User III

@Anonymous 
I can help you with this.  Can you please provide an example the options in your dropdown and what column you want to filter?

Anonymous
Not applicable

@mdevaney thanks for the support in advance!!

 

sure, the code to populate my combo box is given below which gets populated on the on-visible of the screen.
the items which get populated are basically text values; However for all the combo box there is All value that gets populated along with the distinct values from the list. Now what i would want is to show all the items of gallery when the value is show all in all the combo box and when i filter any combo box i would want to see filter happening for that particular combo box  in the gallery or a combination of any combo box.

Collect(ppnvalue,Distinct('Talent Tracker',Title));
ClearCollect(programname,{Result:"Show All"});
Collect(programname,Distinct('Talent Tracker','Program Name'));
ClearCollect(year,{Result:"Show All"});
Collect(year,Distinct('Talent Tracker',Year.Value));
ClearCollect(Regionvalue,{Result:"Show All"});
Collect(Regionvalue,Distinct('Talent Tracker',Region));
ClearCollect(associatename,{Result:"Show All"});
Collect(associatename,Distinct('Talent Tracker','Associate Name'.DisplayName))

 Here is a sample data in the gallery that i have. i would want to filter all the data in the gallery for any selection in combo box.
image.png

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

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

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

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.

Top Solution Authors
Top Kudoed Authors
Users online (2,103)