HiI 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.

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?

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

george_71239 no, I don't think there's any other way to achieve this. RobLos GallardosIntranet, 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)

Give sharepoint edit permissions to users on one column only

17 Replies

JanXO
Copper Contributor
Aug 23, 2022
george_71239
the next option what you can try, will be automation created via power automate. (work only if you have few predefined values in the column)

Step1: Simple flow witch will update selected item
Step2: Share this flow only with person that have read permission
SYLV1
Copper Contributor
Nov 25, 2021
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.
- george_71239
  Copper Contributor
  Nov 25, 2021
  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?
  - stum
    Copper Contributor
    Feb 09, 2022
    Hi,
    You can achieve this by customizing the form in Power Apps. I don't know how familiar you are with Power Apps but in simple steps:
    Open the list and click on Integrate --> Power Apps --> Customize forms
    Click on App (on the left) and select OnStart part of the form, set a variable as varUser and set it to the current user's email.
    
    Set(varUser, User().Email)
    
    Select the column's Display Mode to Edit if varUser is equal to that user's email, if not leave it as is.
    
    If(varUser = "Email address removed", Edit, Parent.DisplayMode)
    
    Hope this helps to solve your problem.

Forum Discussion

Give sharepoint edit permissions to users on one column only

17 Replies

Resources