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!

[sam_wise]

Hey, until microsoft wakes up and allows attachments in pipeline activities, here's a life saver:

Take the URL of the lakehouse file you want to use as an attachment and use that as the path in Web Resource action of Power Automate.

you're welcome! 🙂 

[zzthatcher]

I am trying to get the hang of Power Automate but I am approaching it with this use case for the very first time. Can you please point to any good resources that explain Web Resources and how they are used in Power Automate? I am trying to figure it out myself, but it seems like a bit of a learning curve based on my google searches over the span of a few days. 

I am guessing you're talking about the entra id authenticated get web resource activity. But the "Microsoft Entra ID Resource URI" field doesn't make sense to me for Fabric. 

[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.