Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Combo Box filtering gallery



I'm having an issue with filtering a gallery with a combo box. I've unsuccesfully tried to resolve this issue all morning. Here's what's happening:


I have a combo box filtering a gallery. I have an if statement for the gallery Items that states if the combo box is empty, show the entire table. If something is selected then filter the gallery accordingly. Something like this:


Items=If(IsEmpty(ComboBox.SelectedItems.Column) ,table , Filter(table,Column in ComboBox.SelectedItems.Column))


The issue is when I navigate to the screen, the gallery shows up empty, whereas it should be showing all items since there is no selected item in the combobox. As soon as I select an item from the combobox, and the remove it from the combobox, the gallery shows all records (as it should). 


I've tried setting the combobox DefaultSelectedItems = [ ], DefaultSelectedItems = Blank(), Default = Blank(), but all that didn't work. 


Any ideas?


Thanks in advance!



Hi @corina were you able to figure this out? I was looking at this thread for the exact same solution.

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,734)