Hi friends!
It's pretty straightforward what I'm looking to do - I'm looking to filter a gallery tied to a SharePoint list using two multiselect combo boxes in Power Apps. Here is a screenshot of the SharePoint list:
And here is a screenshot of my PowerApp so far:
I am looking to filter the list by Division and by Site. Both columns in SharePoint are Choice columns with only one choice allowed. The choices are properly reflected in my ComboBoxes:
ComboboxCanvas2 (Filter By Division) Properties:
Items: Choices('Diverse Volunteers for Interview Panels'.Division)
IsSearchable: true
SelectMultiple: true
ComboboxCanvas3 (Filter By Site) Properties:
Items: Choices('Diverse Volunteers for Interview Panels'.Site)
IsSearchable: true
SelectMultiple: true
Based on what the user selects, I would like for my gallery to filter accordingly. For instance:
a) If no filters are applied, all items show (I have that accomplished)
b) If Crop Science and Enabling Functions are selected as filters in Division, the gallery shows all volunteers from Crop Science OR Enabling Functions
c) If US-MO-CHESTERFIELD and AUSTRALIA are selected as filters in Site, the gallery shows all volunteers located in US-MO-CHESTERFIELD OR AUSTRALIA.
If b) and c) are selected together, the list first shows volunteers in Crop Science OR Enabling Functions, then, from that filtered list, the list shows volunteers located in US-MO-CHESTERFIELD OR AUSTRALIA.
My gallery properties are as follows (methodology taken from @RezaDorrani's youtube video: Multi Select Filters in Power Apps with Combo box, Checkboxes & No Delegation):
Filter(
'Diverse Volunteers for Interview Panels',
Or(
IsBlank(ComboboxCanvas2.SelectedItems),
IsEmpty(ComboboxCanvas2.SelectedItems),
Division.Value = Index(
ComboboxCanvas2.SelectedItems,
1
).Value,
Division.Value = Index(
ComboboxCanvas2.SelectedItems,
2
).Value,
Division.Value = Index(
ComboboxCanvas2.SelectedItems,
3
).Value,
Division.Value = Index(
ComboboxCanvas2.SelectedItems,
4
).Value,
Division.Value = Index(
ComboboxCanvas2.SelectedItems,
5
).Value
)
)
So far, only the first item from the SharePoint list is returning no matter which division or combo of divisions I select as the filter:
The good news is that I have no Delegation warnings! 😄
My questions are the following:
1. How do I get the filter for Division working correctly, and
2. How do I add on the second filter to the gallery using the Site Combo Box?
Let me know if you need any additional information - thank you for your help!
