Operation on target ForEach1 failed: The function 'length' expects its parameter to be an array

[CheenuSing]

Hi,

I am using Fabric trial licence.

I created a pipeline with Lookup as startting point to retrieve SchemaName and TableName from on prem sql database.
It wotks fine and gives me the desired output.

Then I created a For Each activiy to copy data from each table to a landing areas in the lakehouse

settings for ForEach

Then I set up the copy activity within for each

I get the error 
Operation on target ForEach1 failed: The function 'length' expects its parameter to be an array or a string. The provided value is of type 'Object' .

If I change the setting for For Each to @activity('Lookup1).output.firstRow

still get the same error.
How to fix this error ?

Cheers
CheenuSing

[nilendraFabric]

Hi @CheenuSing 

try Modify the ForEach `Items` property to reference the full array from the Lookup output:

@activity('Lookup1').output.value