How to Automatically Update SharePoint Metadata When Files Move
Question details
The user needs a way to automatically update file metadata to match a destination folder's default values when moving documents within SharePoint.

- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- Moving or copying documents from one SharePoint folder to another that has different default metadata column configurations.
- Observed behavior
- SharePoint successfully assigns metadata when a file is initially created, but fails to automatically retag or update the metadata when the document is moved or copied to a new folder.
Verify that you have the appropriate permissions to create and manage workflows in Microsoft Power Automate, as standard business users may not have access to these tools.
Create a Power Automate Flow to Retag Files
Set up a custom flow in Microsoft Power Automate that detects when a file is moved and automatically assigns the correct metadata based on its new destination folder.
Because SharePoint does not natively update metadata when a file is moved, Power Automate is the official method for handling this scenario. By creating a trigger based on file modification, you can script the system to detect location changes.
Log in to your Microsoft 365 account, navigate to the app launcher, and select 'Power Automate'. Click on 'Create' and choose 'Automated cloud flow'.
Set your flow trigger to 'When a file is created or modified (properties only)'. Select your SharePoint Site Address and Library Name from the dropdown menus.
Click 'New step' and add a 'Condition'. Configure the condition to check if the 'Folder path' dynamic content matches the specific destination folder you are monitoring.
In the 'If yes' branch, add the 'Update file properties' SharePoint action. Map it to your site and library, use the 'ID' from the trigger, and fill in the new metadata values you want applied.
Save your flow. Move a test document into the destination folder in your SharePoint library, then check the flow's run history to ensure the metadata updated successfully.

Manually Update Metadata using Grid View
If you lack the administrator rights required to create a Power Automate flow, use SharePoint's Grid View to quickly bulk-update metadata after moving files.
Edit Your SharePoint Documents Effortlessly with WPS Office
While SharePoint handles your storage and metadata workflows, you still need a fast, reliable productivity suite to edit your actual documents. WPS Office is a lightweight, free alternative to Microsoft Office that offers full format compatibility, allowing you to seamlessly work on your SharePoint-hosted files without expensive subscriptions.
- 1. Download and Install WPS Office: Visit the official WPS website to download the free suite and install it on your device.
- 2. Sync Your SharePoint Library: Use the OneDrive sync client to sync your SharePoint document library directly to your local computer.
- 3. Open and Edit: Double-click your synced SharePoint documents to open, edit, and save them natively in WPS Office.

Frequently Asked Questions
Why doesn't SharePoint automatically update metadata when a file is moved?
By default, SharePoint only applies column default values when a document is initially uploaded or created directly inside a folder. When a file is moved, SharePoint retains its original metadata to preserve historical data, requiring either a manual update or an automated flow to overwrite it.
Can I use SharePoint Designer workflows to update metadata?
SharePoint Designer 2013 workflows have been deprecated by Microsoft and are no longer supported in modern SharePoint Online environments. You must use Microsoft Power Automate for auto-tagging and metadata updates.
What if I do not have permission to use Power Automate?
If your business administrator has restricted access to Power Automate, you will not be able to automate the metadata update. You must manually update the file properties using the 'Edit in grid view' feature after moving your files, or request your IT department to build the flow for your library.




