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.
9,500 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Suba Balaji 11,186 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