ADF Lookup Activity doesn't work with DataSet parameters Can someone please verify?

You're specifically trying to pass the schemaName.tableName via dataset parameters to a Lookup activity in Azure Data Factory (ADF).

Please follow the steps to Dynamically pass the schemaName.tableName via dataset parameters:

Create two parameters table and schema inside pipeline:

Create a dataset for Azure SQL Database with two Dataset Parameter schemaName and tableName:

In Connection Dataset, Add the Dataset Parameters , inplace of Table as @dataset().schemaName . @dataset().tableName

Note: Check Enter Manually

Now in Settings of Look Up Activity, add the pipeline Parameter expression to Value of Dataset properties.

Expressions: @pipeline().parameters.table and @pipeline().parameters.Schema

Now Debug the pipeline to check.