AnsweredAssumed Answered

Use Sql Where with a collection

Question asked by domiowa on Oct 2, 2018
Latest reply on Oct 26, 2018 by graham

Hi Everyone

I have a sharepoint list which retutns me some name; I store this name in a collection

After that; I'd like to execute a sql querry like that:

Select [Role], [Name],[Incoming]


WHERE Name IN mycollection


When I execute this WF; I get the following error message: Incorrect Syntax near 'Bob' (Bob is a name which is in my collection)

Any idea of what I'm doing wrong?