cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

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
Highlighted
Super User III
Super User III

Re: Filter gallery by 5 multi select combobox

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

Highlighted
Post Patron
Post Patron

Re: Filter gallery by 5 multi select combobox

@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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published 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 (6,868)