Sending email with attachments from SharePoint list - Power Automate recipe

In Power Automate (Microsoft Flow), it's very common to notify people about new items or modified items from SharePoint list e.g. Issue Tracking, Order approval etc. It gets a bit complicated when that item has multiple attachments and you also want to send those attachments in the email notification. In this video, I'll teach you how to do that.
By building this flow (Power Automate), you'll learn following concepts as well:
✅ Array variables - Initialize & Append (to store the attachments) - 09:55 & 13:10
✅ Getting attachment content from SharePoint list is a 2 step process-
* Get Attachments (list of attachments but not the content) - 08:00
* Get Content of each of these attachments (using Apply to each) - 10:48
✅ Right JSON format to use for each attachment (each attachment in the array of attachments) - 13:30
✅ Including attachments in email send - 20:31
✅ Quick Testing - 22:07
A very important takeaway from this video:
If you want to attach multiple files in “send email” step, you have to have an array consisting of JSON objects in a very specific format:
[
{ "Name": (Name of the attachment-1),
"ContentBytes": (Content of the attachment-1)
}
,
{ "Name": (Name of the attachment-1),
"ContentBytes": (Content of the attachment-1)
}
]
In a future video, when I show you how to implement something similar for Approval workflow with attachments, this JSON format changes a bit. A bit weird but that's how Power Automate expects it, so you have to comply with that requirement. (update- this other video is also live now- • Creating Approvals wit... )
Subscribe to this channel to not miss these useful tips and tricks on Microsoft Power Platform - PowerApps, Flow (Power Automate), Common Data Service (Dataverse) etc.
For Training, 1:1 coaching, Newsletters, or Consulting help on Power Platform, Azure, or Data Science, please email us at [e-mail] or book a session at cloudatica.com
Checkout our articles on / cloudatica

[@nadiadamiens3222]

This helped me so much! I was abble to finish my flow ! Thank you so much for putting the time into making this tutorial!

[@Inno94709]

Thanks! Very helpful. 🎉

[@meenufsts]

@This helped me to get attachment on email. I need to add JSON to get Word Document also. I made changes like you suggested in video for multiple attachment. After making those changes, I am not getting any attachment, not any error in flow. How to make it work

[@diegocaobianco]

great explanation! I have a question: how can I select the very last file added to the sharepoint list to send in an email instead of sending all list of attachments?

[@shareqkhan7319]

Very useful video 😊

[@user-tj5xu1oj1k]

Will this also work at Send an Email Notification (V3)?