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...
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.
Hello, sweet discusiion. I have the same issue but with a group. Is it possible to proceed in the same way, but give access ti a whole sharepoint group? Thanks in advance.
Sorry for the late reply. Yes there is. You can use:
!IsEmpty(AzureAD.CheckMemberGroupsV2(User().Email,[“groupid"]).value)groupid here is a specific group’s id that you want to check if the user is a member of that group.
same here, I think, kinda sorta.
- I need to create a list with roughly 13 columns in it
- I need to allow a sharepoint security group access to edit this list, all 13 columns
- I need everyone else not in the above security group to have access to VIEW this list but not be able to edit it in any way
- and now the kicker - those with VIEW access, I only need them to see 8 of the 13 columns with the remaining 5 hidden and not accessible at all to the VIEW access group.
- I need to create a list with 18 columns in it.
- I have created a view with 13 columns in it.
- I have created 5 different group access .
- I need to allow the admin group to access edit all the items from the sharepoint list.
- I need certain security group to have access to VIEW but able to edit only the 13 columns in the view.
- But in the edit mode of the view, I do see all the 18 columns. How can I restrict to 13 columns? Please advice.
