Filter table using an array

Hi there,

I'm sure this must be very simple, but I can't get it to work.

I have a table with a column called "Details" which is a list of items from a related table.

I also have a variable containing an array with a list of codes selected by the user.

How do I filter my table with records that have all the variable items in the "details" field?

I tried filtering the Query All Items using the "in" operator like this:

However it returns an error saying that a scalar value is required.

Best,

5 replies