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...
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.
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?
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.
stum thank you for your help
unfortunately it did not work
May be the following may help to identify what I am not doing to make it work:
1. I had to unlock the datacard - otherwise it would not let me make the change to the DisplayMode
Should I unlock the data card to make the changes?
if so after I unlock should I leave the datacard unlocked?
2. Should I make the change at the top level for that datavalue items or at the datavalue field - see screen shot below ( i tried both) see pictures attached
3. also in the if(varUser = "Email address removed", Edit, DisplayMode) - i used the actual email of the person that would be able to edit this column. is this correct?
4. should i be logged in as the owner of this list to make these changes?
- 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?
george_71239 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)
