How to Disable a SharePoint Choice Column After Selecting Yes
Question details
The user needs to lock or disable a Yes/No choice column in a SharePoint list so that users cannot change the value once "Yes" is selected.
- Product
- SharePoint
- Device & OS
- not provided
- Scenario
- Managing list item permissions and preventing subsequent modifications to a specific column to maintain data integrity.
- Observed behavior
- SharePoint natively lacks a setting to disable or lock a single column conditionally after a specific value is chosen.
Ensure you have list owner permissions and access to Power Automate to create workflows connected to your SharePoint list.
Use Power Automate to Restrict Item Permissions
Since SharePoint cannot lock individual columns natively, you can use a Power Automate workflow to stop sharing the entire item once the "Yes" value is selected.
SharePoint does not provide a built-in feature to disable or lock a specific column based on a selected value. To achieve this restriction, you must manage edit access at the item level.
By setting up a Power Automate workflow that triggers when the choice column is set to Yes, you can automatically remove edit permissions for standard users, leaving the item editable only by list owners.
Open Power Automate and create an automated cloud flow triggered by the SharePoint action "When an item is created or modified".
Add a "Condition" action to check if the value of your Yes/No choice column is equal to "Yes".
In the "If yes" branch, add the SharePoint action "Stop sharing an item or a file". Select your site address, list name, and map the Item ID to remove existing permissions.
Optionally, add the "Grant access to an item or a folder" action to ensure the list owners or specific administrative groups retain full edit access to the item.
Save your flow and test it by changing a list item's choice column to "Yes". Verify that standard users can no longer edit the item.
Need a Lightweight Alternative for Document Management? Try WPS Office
While SharePoint handles complex list workflows and permissions, WPS Office provides a streamlined, free alternative for creating, editing, and sharing standard office documents. Enjoy a powerful office suite without the heavy overhead.
Frequently Asked Questions
Can I lock just one column without locking the whole SharePoint list item?
No, SharePoint natively manages permissions at the list or item level, not the column level. You can only restrict access to the entire item to prevent column modifications.
Will list owners still be able to change the value back to No?
Yes, if you configure your Power Automate workflow to retain or grant edit permissions for list owners, they will still be able to modify the item and revert the choice column to No.
Does this require premium Power Automate connectors?
No, standard SharePoint connectors included with your Microsoft 365 subscription are sufficient to trigger workflows and modify item permissions.
Can I hide the column instead of disabling it?
You can conditionally hide columns in the SharePoint list form using conditional formulas, but users with edit access could still modify the data via the quick edit grid view or API.
