Version History Issues

How to Fix SharePoint Retention Policies Overriding Version Limits

Maira Mehtab Sep 27, 2026 869 views

Question details

Users are unable to automatically delete older document versions in SharePoint because active retention policies override the library's configured version limits.

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Attempting to enforce a specific version history limit on a SharePoint document library where organizational retention policies are currently active.
Observed behavior: SharePoint preserves document versions beyond the configured versioning limit (e.g., 50 versions), prioritizing the organization's retention rules over standard version deletion settings.

Before you start

Verify with your IT or Compliance administrator to confirm if there are active Microsoft Purview retention policies applied to your specific SharePoint site or document library.

Solution 1Recommended

Use Power Automate to Manage Excess Versions

Create a custom Power Automate flow as a workaround to automatically delete excess document versions that exceed your desired limit.

Because SharePoint retention policies natively take precedence over library versioning settings, older versions will not be deleted automatically by the library limits.

To bypass the standard library behavior, you can implement a custom Power Automate flow. Be aware that deleting these versions via flow will move them to the Preservation Hold Library rather than permanently deleting them, keeping your site compliant with the retention policy.

Access Power Automate

Set the Flow Trigger

Choose a SharePoint trigger such as 'When an item or a file is modified' and connect it to your specific site address and document library.

Configure Version Deletion Logic

Add actions to get the file's version history, count the existing versions, and add a condition to delete the oldest versions if the count exceeds your preferred limit.

Consult the Community for Custom Templates

For specific flow expressions and templates, visit the Microsoft Power Automate Community at https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity to ask if your designed flow meets your exact requirements.

Preservation Hold Library: Versions deleted by the Power Automate flow are not permanently erased. They are moved to the hidden Preservation Hold Library and will remain there consuming storage until the compliance retention period expires.

Free Microsoft Office alternative

Simplify Document Management with WPS Office

If complex SharePoint retention policies and Office configuration limits are complicating your workflow, consider switching to WPS Office. It provides a lightweight, user-friendly environment for document creation and sharing without forcing complex server-side compliance rules on your local version history.

1. Download and Install: Visit the official WPS Office website to download the free suite and follow the simple installation instructions.
2. Open Your Office Files: Launch WPS Office and directly open your existing Word, Excel, or PowerPoint documents with complete formatting retention.
3. Manage Local Backups: Use WPS Office's built-in local backup center to easily manage your document versions and restore previous states without cloud policy restrictions.

Fully compatible with Microsoft Office formats including .docx, .xlsx, and .pptx.Clear and easy-to-manage local document history without confusing retention conflicts.Lightweight suite that uses minimal system resources and opens files instantly.Free to use with a highly familiar user interface for a seamless migration.

microsoft office alternative - wps office

Frequently Asked Questions

Why is SharePoint ignoring my versioning limits?

SharePoint prioritizes compliance and legal holds. If a retention policy is applied to your site, it actively overrides the library's local versioning limits to prevent the automatic deletion of records required for compliance.

Can I permanently delete versions while a retention policy is active?

No. Even if you manually delete versions or use a Power Automate flow to remove them from the library, SharePoint will automatically route those deleted versions to the Preservation Hold Library until the retention period concludes.

Where do the excess versions go when deleted by a Power Automate flow?

They are transferred to the Preservation Hold Library. This is a system-managed library designed to store retained content securely so that administrators can retrieve it during an eDiscovery search if necessary.

Document & File Issues