Forum Discussion
Lock and Unlock Columns or cells in Sharepoint List
Bajda1225 This is not possible using SharePoint OOTB functionalities.
You need to customize list forms using Power apps & based on date column value, you can disable the form fields by setting "DisplayMode" property of controls to "DisplayMode.View".
Please click Mark as Best Response & Like 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.
brandiwoodson Yes, I agree with your expectations here.
Also, if you want to control on which form (new/display/edit) you want to show particular list fields, you can do it by setting below Boolean properties of list fields:
- ShowInNewForm
- ShowInDisplayForm
- ShowInEditForm
Documentation: Field element (Field)
You can set those property easily using PowerShell.
Please click Mark as Best Response & Like 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.
ganeshsanap right but full control owners can't be expected to be able to do this nor should our IT department be required to run this for every need. We have 50k+ employees. That's absurd.
We need lock and unlock feature per field for disolay mode per field and an option to hide field all together in new, edit or display modes. This also needs to be permissions driven.
Iis extremely difficult to control what users are allowed to update without using JSON and even that is limited. To show a field for info purposes and restrict editing of field should not a fwature that is unavailable.
Its a simple concept and MS has the time to do release new products all year around but they can't invest in sonething so basic?
Hi brandiwoodson ,
I know what you mean and I understand your business needs. Such a functionality would be nice...
What I normally do is create multiple lists and link them together with lookup columns.
So for example I create a list "Projects" and another List "ProjectFinancialInformation". Many people can edit values in the "Project" List and only some people can edit values in the "ProjectFinancialInformation" List.
But in the "Project" List I have a lookup column to the "ProjectFinancialInformation" List and configured that column to project all columns form the other list into the "Project" list.
The effect is that I have all columns from both lists in my "Project" List, but I can only edit financial information if I have permissions to and edit them in the financial information list.
Best Regards,
Sven
