Forum Discussion

george_71239's avatar
george_71239
Copper Contributor
Nov 25, 2021

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

17 Replies

  • JanXO's avatar
    JanXO
    Copper Contributor

    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's avatar
    SYLV1
    Copper Contributor
    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's avatar
      george_71239
      Copper Contributor

      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's avatar
        stum
        Copper Contributor

        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.

Resources