Give sharepoint edit permissions to users on one column only

Occasional Contributor

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 only (READ permissions).

On one of the columns in the sharepoint list I need this person with read permission to be able to edit and comment on the rows , just in this column.

I don't see a way I can do this even with disabling inherritance permisions on this library. Can you please advise.

7 Replies
Hello
I do not think you can do it in native SharePoint in 1 list.
A simple solution could be a PowerApps form (with comments field) and a Power Automate executed by a system account with write access on the list.

@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?

@lazo111 no, I don't think there's any other way to achieve this.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

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)



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/phone


@SYLV1  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