Hi,
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.
Code :
Filter(
Development,
StartsWith(
'Process name',
txtInput.Text
),
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.
Hi @KalvisTe
You could try this:
Filter(Development,Status in cmbStatus.SelectedItems)
Best Regards,
Levi
Hi @KalvisTe
You could try this:
Filter(Development,Status in cmbStatus.SelectedItems)
Best Regards,
Levi
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?
Hi @KalvisTe
You can avoid delegation warnings by storing your data source in a collection and filtering the collection with the filter function.
Best Regards,
Levi
User | Count |
---|---|
247 | |
106 | |
82 | |
50 | |
43 |