An array in Filter Query

[kenneth0596]

Hi, I want to filter items using an array variable from another list. The query would be something like this: client eq 'a' or client eq 'b' or client eq 'c' ... where list of clients comes from another sharepoint. Any ideas? 

[ScottShearer]

@kenneth0596 

You can't use an array in your filter query.  I suggest using a string variable.  Loop through the array and append

client eq '[current array value here]'  or   

in each loop.

In the last loop, don't add the or at the end.

Substitute the current value in the array from Dynamic properties for [current array value here].

In my example, please note that there is a space after or in the append to string action.

[Swiftx64]

Hey,

Thank you for sharing this, I am trying to follow along but having an issue.

Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Append_to_string_variable' at line '1 and column '2469' is invalid. Action 'Apply_to_each' must be a parent 'foreach' scope of action 'Append_to_string_variable' to be referenced by 'repeatItems' or 'items' functions.'.'."

What would cause that error?

https://powerusers.microsoft.com/t5/Building-Flows/Action-Apply-to-each-must-be-a-parent-foreach-sco...

[lokeshraje]

Thanks a lot for your solution. That worked for me.