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?
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?
Hi. No problem.
1. Yes. You need to unlock the data card to make changes for the property if it is locked.
2. No. Please make the change at DataCardValue12 because that's the control you want to change the display mode.
3. Yes. That is correct. The if statement is checking the user's email address if it is matching with the one typed in the statement and if so it is setting the display mode to Edit, and if not it is inheriting the parent's display mode which can be View or Edit depend on user's permission. If it is a group people there is a different method to use.
4. To make the changes on the form, all you need Power Apps access and edit rights on the list which I see from the pictures that you have it.
When you are done you need to save the form and publish it. Otherwise your changes won't be updated on the form.
