Hello,
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!
