SharePoint Document Issues

How to Automatically Update SharePoint Metadata When Files Move

Tauseeq MagsiTauseeq Magsi Nov 3, 2026 868 views

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.

How to Automatically Update SharePoint Metadata When Moving Files
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Power Automate

Log in to your Microsoft 365 account, navigate to the app launcher, and select 'Power Automate'. Click on 'Create' and choose 'Automated cloud flow'.

2
Configure the Trigger

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.

3
Add a Condition for Folder Path

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.

4
Update File Properties

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.

5
Save and Test

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.

Create a Power Automate Flow to Retag Files
Connector Requirements: Depending on the complexity of your SharePoint environment, certain third-party connectors or advanced auto-tagging functions in Power Automate may require a premium subscription or an API key.
Free Microsoft Office alternative

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. 1. Download and Install WPS Office: Visit the official WPS website to download the free suite and install it on your device.
  2. 2. Sync Your SharePoint Library: Use the OneDrive sync client to sync your SharePoint document library directly to your local computer.
  3. 3. Open and Edit: Double-click your synced SharePoint documents to open, edit, and save them natively in WPS Office.
Fully compatible with Microsoft Office formats (.docx, .xlsx, .pptx) stored on SharePoint.Lightweight installation that opens large documents instantly.Familiar user interface with no learning curve required.Built-in robust PDF editing and format conversion tools.Free to download and use for your daily document productivity.
microsoft office alternative - 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.