title: Passing dynamic content inside a SQL Query in lookup stage of Azure Data Factory
body: <p>I'm using a lookup stage as a source to fetch some data and i want to pass that output as the input to the next lookup stage. I tried adding @activity('Step1').output.firstRow.Col and it failed with scalar variable was not being declared. Also tried with @{activity('Step1').output.firstRow.col} which failed and the log shows only default expressions supported. Please help if it is possible.</p>
  <p>I have accomplished this using dataflow, but considering the performance i would like to know if it can be done in a pipeline.</p>