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]

FROM MyDB

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?

 

Thanks

Outcomes