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 hello@cloudatica.com or book a session at cloudatica.com
Checkout our articles on / cloudatica
21 июл 2024
