Forum Discussion
francescjp
Jan 07, 2023Brass Contributor
Avoid editing columns on edit mode on sharepoint list
Hello: I have created a list where users can ask for a new Teams team to be created. The fields of that list are: - Name of new Teams team - Users that will belong to that team. When use...
francescjp
Jan 08, 2023Brass Contributor
Hello Sven:
I like dirty way. The Team column is a lookup one. I am not able to use it in a calculated column?
You know if it's possible to use a lookup column in calculated column?
Thank you very much.
Francesc
SvenSieverding
Jan 09, 2023Bronze Contributor
francescjp
Mhmm..... You cannot use a lookup column in a calculated column, so this is no longer an option.
We needed the calculated column so that your users cannot easily edit the value in grid view.
So now you need to disable grid view capabilities.
You can do so by selecting
- Gear
- -> List/Library Settings
- ->Advanced Settings
- ->Allow items in this document library to be edited using Quick Edit and the Details Pane?
-> No
Best Regards,
Sven
- francescjpJan 09, 2023Brass Contributor
HelloSvenSieverding :
I have found the perfect solution for this case. Using Power Automate I can modify the permission of each item when it's created. I assign only view permissions. This article shows how to do it.
Thank you very much for your help.
- SvenSieverdingJan 09, 2023Bronze Contributor
You’re welcome.
But keep in mind that that solution will set view permissions for the entire list element, not just for a column of an element. (So you can either edit the entire list element including team name and team members or nothing).
Best Regards,
Sven