Hi All,
I need some assistance using a ComboBox as a filter for a Gallery, the context behind this app is a seat reserveration app for a corporate office.
At the moment I have a ComboBox that displays all floors of the building, it crawls a SharePoint list and uniquely displays each floor. The function looks like this:
Distinct(Filter(Rooms, Building = Dropdown2.Selected.Result && Availability.Value = "not restricted"), 'Floor Number')
What I need now is a way to use the selected item/items as a filter in a gallery to only display Rows of the list corresponding to the options selected in the ComboBox. I saw this StackOverflow answer and tried to adapt it to my code, but looks like it will display all entries in the list if a ComboBox Item matches any entry in the list.
Filter(Rooms, Building = Dropdown2.Selected.Result && Availability.Value = "not restricted" && Sum(ForAll(ComboBox4_1.SelectedItems, If(ThisRecord.Result in Rooms.'Floor Number', 1, 0)), Value) > 0)
In essence I need this input:
To only display any room starting with 3xx, but it doesn't, this is the output:
Because in the list, only rooms starting with 3XX have a "Floor Number" of 3:
Thanks for any help, I really appreciate it 🙂
