Power Automate: Save An Email Message To SharePoint

Imported reference from Matthew Devaney's blog for learning purposes. Original: https://www.matthewdevaney.com/power-automate-save-an-email-message-to-sharepoint/. Author: Matthew Devaney.

Power Automate: Save An Email Message To SharePoint Posted by - Matthew Devaney on - February 11, 2024 49 Comments

It is a common task to save a copy of an email message to SharePoint as backup. With Power Automate, we can save incoming/outgoing email messages and their attachments to a SharePoint Document library. We also have the option to place the email message in a folder or add metadata to make it easier to find later on. Table of Contents

Introduction: The Legal Department Emails Archive

Setup The SharePoint Document Library To Hold Emails

“>Configure The “When A New Email Arrives” Trigger Settings

“>Export And Save The Email To SharePoint

Run The Power Automate Flow To Save An Email To SharePoint

Introduction: The Legal Department Emails Archive

The legal department at an insurance company has conversations with outside counsel through email. A Power Automate flow is used to save incoming emails to SharePoint as an [.eml] file.

The saved emails can be re-opened in Outlook along with their attachments.

Setup The SharePoint Document Library To Hold Emails

Create a new document library named Legal Conversations in SharePoint. This document library will be where emails are saved to.

Configure The “When A New Email Arrives” Trigger Settings

Open Power Automate and create a new automated flow using the Office 365 Outlook – When A New Email Arrives In A Shared Mailbox (V3 ) trigger. Choose the Folder named Inbox.

Go to the trigger’s Settings and enable Split On . This tells Power Automate to evaluate each email individually as it arrives in the inbox. Export And Save The Email To SharePoint

To get the email’s content we must export it. Insert an Office 365 Outlook – Export Email (V2) action and supply the Message Id from the flow’s trigger. Use the same shared mailbox address as the trigger does.

Note that the export email action only works with a shared mailbox.

Then add a SharePoint – Create File action to the flow. Target the Legal Conversations document library in the Folder Path . Use the received email’s subject as the filename followed by the extension [.eml]. Load the File Content property with the body of the export email action.

Run The Power Automate Flow To Save An Email To SharePoint

We’re done. Save the flow and perform a manual test by sending an email to the target inbox.

The flow will complete successfully and a new email will show in the SharePoint document library.

Open the email to view its contents. Attachments cannot be shown while in SharePoint. To do this, press the Download button then open the email file in Outlook.

The attachments are able to be opened now. Did You Enjoy This Article? 😺

Subscribe to get new Copilot Studio articles sent to your inbox each week for FREE Enter your email address Sign Me Up Questions?

If you have any questions or feedback about Power Automate: Save An Email Message To SharePoint please leave a message in the comments section below. You can post using your email address and are not required to create an account to join the discussion. Matthew Devaney Power Automate

Save Docusign Document To SharePoint With Power Automate