Filtering table based on a column in Collection

[Anonymous]

Hello, I am trying to filter a table based on values in a column in collection. Below is what I am trying but it won't work:

Step1: The collection is created by reading text from a input box that may contain comma separated values:

ClearCollect(codes,Split(inputSearchCode.Text,","))

Step2: Setting the table source to a filter expression to filter table data based on values in the above collection:

Filter('[app].[CODES]',CODE in codes.Result)

When I try the above, I do not get any errors. I also see the values parsed in the collection, but the table won't show any results.

Attached is the screenshot of collection with values in it.

[eka24]

In your step2, what is the name of your table. What are the relevant column names.

[Anonymous]

table name is app.CODES, and CODE is the column on this table that needs to be filtered based on values from Step1.

[v-xida-msft]

Hi @Anonymous ,

Based on the formula that you mentioned, I could not find any syntax error with it. I suppose this issue may be related to the value within your codes collection -- each value within the codes collection includes a space.

On your side, please consider modify your formula as below:

Filter(
         '[app].[CODES]',
          CODE in Trim(codes.Result)  // Modify formula here
)

Please consider take a try with above solution, check if the issue is solved.

Best regards,