I have a gallery with sharepoint list, and I filter it with searchbox, and 2 comboboxes. The issue I find is that if I select 2 options from combobox, it doesnt filter it by both of them, but shows only one result. How could I resolve this? I'd like it to show both of the selected option results, not only one. As you can see in the last screenshot if I have selected 2 values, it shows result with the latest selected value. Sharepoint column for that field is a choice field with single selection.
IsBlank(cmbLocation.SelectedItems) || IsEmpty(cmbLocation.SelectedItems) || Location.Value = cmbLocation.Selected.Value,
IsBlank(cmbSolutionType.SelectedItems) || IsEmpty(cmbSolutionType.SelectedItems) || 'Solution type'.Value = cmbSolutionType.Selected.Value,
IsBlank(cmbStatus.SelectedItems) || IsEmpty(cmbStatus.SelectedItems) || Status.Value = cmbStatus.Selected.Value
Solved! Go to Solution.
Thanks! It does give delegation error, but my list will not go over a few hundred rows. Any idea if there is workaround for the delegation stuff if using In function?
You can avoid delegation warnings by storing your data source in a collection and filtering the collection with the filter function.
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!