ADF : Dynamic content in parameters related to a Lookup activity

Question

Hello,

I have a lookup activity in and ADF pipeline connected to a set Web Activity :

I need to catch the Name and insert it in my web Activity :

I 've tried multiple combination but still nothing (here an example):
@activity('Lookup1').output.value
@activity('Lookup1').output
@activity('Lookup1').output.firstRow
@activity('Lookup1').output.value[0]
@activity('Lookup1').output.firstRow.name
@activity('Lookup1').output.firstRow['Name']
@activity('Lookup1').output.Response

Thank you for your help !

Answer 1

Hi @Aicha Bayram ,
Thankyou for using Microsoft Q&A platform and posting your query.
As I understand your query, you are trying to refer to the lookup output inside web activity. Please correct me if my understanding is incorrect.

Kindly try using the following expression: @{activity('Lookup1').output.firstRow.Name} as firstRow is checked for you in lookUp activity, 'Name' property is coming inside firstRow JSON.

If you uncheck firstRow in lookup settings , Name property would have appeared in value[] array , so then the expression would have been @{activity('Lookup1').output.value[0].Name}

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you.
  Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators