SharePoint Document Issues

How to Automatically Save Outlook Emails to Student SharePoint Folders

Adam Davis Sep 30, 2026 868 views

Question details

A school needs an automated method to save relevant parent emails (both sent and received) from Outlook into the corresponding student folders located in a SharePoint document library.

How to Automatically Save Outlook Emails to Student SharePoint Folders

Product: Microsoft Outlook, SharePoint, Power Automate
Device & OS: not provided
Scenario: Managing school communications and maintaining accurate student records across Microsoft 365 applications.
Observed behavior: Emails are currently remaining in Outlook and require manual transfer to individual student SharePoint folders, which is time-consuming and inefficient.

Before you start

Ensure you have an active Microsoft 365 account with permissions to create Power Automate flows and edit access to the target SharePoint document library. Review your school's data privacy and safeguarding policies before automating student communications.

Solution 1Recommended

Create a Power Automate Flow to Route Emails

Set up an automated cloud flow in Power Automate to detect incoming or outgoing emails and save them directly as files in specific SharePoint folders.

Power Automate connects Outlook and SharePoint seamlessly. By establishing condition rules based on sender email addresses or student identifiers in the subject line, you can automatically route parent-teacher communications to the correct student folder without manual data entry.

Log in to Power Automate

Navigate to make.powerautomate.com and sign in using your school Microsoft 365 credentials.

Create a New Automated Cloud Flow

Click 'Create' on the left sidebar, select 'Automated cloud flow', name your flow, and choose 'When a new email arrives (V3)' as the trigger for received emails.

Set Up Identification Rules

Click 'New step' and add a 'Condition' control. Configure the condition to match specific criteria, such as the sender's email address containing a specific domain or the subject line including a student ID.

Configure SharePoint 'Create File' Action

Under the 'If yes' branch, add the 'Create file' SharePoint action. Select your school's SharePoint Site Address and dynamically select the Folder Path based on the student matched in your condition.

Define File Name and Content

In the 'File Name' field, use dynamic content to insert the 'Subject' or 'Message Id' followed by '.eml'. In the 'File Content' field, insert the 'Body' or 'Message' dynamic content from the Outlook trigger, then save and test your flow.

Create a Power Automate Flow to Route Emails

Processing Attachments: If you also need to save email attachments to the SharePoint folder, you must add an 'Apply to each' loop to process the 'Attachments' array and use an additional 'Create file' action for the attachment content.

Free Microsoft Office alternative

Manage Educational Documents Easily with WPS Office

While Microsoft 365 handles the automated routing of emails via Power Automate, WPS Office serves as a highly efficient, free alternative for creating, editing, and organizing the actual documents, spreadsheets, and presentations saved within your school's directories.

1. Download and Install: Visit the WPS Office website to download the free version for your PC or Mac.
2. Open Your Files: Launch WPS Office and directly open your downloaded educational documents or spreadsheets.
3. Edit and Save: Edit with familiar tools and save your files in standard Microsoft formats for seamless sharing.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx)Lightweight application that runs smoothly even on older school computersFree built-in PDF editing tools for secure sharing of student recordsFamiliar tabbed interface makes multitasking between educational documents simple

microsoft office alternative - wps office

Frequently Asked Questions

Can I automate saving sent Outlook emails to SharePoint as well?

Yes. You will need to create a second, separate Power Automate flow and select 'When an email is sent' (Outlook) as the starting trigger, then follow the same steps to route it to SharePoint.

How do I ensure the email goes to the correct student's folder?

You can use conditional branches in Power Automate. By setting rules that check the sender's email address or specific keywords (like a student ID) in the subject line, the flow can dynamically map the save destination to the correct folder path.

Will this automation respect SharePoint access controls?

Yes, Power Automate operates based on the permissions of the account that created the connection. It will respect the folder-level permissions set in SharePoint, ensuring unauthorized users cannot access sensitive student communications.

Does Power Automate save the email in its original format?

By default, passing the email body to a 'Create file' action saves it as text or HTML. To save it as a native Outlook .eml file, you can export the email using the 'Export email' action in Power Automate before creating the file in SharePoint.

Document & File Issues