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- https://youtu.be/pIhJCcaoHao)
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 https://cloudatica.com
Checkout our articles on https://cloudatica.medium.com
Видео Sending email with attachments from SharePoint list - Power Automate recipe канала Cloudatica
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- https://youtu.be/pIhJCcaoHao)
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 https://cloudatica.com
Checkout our articles on https://cloudatica.medium.com
Видео Sending email with attachments from SharePoint list - Power Automate recipe канала Cloudatica
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Creating Approvals with attachments from SharePoint List - Power Automate Recipe](https://i.ytimg.com/vi/pIhJCcaoHao/default.jpg)
![How to Use Power Automate to Send Emails from Excel with PERSONAL Attachments](https://i.ytimg.com/vi/ku0NM9jhp-A/default.jpg)
![Run a flow when a SharePoint column is modified](https://i.ytimg.com/vi/xvmi21KomK0/default.jpg)
![Create Custom Chatbot for Teams and Query Microsoft Lists Data](https://i.ytimg.com/vi/W7OZNdtkYxk/default.jpg)
![How to learn any language in six months | Chris Lonsdale | TEDxLingnanUniversity](https://i.ytimg.com/vi/d0yGdNEWdn0/default.jpg)
![Send Email with File Attachment from SharePoint Document Library using Power Automate](https://i.ytimg.com/vi/bGG_dTBK6a8/default.jpg)
![Top 25 Power Automate flow tips and tricks for 2021 - hidden gems and new features](https://i.ytimg.com/vi/8O68-cc-QNo/default.jpg)
![7 ways to attach SharePoint documents to an email](https://i.ytimg.com/vi/D7_zkLZdulE/default.jpg)
![Avoid infinite loops with flow trigger conditions in Power Automate](https://i.ytimg.com/vi/oKN4_5o2NUA/default.jpg)
![How to send multiple list items in ONE email using Microsoft Flow](https://i.ytimg.com/vi/0TpjWPYlxY4/default.jpg)
![Cascading Dropdowns in Power Apps from SharePoint list or Excel](https://i.ytimg.com/vi/IWEQwGLcW7Q/default.jpg)
![Power Automate Send Emails with Attachments to different people based on data source](https://i.ytimg.com/vi/-E5AzqM1_R8/default.jpg)
![SharePoint List Item Multiple Attachment in Email Notification using Power Automate](https://i.ytimg.com/vi/ehX_EE8wszs/default.jpg)
![Learn to Use Power Automate with Examples | Create Bulk PDF Files | Planner to Outlook](https://i.ytimg.com/vi/SUsik0FGzI0/default.jpg)
![Send Emails from Excel with Power Automate](https://i.ytimg.com/vi/vg4NmlscoFU/default.jpg)
![Create Simple Document Approval Flows using Power Automate & SharePoint](https://i.ytimg.com/vi/ruu7UJE0KPk/default.jpg)
![Automate SAP data extraction to Excel with Power Automate Desktop - No Coding Required.](https://i.ytimg.com/vi/1206jLK0byU/default.jpg)
![Power Apps: Planning SharePoint Lists Relationships](https://i.ytimg.com/vi/qU22DiaIPpU/default.jpg)
![Flow Approval Attachments - Power Automate Tutorial](https://i.ytimg.com/vi/ShNhn-jSBC0/default.jpg)
![Power Automate Export to Excel | Dynamically create Table, Columns & Add Rows to Excel | Send Email](https://i.ytimg.com/vi/Kupz71dWYyY/default.jpg)