How to Automatically Rename and Move Outlook Attachments to OneDrive
Question details
The user wants to automatically identify PDF attachments in incoming Outlook emails, rename them based on specific rules, and save them directly to a designated OneDrive folder.
- Product
- Microsoft Outlook and OneDrive
- Device & OS
- not provided
- Scenario
- Setting up an automated workflow to manage email attachments efficiently without manual downloading and renaming.
- Observed behavior
- Currently, the user has to manually download, rename, and move PDF attachments from Outlook to OneDrive, and is seeking a Power Automate solution to automate this routine task.
Ensure you have an active Microsoft 365 subscription with access to Power Automate, and that your Outlook and OneDrive accounts are linked under the same Microsoft tenant.
Use Power Automate to Auto-Save and Rename Attachments
Create a custom Power Automate flow to detect incoming emails with PDF attachments, apply a naming convention, and save them automatically to OneDrive.
Power Automate (formerly Microsoft Flow) is the most effective built-in tool for connecting Outlook and OneDrive. By setting up a targeted flow, you can bypass the manual process of saving and renaming attachments.
Go to make.powerautomate.com and sign in with your Microsoft 365 account credentials.
Select 'Create' from the left navigation pane and choose 'Automated cloud flow'. Name your flow and select the trigger 'When a new email arrives (V3)' for Office 365 Outlook.
Expand the advanced options in the trigger step. Set 'Include Attachments' to 'Yes' and specify any folder, sender, or subject filters to ensure the flow only runs for the correct emails.
Click 'New step' and add a 'Condition'. Configure it to check if the 'Attachment Name' ends with '.pdf' to ensure you are only moving PDF files.
Under the 'If yes' branch, add the 'Create file' action for OneDrive for Business. Choose your destination folder. In the 'File Name' field, use dynamic content and expressions (like formatting the current date) concatenated with '.pdf' to automatically rename the file. For 'File Content', select 'Attachments Content'.
View and Edit Your Downloaded Attachments with WPS Office
Once Power Automate successfully saves your Outlook attachments to OneDrive, you need a reliable suite to manage them. WPS Office is a free, lightweight, and highly compatible alternative to Microsoft Office, offering powerful PDF and document editing tools without the high subscription costs.
- 1. Download and Install WPS Office: Visit the official WPS website to download the free suite and follow the straightforward installation prompts.
- 2. Access Synced OneDrive Files: Open WPS Office and navigate to your local OneDrive sync folder to instantly access your newly renamed attachments.
- 3. Edit and Save Seamlessly: Open any PDF, Word, or Excel file directly in WPS Office, make your edits, and save changes straight back to OneDrive.
Frequently Asked Questions
Can I automatically rename Outlook attachments without using Power Automate?
No, Microsoft Outlook does not have a native inbox rule to automatically rename incoming attachments. You must use an automation tool like Power Automate, VBA scripts, or a third-party Outlook add-in to achieve this.
How do I filter out image signatures and only save PDF attachments?
In your Power Automate flow, use a 'Condition' step after the email trigger to specify that the 'Attachment Name' must end with '.pdf'. This ensures small images like company logos in signatures are ignored.
Can I save attachments to a shared SharePoint folder instead of personal OneDrive?
Yes. Instead of selecting the OneDrive 'Create file' action in Power Automate, search for the SharePoint 'Create file' action. You can then specify your SharePoint Site Address and the specific Document Library folder path.
