How to save email attachments to a SharePoint Document Library using Power Automate

You can use Power Automate to automatically move your email attachments to a SharePoint document library. In this post I’ll show you how to move email attachments to a SharePoint document library.

This is the flow that we will build:

Image of the flow that we will build

1. Start by creating an automated cloud flow:

Select automated cloud flow

2. Give your flow a name then select the flow’s trigger as When a new email arrives (V3):

Set flow a name then select the flow's trigger

3. Set the following two properties of the When a new email arrives (V3) trigger:

When a new email arrives (V3) trigger
Propertydescription
Include AttachmentsShould the response of the trigger include the attachments content.
Only with AttachmentsIf set to true (Yes), only emails with an attachment will be retrieved. Emails without any attachments will be skipped. If set to false (No), all emails will be retrieved.

4. Add an Apply to each loop (2) and set Attachments as the output (3) as shown below. The loop will save each attachment to a SharePoint Document Library of our choice:

Apply to each loop

5. Add a SharePoint Create file action (4). Select the SharePoint site and document library.

SharePoint Create file action
SharePoint Create file action.

6. Finally select the attachment’s filename and file content (4) from Dynamic content:

SharePoint Create file action
In the example above the Create file action will create a file in a document library called Lib.

Example Runtime output

The example runtime output below shows that the Apply to each loop ran seven times. This means that seven files were sent as file attachments in the email and seven files were saved to SharePoint:

Example Runtime output

Notes

When a new email arrives (V3) – This operation triggers a flow when a new email arrives. It will skip any email that has a total message size greater than the limit put by your Exchange Admin or 50 MB, whichever is less. It may also skip protected emails and emails with invalid body or attachments.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.