Old thread but I had the same problem.Found out that you can use string
function Charindex to check if value is in array:1. in Javascript code,
store the content of the array as string in variable. For example
vars.cities = ['London', 'Paris', 'Berlin'].join(',');2. in Query
activity, add a filtering condition3. as the Expression of the filtering
condition, enter Charindex($(vars/@cities) , @city)4. as the Operator of
the filtering condition, enter greater than or equal to5. as the Value
of the ...