Use Notebook Variable in Email Activity

[kewaynes333]

I have a varibale in a notebook called 'messages'. I have an Outlook activity connected to the Notebook activity. How can I reference this varibable in the Outlook activity to use it in the body of the email?

[jwinchell40]

@kewaynes333  - I'm not sure what kind of object "messages" is but you can pass data back from the Notebook via the Exit Variable.

• mssparkutils.notebook.exit(<value>)

It can be a simple string or a json/array value among other things. You should then be able to reference it in the set variable by doing:

• @activity(<activity_name>).output.result.exitValue

If you send back a JSON object you can convert the string in the pipeline use @Json() and then reference values within the JSON object.

• @Json(activity(<activity_name>).output.result.existValue).<property>

[Anonymous]

Hi @kewaynes333 ,

Thanks for using Fabric Community.

As @jwinchell40 said, please follow the below steps to get data from Notebook to Pipeline.

Hope this is helpful. Please do let me know incase of further queries.

[Anonymous]

Hi @kewaynes333 ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

Thanks

[Anonymous]

Hi @kewaynes333 ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

Thanks