Using item() in Lookup Activity within a ForEach

Question

Hello
@Nasreen Akter @MartinJaffer-MSFT

My next bug is that I am trying to use an item() in a Lookup Query within a ForEach loop. My Query is
SELECT fullname, emailaddress
FROM [MercerStagingDev].[MILKY-WAYTEST\AppSQLVST4DotNetDev-R].[EmployeeVendors]
WHERE employeeid = item().employeeId

but I am getting the following error:
,Source=,''Type=System.Data.SqlClient.SqlException,Message='item' is not a recognized built-in function name.,Source=.Net SqlClient Data

How can I lookup a value if I can't use the item() which is the employeeid that the ForEach is iterating through? or any variable within the query?

Thanks again so much!
Mike Kiser

Answer 1

Hello @Mike Kiser ,
Thanks for the ask and using the Microsoft Q&A platform .

Put the below expression in the query and it should work .( remove white spaces )

@concat('SELECT fullname, emailaddress  
FROM [MercerStagingDev].[MILKY-WAYTEST\AppSQLVST4DotNetDev-R].[EmployeeVendors]  
WHERE employeeid =', item().employeeId)  

Please do let me know how it goes .
Thanks
Himanshu
Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members