Use list of results of a Lookup activity in a 'WHERE field IN list' condition in Azure Data Factory

as the title states, in an Azure Data Factory pipeline I am trying to use the results of a Lookup activity in a WHERE condition of a query against Salesforce. To be more detailed, the Lookup activity has the option 'Select only first row' NOT selected and it looks as follow: SELECT id FROM staging_table Then I am trying to pass the output to a Copy Data activity that runs a query against Salesforce using the output of the Lookup in a condition that looks like WHERE Id IN @output, however any kind of syntax I try for the activity output results in some errors, I only managed to get it working for the first result of the array. Thank you for any help you may provide!