Forum Discussion
Lock and Unlock Columns or cells in Sharepoint List
Hello,
is it possible to lock and unlock Columns or cells? I thought it is possible to have a Flag with Yes/No as Column behind a row which would lock or unlock a Row or Column when it's Yes or No. Is there another option or alternative to do somethings like this? The goal is that, someone in the next Month cannot edit Data from Months before. It's only for Security.
Thank you!
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.
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.
- brandiwoodsonBrass Contributor
Microsoft needs to update list functionaility. It's the most common tool in sharepoint for data management. Not all enterprise wide companies can use power apps and automate given the licensing and not having control over users from creating vs using the tools.
Because of this, we don't even use Power Platform, anyways for day to day users who don't want to educate themselves either on how to built power apps, there needs to be a better way of controlling what fields can be editable.
There should ideally be a new/edit/display toggle per field where owners can specify when it shows.
It's absurd that this functionality doesn't exist yet from Microsoft.
I get they are promoting the heck out of Power Platform but not every company is equipped to train their employees on how to build an app or workflow etc. Enhance lists and library functionality for day to day average joe users that are finally coming over from traditional MS Office tools like shared excel files and word docs etc.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.