question

Matt-9396 avatar image
0 Votes"
Matt-9396 asked KranthiPakala-MSFT answered

Treat String from Lookup as Dynamic Content

I am trying to have a database table drive some of my pipelines and would like to be able to pull in a string that's formatted as a dynamic expression and treat it as if it's dynamic. For example, in my table I would like to store something like the following @concat(variables('var'), ' my name is matt') and then when I reference that value from the lookup rather than it treating it as a string I'd like it to actually perform that concat. Would this be possible?

Thank you.

azure-data-factoryazure-synapse-analytics
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered

Hi @Matt-9396 ,

Welcome to Microsoft Q&A forum and thanks for reaching out.

Unfortunately it is not possible. When we look up the SQL table and get the expressions as a column value from it as lookup output and pass it to subsequent activities using @activity(<lookupActivityName>).output, then the output will be resolved to plain text so the expression would be just treated as a string.

This was earlier confirmed with product team and no workaround at the moment. Please see a similar ask here: ADF: Evaluate string within expression

Hope this info helps.



  • Please accept an answer if correct. 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.




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.