Home > Software engineering >  Azure Data Factory - Passing lookup value/id into ForEach copy task not working
Azure Data Factory - Passing lookup value/id into ForEach copy task not working

Time:12-10

I'm attempting to pass the ID from one storage routine into another copy task, which requires a for each to recursively process each ID. I've setup the Lookup ID task, which is working. It's passing these objects into my for each, in which the settings are "sequential" with items set to the following: @activity('LookupUID').output.value

enter image description here

  1. I am looping these IDs in the ForEach activity and passing the current item to a variable.

ForEach activity setting: Items- @activity('Lookup1').output.value

enter image description here

  1. I have a string variable in which I am passing the current item as below using Set Variable activity.

@string(item().ID)

enter image description here

Output:

enter image description here

CodePudding user response:

Use this code and replace with your column name

@activity('lookup1').output.firstrow.columnname

  • Related