I recently worked with a client who needed a simple, automated way to save important emails directly into SharePoint. They received important project updates and approvals in their inbox, but finding those messages later and sharing them with the team often became time-consuming. I suggested using Power Automate to save their email messages in a SharePoint library.
In this tutorial, I will explain how to save an email message to SharePoint using Power Automate. We will also discuss how to save an email message in a SharePoint folder using Power Automate and save an email as a PDF to SharePoint using Power Automate.
Save an Email Message to SharePoint Using Power Automate
For this example, I created a SharePoint document library named Project Communications.
Now follow the below steps:
1. Create an automated cloud flow. Give the flow name and select the trigger When a new email arrives (V3). Then select Subject Filter from Advanced parameters and provide your filter value.
2. Next, we need to export that email using the export email action and select Message ID from the dynamic content of When a new email arrives (V3).
3. Then add the Create File action to save the email in the SharePoint document library and provide below parameters:
- Site Address: Select the site address from the drop-down.
- Folder Path: Choose the library name.
- File Name: Provide Subject from dynamic content with the .eml extension.
- File Content: Provide Body from dynamic content of Get email action.
Now, click Save and run the flow manually. You will notice that the flow is triggered whenever an email arrives with “Product” in the subject line.
My flow triggers when I receive an email from the other user with the subject content Product as shown below screenshot:
After the flow runs successfully, go to the SharePoint document library, and you will see that the email has been moved.
Save An Email Message to a SharePoint Folder using Power Automate
For example, suppose you are working on a project that requires saving all client emails to a folder in the “Project Communications” SharePoint library. In that case, this flow will help automate that process. Each email will be saved with a unique name, making it easy to track and retrieve later.
1. Create an automated cloud flow. Give the flow name and select the trigger. When a new email arrives (V3) here, you can save only certain emails based on the subject, sender, or importance. In my case, I want to filter based on the sender. So select From from Advanced parameters and provide the sender with an email.
2. Next, add the Export email (V2) action and select Message ID from the dynamic content when a new email arrives (V3).
3. Add the Create new folder action from SharePoint. Then choose your Site Address, select the Library, and Provide a Folder Path like the below expression:
concat(triggerOutputs()?['body/subject'], '-', formatDateTime(utcNow(), 'yyyyMMdd-HHmmss'))You can give any name but not any particular character.
4. Next, Add the Create file action from SharePoint, choose your Site Address, and provide the Folder Path as Full Path from the dynamic content of the Create new folder action. Set File Name to the Subject from dynamic content with the .eml extension and File Content to the Body from the Export email (V2) action.
Now, click Save and run the flow manually. Then, send an email from Patti Fernandez to Lidia Holloway.
After the flow runs successfully, go to the SharePoint library. You’ll see that the folder has been created successfully. When you click on the folder, you’ll find the file created inside it.
You can add conditions to store only high-priority emails or emails from specific addresses.
Save the Email as a PDF to SharePoint Using Power Automate
If you want to record client communications or project updates as PDF files in SharePoint, this flow will save each email as a PDF in a specified folder with a unique file name. For example, you could use a document library like “Client Communications” to store all client-related emails as PDFs.
To save an email as a PDF to SharePoint using Power Automate, follow the below steps:
1. Select Automated cloud flow and choose the trigger When a new email arrives (V3). Next, add the Export email (V2) action and select Message ID from the dynamic content when a new email arrives (V3).
2. Next, add the create file action from OneDrive and provide the below parameters:
- Folder Path: Select the folder path in OneDrive where you should save the email.
- File Name: Provide Subject from dynamic content with the .eml extension.
- File Content: Provide Message ID from the dynamic content when a new email arrives (V3)
3. Now, we need to convert that email to pdf. For this, I add a convert file action and provide the parameters below:
- File: Provide Id from the create file dynamic content
- Target Type: Select the PDF from the drop-down.
4. Now, our PDF file is created in OneDrive. Where you store it depends on your preference. In my case, I want to store it in a SharePoint library. So, I added a create file action from the SharePoint connector using the below parameter:
- Site Address: Provide which site you want to store.
- Folder Path: Provide Where you wish to store.
- File Name: Provide file name. You can give a different name, but I want the same name as onedrive.
- File Content: Provide the File content from dynamic content.
5. Next, add an action that deletes the onedrive pdf file. To do this, add a delete file action from OneDrive for business. Then, provide an ID from dynamic content.
Let’s save the flow and test it manually. Then, send an email from Patti Fernandez to Lidia Holloway.
When the flow runs successfully, you can check that the file has been created in PDF format in the SharePoint document library.
Then, you can open the PDF and see the result.
Save a Specific Email Message to SharePoint using the Power Automate
I will explain how Power Automate saves emails to a SharePoint library based on subject and sender.
Automatically Save Emails to a SharePoint Library Based on the Subject
Create an automated cloud flow, select the trigger “When a new email arrives (V3)”, select Subject Filter from Advanced parameters, and provide your filter value.
Subject Filter = "Project Update"
To save the email in the SharePoint document library, add the Export email action and then the Create File action.
Save the flow and run it manually. After the flow runs successfully, an email with the subject containing “Project Update” will be stored in the designated SharePoint library.
Automatically Save Emails to a SharePoint Library Based on the Sender
In the same way, Create an automated cloud flow and select the trigger “When a new email arrives (V3).” Select From from Advanced parameters and provide your sender’s email address.
From = "Sender Email Address"
The remaining step is the same as adding the Export email action and then the Create File action.
When I receive an email from that person, it should be saved in the SharePoint document library.
It’s not just the sender; you can also filter emails based on the To or CC fields. Use the advanced parameters to add the email address.
Automatically Save Emails to a SharePoint Library Based on the Priority
Suppose you want emails marked as “High Priority” to be automatically saved to a SharePoint library.
In Power Automate, create a new automated cloud flow. Use the trigger When a new email arrives (V3) and set the Importance to the desired priority level (e.g., High for critical emails).
Importance = "High"
To save the email in the SharePoint document library, add the Export email action and then the Create File action.
Save the flow and test it by sending yourself an email with the priority level set to High. Then, check the SharePoint library to confirm the email was saved.
This flow will capture incoming emails, convert them to PDF, and save them in a specific SharePoint document library.
Conclusion
In this article, I covered some methods for saving emails into SharePoint using Power Automate. I started by showing how to save an email as a .eml file to a specific SharePoint document library, filtering by subject or sender as needed. Then, I explained how to create a folder for each email in SharePoint. Finally, we see converting emails to PDFs before saving them in SharePoint.
Also, you may like some more Power Automate articles:
- Save Microsoft Forms Responses to Excel Online using Power Automate
- Embed an Image into an Email in Power Automate
- Send a No Reply Email from a Specific Sender Name in Power Automate
- Export SharePoint List to Excel and Send an Email Using Power Automate
- Save SharePoint List Attachments to a SharePoint Library Using Power Automate
Preeti Sahu is an expert in Power Apps and has over six years of experience working with SharePoint Online and the Power Platform. She is the co-author of Microsoft Power Platform: A Deep Dive book. As a Power Platform developer, she has worked on developing various tools using Power Apps and Power Automate. She also makes Microsoft 365 videos and shares them on YouTube.
