hi, how can i break to new line of the message in web activity in azure data factory

Nattapat Dungdee 0 Reputation points
2024-03-15T13:01:40.57+00:00

i try "message" : "@{concat('t1','</br>','t2')}"

it output is

t1

t2

but when i add more text from activicy(lookup)

"message" : "@{concat('t1','</br>','@{activity('Lookup1').output.firstrow.FI_NM})}'"

it output is

t1

@{activity('Lookup1').output.firstrow.FI_NM}

but i want it data of activity in result not command it self

help please, thank you.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,107 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Subashri Vasudevan 11,206 Reputation points
    2024-03-15T13:38:18.3166667+00:00

    Hi,

    You get the output as @{concat('t1','</br>','@{activity('Lookup1').output.firstrow.FI_NM})}, because, you have enclosed the expression in double quotes.

    Try removing the doubt quotes, curly braces and see if that helps. Like below -

    @concat('t1','</br>',activity('Lookup1').output.firstrow.FI_NM)

    Let us know how it goes,

    Thanks

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.