Forum Discussion
Solved
Conditional formula to editable/readonly columns in Sharepoint List based on the column value
Hi All,
I want to asked about set sharepoint online column editable/readonly based on the column value.
Example: if field status = draft > editable, if field status = approve > readonly
Thanks,
Masha
This is not possible using SharePoint default capabilities. To achieve this you have to customize the list form using Power Apps.
You need to set the DisplayMode property of column data card based on status value something like this:
If(ThisItem.Status.Value = "Draft", DisplayMode.Edit, DisplayMode.View)Check below examples for more information:
- Form to 'Read Only' based on Status value column and lookup list
- Make some Text Input fields read-only in Edit Forms
Please click Mark as Best Response if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
1 Reply
This is not possible using SharePoint default capabilities. To achieve this you have to customize the list form using Power Apps.
You need to set the DisplayMode property of column data card based on status value something like this:
If(ThisItem.Status.Value = "Draft", DisplayMode.Edit, DisplayMode.View)Check below examples for more information:
- Form to 'Read Only' based on Status value column and lookup list
- Make some Text Input fields read-only in Edit Forms
Please click Mark as Best Response if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.