topic Re: Use Notebook Variable in Email Activity in Pipelines

Use Notebook Variable in Email Activity

kewaynes333 — Fri, 31 May 2024 21:23:16 GMT

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?

Re: Use Notebook Variable in Email Activity

jwinchell40 — Sat, 01 Jun 2024 14:33:34 GMT

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>

Re: Use Notebook Variable in Email Activity

Anonymous — Mon, 03 Jun 2024 06:45:49 GMT

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.

Re: Use Notebook Variable in Email Activity

Anonymous — Tue, 04 Jun 2024 11:30:28 GMT

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

Re: Use Notebook Variable in Email Activity

Anonymous — Wed, 05 Jun 2024 09:16:58 GMT