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.
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)
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.
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.
5. Input Attachments in the Dynamic content, then choose it and hit Add an action.
6. Input SharePoint, and choose Create file SharePoint from the result. Then sign in to your SharePoint account.
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.
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.
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.
3. Click + New step, type apply to each, and choose it. Then select Attachments from dynamic content, then click 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.
6. Type and choose Get email details Gmail, and choose Message ID, and select Yes in the Include Attachments.
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.
2. Click Add Email > Gmail to add, then click Add Cloud > SharePoint Online to add.
3. Select Email Migration, choose Gmail as the source, and select a subfolder in SharePoint as the target.
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.
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.
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.