How to Automatically Lock a Document When Its Status Changes to Approved
Question details
The user wants to know if a document can be automatically locked for editing when an Approval Status column changes to 'Approved', and unlocked if the status is changed again.
- Product
- Microsoft Office / SharePoint
- Device & OS
- not provided
- Scenario
- Managing document approval workflows to prevent unauthorized edits once a file has been officially approved.
- Observed behavior
- There is no built-in native feature to automatically lock a document triggered purely by a column value change.
Ensure you have owner or administrator permissions for the document library so you can modify file access rights. If you plan to automate the process, verify that your account has access and licensing for Microsoft Power Automate.
Manually Change Permissions or Check Out the File
Since there is no built-in auto-lock feature for column changes, you can manually secure the document once it receives approval.
This manual workaround guarantees that users cannot alter the contents of an approved document without authorization.
Navigate to your document library and locate the specific file whose status has just been changed to 'Approved'.
Right-click the document, select 'More', and click 'Check Out'. This prevents other users from making edits to the file.
Alternatively, click on the three vertical dots (ellipsis) next to the file, select 'Manage Access', and change the permissions of specific users or groups from 'Can edit' to 'Can view'.
If the status changes back to pending or rejected, manually 'Check In' the file or revisit 'Manage Access' to restore editing privileges.
Automate the Workflow Using Microsoft Power Automate
Build a custom Power Automate flow to detect status changes and automatically update the document's sharing permissions.
Try WPS Office for Secure Document Management
If you are looking for an easy way to manage documents and protect them from unauthorized edits without complex automation tools, WPS Office provides an excellent, free alternative to Microsoft Office. It offers robust document protection features and full compatibility with standard Office formats.
- 1. Open your document: Launch WPS Office and open the document you wish to protect.
- 2. Access restriction settings: Navigate to the 'Review' tab on the top ribbon and click on 'Restrict Editing'.
- 3. Apply a password: Check the box to limit formatting or editing, enter a secure password, and click 'OK' to lock the document from unauthorized changes.
Frequently Asked Questions
Can I lock specific sections of a document after approval?
Yes, in word processors like Microsoft Word or WPS Writer, you can use the 'Restrict Editing' feature to lock specific sections while leaving others editable. However, this must be applied manually inside the document.
Does SharePoint have a built-in toggle to lock approved files?
No, SharePoint does not have a native toggle to lock files purely based on a column dropdown change. It relies on features like Check Out, Record Declaration, or custom Power Automate workflows.
How do I unlock a document if it was locked by a Power Automate flow?
You need to manually revert the permissions through the 'Manage Access' panel of the file, or create a reverse condition in your Power Automate flow that restores edit access when the status changes away from 'Approved'.
What happens if someone tries to edit a checked-out file?
If a file is checked out by an administrator or approver, other users will only be able to open it in read-only mode and cannot save their changes directly to the original file.
