Save email content to SharePoint

6 minutes

Microsoft Power Automate provides tools to help you build flows that monitor incoming emails and then save its metadata to Microsoft Lists and its attachment to a document library.

Save email attachments to a SharePoint document library

The Microsoft Outlook connector has a trigger called When a new email arrives, which is used for this unit's example to monitor incoming emails. When a new email arrives, the flow is triggered and saves the attachments to a SharePoint document library. The trigger is watching to determine if the email has attachments AND if it was sent from a specific person with the words "Monthly Report" in the Subject field of the email.

Prerequisites

Access to create a SharePoint document library
Access to Power Automate

Create SharePoint document library

From SharePoint, select the Settings gear icon and then select Site contents.
Select + New and then select Document library.
Select Blank Library.
In the name field, enter Incoming Emails and then select Create.
Select Add column and select Text and select Next. For the name, type From Email and select Save.

You now have a document library created with the necessary columns.

Create the automated flow

From the Power Automate home page, select + Create on the left hand navigation menu, and then select Automated cloud flow.
Name the flow Incoming Emails.
Search for When a new email arrives(V3) in the Choose your flow's trigger field and select it.
Select Create.
Select the trigger and then select Show All from the Advanced parameters field.
Add the options to monitor the incoming emails and only capture the attachments from those who match your criteria. This example is monitoring the To, From, Include Attachments, and Subject Filter fields.
Underneath the When a new email arrives trigger, select the + icon and then Add an action.
Search for Sharepoint, you might need to select See more and then select Create file. If you're prompted to sign in, make sure you select Sign in.
Select the Site Address and Folder Path to the Incoming Emails library.
Select the File Name field. Select the lightning bolt to open the Dynamic Content panel.
Search for Attachments Name and select it.

Note

Power Automate automatically adds an Apply to each action outside of the Create File. This is to make sure that all attachments from the email are created in the SharePoint library.
Select the File Content field. Select the lightning bolt to open the Dynamic Content panel.
Search for and select Attachments Content from the dynamic content.
Underneath the Create file action, select + then Add an action.
Search for SharePoint, and then select the Update file properties action.
In the Update file properties properties panel, select the Site Address and the Incoming Emails library.
Select the Id field and then select the lightning bolt to open the Dynamic Content panel.
Select the body/ItemId from the Create File action.
Select Show All next to the Advanced parameters field.
Select the Title field, then select the lightning bolt to open the Dynamic Content panel.
Search for and select body/Name from the Dynamic Content panel.
Select the From Email field, then select the lightning bolt to open the Dynamic Content panel.
Search for and select From from the Dynamic Content panel.
Select Flow checker to review for any errors and then select Save in the top right hand corner. The entire flow should look like this screenshot.

Run the flow

Your task is complete. Now, when Miriam Graham receives an email from Adele Vance and the email:

Has at least one attachment
Subject field contains the words "Monthly Report"

Then the flow picks up the attachments and saves them in the Incoming Emails library.

The following screenshot shows what the SharePoint library looks like after an email was received.

Tip