Power Platform Community Forum Thread Details

I am working on below filters but can only filter by one criteria for each combo box.

e.g. If i selected more than 1 filters (first knowledge then general) , only the filter that are newly selected (i.e. general) will apply

Formulas as below.

Search(
Filter(
'Master Course List',
IsBlank(ComboBox_SolutionFilter.SelectedItems.Value) || IsEmpty(ComboBox_SolutionFilter.SelectedItems) || Solution.Value in ComboBox_SolutionFilter.Selected.Value,
IsBlank(ComboBox1_CategoryFilter.SelectedItems.Value) || IsEmpty(ComboBox1_CategoryFilter.SelectedItems) || Category.Value in ComboBox1_CategoryFilter.Selected.Value,
IsBlank(ComboBox1_RequiredFilter.SelectedItems.Value) || IsEmpty(ComboBox1_RequiredFilter.SelectedItems) || 'Mandatory/Optional'.Value in ComboBox1_RequiredFilter.Selected.Value,
IsBlank(ComboBox1_LearningAreaFilter.SelectedItems.Value) || IsEmpty(ComboBox1_LearningAreaFilter.SelectedItems) || 'Learning Area'.Value in ComboBox1_LearningAreaFilter.Selected.Value
),
SearchTextbox.Text,
"Course_Name)"
)

Thank you.

Categories:

Building Power Apps

Hi @Banana_Pancake ,

You have the Selected and SelectedItems reversed - also try this structure

Search(
 Filter(
 'Master Course List',
 (
 Len(ComboBox_SolutionFilter.Selected.Value) = 0 || 
 Solution.Value in ComboBox_SolutionFilter.SelectedItems
 ) &&
 Len(ComboBox1_CategoryFilter.Selected.Value) = 0 || 
 Category.Value = in ComboBox1_CategoryFilter.SelectedItems
 ) &&
 Len(ComboBox1_RequiredFilter.Selected.Value) = 0 ||
 'Mandatory/Optional'.Value in ComboBox1_RequiredFilter.SelectedItems
 ) &&
 (
 Len(ComboBox1_LearningAreaFilter.Selected.Value) = 0 || 
 'Learning Area'.Value in ComboBox1_LearningAreaFilter.SelectedItems
 )
 ),
 SearchTextbox.Text,
 "Course_Name"
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps