Forum Discussion

kewaynes333's avatar
kewaynes333
Helper I
2 years ago

Use Notebook Variable in Email Activity

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 t...
Need Help
Pipelines
jwinchell40's avatar
jwinchell40
Resolver III
2 years ago

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's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      Anonymous
      Not applicable
      2 years ago

      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's avatar
        Anonymous
        Not applicable
        2 years ago

        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