
I have a combo box that will only return items if ALL selected items from the combo box are present. I need to return an item if ANY item selected is present. The code I am using:
Sort(
//If(
//!IsBlank(txtFilter.Text),
Search(
Filter(
SystemsReportsSME,
(IsBlank(ddSource.Selected.Value) || Systems = ddSource.Selected.Value) &&
(IsBlank(ddProject.Selected.Value) || 'Major Reports' = ddProject.Selected.Value) &&
IsEmpty(ComboBoxTags.SelectedItems) || ComboBoxTags.Selected.Value in Split(TagList, " ; ")),
txtFilter.Text, TagList, Systems, 'Major Reports' , Validation, Description),
Systems,
SortOrder.Ascending
)