Forum Discussion
Solved
How to use parameters in Lookup activity Query
Hey All, I'm new to fabric and running into a syntax issue. I have created a lookup activity that queries a on-prem database. I want the query to return a file name. I'm just trying to learn an...
Convert the SQL into a stred procedure and when using the Lookup, select stored procedure then you can import the parameters into the lookup activity and place the parameter in the expression builder.
Convert the SQL into a stred procedure and when using the Lookup, select stored procedure then you can import the parameters into the lookup activity and place the parameter in the expression builder.