How to send an image to team or outlook using pipeline

[w_maytinee]

Hi, 

I have a notebook that generates an image and store it as a .PNG file in my lakehouse. I want to automatically send a message with this image attached to my message to MS team or outlook. How could I achieve this using pipeline. I try to use expression builder but that works with sending text only. Any advice is appreciated. 

Thank you. 

[Anonymous · Accepted solution]

Hi @w_maytinee ,

I did some testing and when configuring outlook activity in pipeline, inserting an image requires a URL to be entered.

If I enter the URL of the image from lakehouse, the image is displayed incorrectly, I think the reason may be in the format in which lakehouse stores the image, although the type is displayed as png, when I try to save the image locally, the format is displayed as txt.

When I find a random image on the internet and copy the image link into the outlook activity image URL, it works fine.

I think you have to upload the image to the web and then copy its image link to get the image in outlook activity to work.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[w_maytinee]

@Anonymous thank you so much. Yes, it work when I paste image URL link in outlook activity.

But then the image I attach will have to change every time I run the pipeline, so the image URL input has to be dynamic. how should I navigate this?  I try to use notebook activity output in dynamic content but it doesn't work. I am not sure I use it correctly. Please help