0
Answer

How to filter ";" separted columns values from the combobox multi sele

Photo of parthasarathy B

parthasarathy B
3y
752
1

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 

Answers (0)

Next Recommended Forum