Attaching a file to outlook or teams activity in a pipeline

[cmiroslav]

Hello again,

I am trying to use a 'Teams activity' or an 'Outlook activity' at the end of a data pipeline to send a file generated durring the pipeline (in a Lakehouse), but I couldn't find how to attach something to these activities. Is it possbile?

Or can I move this file from a lakehouse somewhere else in Fabric to be abble to share it through a link in an email or teams?

Thanks!

[alxdean]

there are two alternative approaches available too.

1) send some data to a KQL Database, create a semantic model that triggers a measure and create a visual for that measure, on the visual configure the alert to send a trigger to reflex. create a custom action in reflex to trigger a power automate flow that then calls the model to find the latest url and creates an email with attachment. 

2) create the same power automate flow as in 1, but trigger it via https request.  instructions here: Run A Power Automate Flow With An HTTP Request (c-sharpcorner.com) then call the flow with a web activity in the pipeline. less moving parts than option 1.

[alxdean]

pdecarlo is on the right track. You won't be able to create a file attachment directly in the pipeline, but you could pass the url to the file to a function app (which you create in azure) and write some code there to grab the file and send an email with attachment. you would need to send all parameters needed (url to file, email address, extra text, etc) in the body of the post to the function app

[pdecarlo]

@cmiroslav, take a look at https://stackoverflow.com/questions/66764275/attach-file-in-email-using-azure-data-factory-pipeline , not sure how this translates exactly in Fabric world but seems like you could implement something like this in a pipeline via notebooks.