Hello, I hope you are doing well ? Working on ADF and using the LookUp activity, I want to read multiple values of a column. This expression : @activity(‘Lookup1’).output.value[1].col2 reads only a value and @activity(‘Lookup1’).output.value.col2 do not work. Rgeards, Aicha Bayram

Hello @Aicha Bayram You can read multiple values / output of your Lookup using ForEach activity and use them inside another activity @activity(‘Lookup1’).output.value[1].col2 will always read only 1 value as you have specified value[1], an index from an array You also can't use @activity(‘Lookup1’).output.value.col2 as the values in output are in form of an array and you need to mention an index You can consume multiple values via ForEach activity

ADF - Read a column values through lookup activity

Accepted answer

Pratik Somaiya 4,201 Reputation points

2022-05-26T11:43:55.687+00:00

Hello @Aicha Bayram

You can read multiple values / output of your Lookup using ForEach activity and use them inside another activity

@activity(‘Lookup1’).output.value[1].col2 will always read only 1 value as you have specified value[1], an index from an array

You also can't use @activity(‘Lookup1’).output.value.col2 as the values in output are in form of an array and you need to mention an index

You can consume multiple values via ForEach activity
Please sign in to rate this answer.
Aicha Bayram 61 Reputation points

2022-05-26T12:33:28.18+00:00

Thank you for your answer. And while using the Foreach activity, the inside activity must be a Lookup and I call the output with the item function ?

Aicha Bayram 61 Reputation points

2022-05-26T12:34:31.41+00:00

@Pratik Somaiya do I have to insert my outputs in a variable beafore calling it in the For each activity ?

Pratik Somaiya 4,201 Reputation points

2022-05-26T12:42:01.617+00:00

@Aicha Bayram

Lookup should be outside your ForEach and you will pass Lookup activity's output to ForEach activity as below:

The Expression for your ForEach will be as below:

@activity('Lookup_metadata').output.value

Aicha Bayram 61 Reputation points

2022-05-26T14:05:30.03+00:00

@Pratik Somaiya how can I read the output of the Foreach activity please ?

Pratik Somaiya 4,201 Reputation points

2022-05-27T04:47:46.65+00:00

@Aicha Bayram

You need to consume the values inside ForEach activity

Also, the output of Lookup activity will directly be consumed by your ForEach expression, you don't need to save it as a variable

James Klein 16 Reputation points

2022-11-19T00:26:32.147+00:00

@Pratik Somaiya I am trying to do something similar. I am trying to get the IDs from a lookup activity and set a variable = to each ID. From there I will do a ForEach activity to get each ID and put it in the variable and then use that variable in the API call to get different data based on the ID. When I use [0] as the array index, the function works except it selects the same ID for each row, because [0] references the first index in the array. How do I get it to loop through the lookup activity and get a new ID each time?

In the forEach items property i have @activity('workspaceids').output.value and for the variable inside the forEach i have the value set to @activity('workspaceids').output.value[0].ID

Pratik Somaiya 4,201 Reputation points

2022-11-21T04:59:45.703+00:00

@James Klein : You are right when you add @activity('workspaceids').output.value in the ForEach activity output

But when you need to select values from lookup output inside foreach then you just need to use @item().<Column_Name>

Here, Column_Name is the column that you need, in your case ID

So, inside ForEach use: @item().ID and this should solve your problem

James Klein 16 Reputation points

2022-11-21T16:14:06.107+00:00

@Pratik Somaiya this worked! however, I am trying to then take that variable and put it in the API relative URL as participations.json?workspace_id=@variables('b')&page={pg} the syntax for the variable in the relative URL is returning an error.

Siddhant Lunawath 0 Reputation points

2023-03-08T05:41:34.02+00:00

Where do I find the documentation in detail for this? @Pratik Somaiya
Sign in to comment

ADF - Read a column values through lookup activity

0 additional answers