Forum Discussion
Scootter
Apr 26, 2019Copper Contributor
Sharepoint Online Permissions
I have a list in SP O365 online, with say, 50 columns. I have made a form with PowerApps so that a user in the permission group 'Contributor' can add information into say 20 columns. So that'...
- Apr 26, 2019You can't at all, since permissions are row based, not column based. Anyone can technically come right into the list and use quick edit, or other means to edit the data if they were really savvy.
Anyway, you're best bet is going to handle it through the PowerApp itself and try to keep them to that. You might even look into splitting the app out on it's own, and using a webpart to access it or mobile etc. Since having it tied to the list directly limits you in that regard to only new form / edit form / view form scenarios. Then just hide the list, or don't put link to it. But link people to the page with your PowerApp webpart, or direct to the powerapp from a link etc. Then you control what they see etc. through the Powerapp itself.
Apr 26, 2019
You can't at all, since permissions are row based, not column based. Anyone can technically come right into the list and use quick edit, or other means to edit the data if they were really savvy.
Anyway, you're best bet is going to handle it through the PowerApp itself and try to keep them to that. You might even look into splitting the app out on it's own, and using a webpart to access it or mobile etc. Since having it tied to the list directly limits you in that regard to only new form / edit form / view form scenarios. Then just hide the list, or don't put link to it. But link people to the page with your PowerApp webpart, or direct to the powerapp from a link etc. Then you control what they see etc. through the Powerapp itself.
Anyway, you're best bet is going to handle it through the PowerApp itself and try to keep them to that. You might even look into splitting the app out on it's own, and using a webpart to access it or mobile etc. Since having it tied to the list directly limits you in that regard to only new form / edit form / view form scenarios. Then just hide the list, or don't put link to it. But link people to the page with your PowerApp webpart, or direct to the powerapp from a link etc. Then you control what they see etc. through the Powerapp itself.
Scootter
Apr 26, 2019Copper Contributor
Thanks, ChrisWebbTech That's what I thought. :(
What we are going to do is set up a permission group that can add to a list, but not edit.
That way they can add to the list and then see all but not edit.
We will also set a view for them and instruct them to always switch to that view.
Cheers!
Scootter