Automating your document management system saves time and reduces human error. One common headache for businesses is manually saving email communications into Microsoft SharePoint for compliance and tracking.
Here is how you can easily automate saving emails as attachments directly to SharePoint using Power Automate. Why Save Emails to SharePoint?
Centralized Data: Keeps all project communication in one accessible place.
Better Collaboration: Allows team members to view correspondence without forwarding chains.
Regulatory Compliance: Creates a permanent, unalterable record of official client decisions.
Storage Optimization: Frees up inbox space by offloading heavy files to cloud storage. Step-by-Step Automation Guide
You can build this automated workflow in less than ten minutes using Microsoft Power Automate. No coding experience is required. 1. Set Up the Trigger
Open Power Automate and select Create > Automated cloud flow.
Name your flow (e.g., “Save Email Attachments to SharePoint”).
Search for and choose the trigger: When a new email arrives (V3) for Office 365 Outlook. Configure the trigger parameters: Select the folder you want to monitor (usually Inbox). Change Include Attachments to Yes.
Change Only with Attachments to Yes if you only want emails that contain files. 2. Initialize the Loop Click New Step. Add the Apply to each control action.
Click inside the input box and select Attachments from the dynamic content menu. This ensures the flow processes every individual file attached to the email. 3. Create the SharePoint File Inside the “Apply to each” container, click Add an action. Search for SharePoint and select Create file. Configure the SharePoint connection details:
Site Address: Choose your target SharePoint site from the dropdown menu.
Folder Path: Select the specific document library and folder where files should live.
File Name: Select Attachments Name from the dynamic content menu.
File Content: Select Attachments Content from the dynamic content menu. 4. Test and Refine Click Save in the top right corner. Click Test, select Manually, and trigger the test. Send a test email with an attachment to your inbox.
Verify that the file automatically appears in your designated SharePoint folder within seconds. Pro-Tips for Advanced Workflows
Filter by Sender: Use the advanced trigger options to only save attachments from specific clients or vendors.
Avoid Duplicates: Use expressions to append the email received timestamp to the file name. This prevents older files from being overwritten by new uploads with identical names.
Organize Dynamically: Set the SharePoint folder path to automatically use the sender’s domain name, sorting files into client-specific folders on the fly.
To help tailor this automation to your exact business needs, please share:
Do you need to save only the attachments, or do you also need to save the body of the email as a PDF?
Should files go into one general folder, or do you need dynamic folders based on the sender or date?
Leave a Reply