parthasarathy B

parthasarathy B

  • 1.3k
  • 912
  • 80.8k

How to filter the "|" appended column value in PowerApps Galley

Sep 14 2021 8:38 AM

Hi all,

I am struggling in one issue that, i have stored the values in the SP list like "Chennai|Mumbai|Bangalore" like that, i want to filter those values in the powerapps gallery using multiselection combobox.

I am storing all the selected combobox values in the collection on the OnChange event of the combobox.

So I want to compare the values from the collection with the column value

I have tried the below formula but it is not working properly

Set(ColFilterResult,Filter(ColSampleList,If(CountRows(colLocationFilter) > 0,WorkLocation in colLocationFilter,WorkLocation in ColLocations.Title))