Can I use Power Automate Save Email Attachments to SharePoint?

Microsoft Power Automate is a powerful service for you to create automated workflows between many apps and services to sync files, get notifications, generate data, and more. Microsoft Power Automate supports services including Gmail, Office 365 Outlook, OneNote, SharePoint, OneDrive for Business, Microsoft Forms, Planner, Microsoft Teams, Outlook.com, SQL Server, and many more.

So, Can Power Automate save emails to SharePoint? Definitely. How to use Power Automate save email attachments to SharePoint? You’re in the right place because today we will show you the detailed steps to use Power Automate to migrate Gmail email attachments to SharePoint.

Save Gmail Email Attachment to SharePoint

1. Please go to Microsoft Power Automate, and click Create on the left panel.

Create Automated Cloud Flow
Create Automated Cloud Flow

2. Rename Flow Name and tick When a new email arrives Gmail or When an email arrives (V3) Office 365 Outlook in Choose your flow’s trigger according to your need, and click Create. (Here we take Gmail for example)

When A New Email Arrives Gmail
When A New Email Arrives in Gmail

Note: If you would like to save email attachments from Outlook.com, you can choose When an email arrives (V3) Office 365 Outlook in this step.

3. Sign in to your Gmail account. Select the Inbox label or other labels that you want to save email attachments. Select Yes for both Has Attachments and Include Attachments, and hit + New step.

Set Up When A New Email Arrives in Gmail
Set Up When A New Email Arrives in Gmail

Tips: You can also set up other fields to save the email attachments that from specific emails.

4. Type in Apply to each and choose it from Actions.

Apply to Each
Apply to Each

5. Input Attachments in the Dynamic content, then choose it and hit Add an action.

Choose Attachments in Dynamic Content
Choose Attachments in Dynamic Content

6. Input SharePoint, and choose Create file SharePoint from the result. Then sign in to your SharePoint account.

Create File in SharePoint
Create File in SharePoint

7. Choose your Site Address, Folder Path, File Name, and File Content. Set Attachments Name as File Name, and Attachments Content as File Content, and click Save to save Gmail email attachment to SharePoint in Power Automate.

Create File with Attachments Name And Content
Create File with Attachments Name And Content

8. Click Test > Manually or Automatically > Test to test the task for power automate save email attachment to SharePoint.

You have to send a new email with email attachments to test if the task is set up correctly. Then you can see the email attachments have been saved to SharePoint.

Power Automate Save Email Attachment to SharePoint with Different Name

If you prefer to make Power Automate save email attachment to SharePoint with a different name:

1. You have to follow the step 1-3 above.

2. Then input "variable" and choose Initialize variable to create two variables.

Initialize Variable
Initialize Variable

3. Set up AttachmentName in Name, and String type, and click + New step. Repeat the process to set up FileName in Name, and String type.

Set Up Two Variables
Set Up Two Variables

3. Click + New step, type apply to each, and choose it. Then select Attachments from dynamic content, then click Add an action.

Add An Action
Add An Action

4. Then input "condition", and choose it, then select AttachmentName you created as a value, containing docx, or other file types you want to save with different name.

5. Click Add an action in the If yes section, input and choose Set variable, Select the AttachmentName you created and Attachment Name in value. Then customize the file name you want.

Customize The File Name
Customize The File Name

6. Type and choose Get email details Gmail, and choose Message ID, and select Yes in the Include Attachments.

Get Emails Details in Gmail
Get Email Details in Gmail

7. Then hit Add an action, input "create file", choose Create File SharePoint, choose the Site Address and folder path to save the email attachments, and choose the variable FileName in the File Name section, Attachments Content in the File Content section, click Save.

8. And now, you can test it to let Power Automate save attachments to a SharePoint-specific folder with a different name.

If you would like to use Power Automate to save email attachments to SharePoint list, it’s much more complex to set up, so here we will not show the steps.

Tip: Better Easy Way to Save Email Attachments to SharePoint

According to the above ways to save email attachments to SharePoint, it’s quite complex for all of us to set it up. If you’d prefer an easy way to save email attachments to SharePoint, the powerful web-based multi-cloud manager - MultCloud will do you a big favor.

MultCloud is able to migrate Gmail emails with all attachments to SharePoint, and other 30+ clouds, and Office 365 Mail and Outlook.com will be soon supported. The email-supported version of MultCloud will be released before June.

 

Here are the steps to save Gmail emails attachments to SharePoint with MultCloud:

1. Please create a new MultCloud account and sign in.

Log in to MultCloud
Log in to MultCloud

2. Click Add Email > Gmail to add, then click Add Cloud > SharePoint Online to add.

Add Gmail
Add Gmail

3. Select Email Migration, choose Gmail as the source, and select a subfolder in SharePoint as the target.

Migrate Gmail to SharePoint Online
Migrate Gmail to SharePoint Online

Tips: Before clicking migrate now, you can set up the useful features below:

  • The Options is capable of saving attachments, quoting information in conversations, or the last message only. Besides, you can enable email notification to monitor the task easily.
  • The Schedule is able to migrate email attachments to SharePoint daily, weekly, or monthly, which is very useful to perform unattended tasks.
  • Email Filter allows you to only migrate the specific emails and attachments that you customize for From, To, Date and others.
Email Filter
Email Filter

4. Press Migrate Now to save Gmail email attachments to SharePoint directly.

  • Smart: Easily share cloud files via public, private, or source mode.
  • Efficient: One-key data transfer, sync, and backup between clouds.
  • Safe: Full-time 256-bit AES and OAuth authorization protections.
  • Easy: Access and manage all clouds in one place with one login.
  • Extensive: 30+ clouds and on-premise services are supported.

The End

Now, you have mastered how to use Power Automate to save email attachments to SharePoint, just follow the above steps to save email attachments to SharePoint in Power Automate. If you prefer an easy way to migrate Gmail email attachments to SharePoint, MultCloud is your best choice, so why not give it a try?

Besides, you can backup Gmail emails to USB, and other devices with MultCloud, and save emails and attachments to OneDrive, Dropbox, and other clouds directly.

MultCloud Supports Clouds

Multcloud Key Features