Forum Discussion
Give sharepoint edit permissions to users on one column only
Hi I am having the certain problem. I have a sharepoint list shared to users with edit permissions. In this same sharepoint list I have succesfully shared the list to an external user with view onl...
SYLV1 thanks for your answer
Isn't there an easier way to do this can you direct me to a step by step guide to resolve this problem?
There is no colum security level in native SharePoint. If a user can edit an element he can edit all the available columns (including title). He can also add new values.
I do not see an easier or better way to do it on 1 list.
Only other option i can see so far is with 2 lists. List 2 with hidden title, lookup columns on List 1 and specific contribute level access (without creating items). But that would mean creating the items twice to manage comments. (why i proposed a power Apps comments form with Power Automate to update)
I do not see an easier or better way to do it on 1 list.
Only other option i can see so far is with 2 lists. List 2 with hidden title, lookup columns on List 1 and specific contribute level access (without creating items). But that would mean creating the items twice to manage comments. (why i proposed a power Apps comments form with Power Automate to update)
- unreal that Microsoft doesn't have this feature yet and google sheets does. 2 lists would be a nightmare . Do you perhaps have a tutorial on how to guide me with the powerapp and automate solution. I still want the external user to see the whole list so when he clicks a field in the column needing to edit will it take him to a powerapp form and then the update will happen automatically with the flow?
- Hello !
No tutorial except advise to look at some Youtube videos and create the "Getting started with Power Apps"" Template.
I do not have the full context, but i would create a Tablet canvas app, connect the SharePoint List and use it as a datasource for a gallery ( on container for responsive design). Then Add a button to open a popup with comments / save / cancel. Finally save the comment via PowerAutomate on Button after validation.
The app could be exposed in a SharePoint page or accessed directly on a tablet/phoneSYLV1 thanks Sylv, it sounds very complicated, I have found a 3rd party solution for this.
I don't want guests to be opening apps to write comments , thanks again
