Update data using Update Data activity and Javascript code

tejashriw155148

05-12-2019

Hi,

How to update schema using update data activity where input for update data activity should be result of javascript code?

updateData_Query.PNG

In the above workflow, I have created an expression emailAddress = "" and in the JS code sets the value for emailAddress.

Used newly created field in update data activity as below:

updateData_Query1.PNG

But email field from recipient is not getting updated.

Please let me know what should I do here.

Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

Answers (1)

Answers (1)

wodnicki

MVP

05-12-2019

Hi,

For vars.varname in js, source field is $(vars/@varname).

You can also cast as needed, $string(vars/@varname) and so on.

If you want rows to have different emails, alter the target table in the js and use that.

Thanks,

-Jon