I have a requirement to filter the ";" separated values like Item1;Item2;Item3;Item4 from the SP list column, based on the Combobox multiple selection the data should filter.
Filter( ColSampleList, cmbFilterCou.Selected.Result = Blank() || Country = cmbFilterCou.Selected.Result, cmbFilterFun.Selected.Result = Blank() || Function = cmbFilterFun.Selected.Result, CountRows(colLangFilter) = 0 || Languages in cmbFilterLanguages.SelectedItems, cmbFilterTZ.Selected.Title = Blank() || TimeZone = cmbFilterTZ.Selected.Title )
I have used the above formula to filter but it retrieves only the single value in that column, it's not retrieving the items which has multiple values in the same column