SharePoint Document Issues

How to Prevent SharePoint Files from Retaining Old Approval Metadata

Kushani Nimanthika Oct 14, 2026 868 views

Question details

The user needs a method to stop SharePoint from keeping outdated approval metadata when a document is revised, replaced, or processed via Power Automate.

How to Prevent SharePoint Files from Retaining Old Approval Metadata

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Uploading renamed or revised files to a SharePoint library where existing files are replaced, copied, or run through a Power Automate approval flow.
Observed behavior: The newly uploaded or replaced file incorrectly inherits the old approval metadata, causing the new document to appear as already approved.

Before you start

Verify your SharePoint library's versioning and content-approval settings, and ensure you have sufficient permissions to edit workflows in Power Automate.

Solution 1Recommended

Reset Metadata Using a Power Automate Flow

Implement a Power Automate workaround to automatically clear out old approval data before triggering a new approval process.

Because SharePoint natively retains column properties when replacing files, you can use a Power Automate flow to explicitly reset the approval columns immediately after a file is uploaded.

Open your existing approval flow

Navigate to Power Automate and open the flow associated with your SharePoint library's approval process.

Add a condition to check metadata

At the very beginning of the flow, add a condition that checks if the approval column contains anything other than its default, unapproved value.

Reset to default values

If the condition is met, use the 'Update file properties' action to reset the approval and status metadata fields back to their default, blank, or unapproved states.

Trigger the approval process

Ensure the actual approval action only runs after this reset step has been successfully completed, ensuring clean metadata.

Reset Metadata Using a Power Automate Flow

Temporary Metadata Display: The uploaded file may briefly display the old metadata in the SharePoint library until the Power Automate flow successfully runs and resets the values.

Solution 2

Upload the Revision as a New File Item

Ensure a completely clean slate for metadata by avoiding file replacement and uploading revisions as entirely new items.

Solution 3

Contact Microsoft 365 Support

If the issue persists and causes systemic environment problems, contact your Microsoft 365 administrator to initiate a backend investigation.

Free Microsoft Office alternative

Try WPS Office for Seamless Document Management

While SharePoint handles complex backend workflows and storage, creating and editing your actual documents is a breeze with WPS Office. It provides a lightweight, highly compatible, and free alternative to Microsoft Office for all your daily word processing, spreadsheet, and presentation needs.

1. Download and Install: Visit the official WPS Office website and download the free installation package for your operating system.
2. Open Your Documents: Launch WPS Office and directly open any documents you have downloaded from your SharePoint environment.
3. Edit and Save: Edit your documents with familiar tools and save them in standard Office formats to re-upload them seamlessly to SharePoint.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx)Lightweight installation that runs smoothly on older devicesFree to use with a familiar, easy-to-navigate tabbed interfaceBuilt-in PDF editing capabilities for streamlined document workflows

microsoft office alternative - wps office

Frequently Asked Questions

Why does SharePoint keep old metadata when I overwrite a file?

SharePoint retains column properties and metadata by default when a file is replaced or updated. This is designed to maintain version history and preserve the document's original context within the library.

Can I completely disable metadata retention for replaced files in SharePoint?

No, you cannot completely disable metadata retention for file replacements natively in SharePoint. The most effective workarounds are utilizing Power Automate to clear specific column values or uploading revised files as entirely new items.

Will clearing metadata via Power Automate affect my file's version history?

Yes, modifying column values via Power Automate will create a new version of the document if versioning is enabled in your library. However, the older metadata will still be accurately preserved and viewable in the historical versions.

Document & File Issues