SOLVED

Sharepoint Online Permissions

%3CLINGO-SUB%20id%3D%22lingo-sub-486214%22%20slang%3D%22en-US%22%3ESharepoint%20Online%20Permissions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-486214%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20list%20in%20SP%20O365%20online%2C%20with%20say%2C%2050%20columns.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20made%20a%20form%20with%20PowerApps%20so%20that%20a%20user%20in%20the%20permission%20group%20'Contributor'%20can%20add%20information%20into%20say%2020%20columns.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20that's%20great%2C%20and%20I%20can%20set%20that%20group%20so%20they%20can%20add%20via%20the%20form%2C%20but%20cannot%20edit%2C%20as%20I%20don't%20want%20them%20editing%20the%20additional%20columns.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20like%20to%20have%203%20views%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20All%20Columns%3C%2FP%3E%3CP%3E2.%2020%20Columns%20in%20the%20form%20%2B%205%3C%2FP%3E%3CP%3E3.%2030%20other%20columns%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20can't%20seem%20to%20do%20is%20link%20a%20view%20to%20a%20permission%20group.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20is%20to%20say%2C%20make%20it%20so%20anyone%20in%20the%20Contributor%20Group%20can%20only%20see%20View%202%2C%20and%20someone%20in%20the%20'Full%20Control%20Group'%20can%20see%201-3%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20tell%20me%20how%2C%20or%20if%2C%20this%20can%20be%20done%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EScott%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-486214%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-486375%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Online%20Permissions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-486375%22%20slang%3D%22en-US%22%3EYou%20can't%20at%20all%2C%20since%20permissions%20are%20row%20based%2C%20not%20column%20based.%20Anyone%20can%20technically%20come%20right%20into%20the%20list%20and%20use%20quick%20edit%2C%20or%20other%20means%20to%20edit%20the%20data%20if%20they%20were%20really%20savvy.%20%3CBR%20%2F%3E%3CBR%20%2F%3EAnyway%2C%20you're%20best%20bet%20is%20going%20to%20handle%20it%20through%20the%20PowerApp%20itself%20and%20try%20to%20keep%20them%20to%20that.%20You%20might%20even%20look%20into%20splitting%20the%20app%20out%20on%20it's%20own%2C%20and%20using%20a%20webpart%20to%20access%20it%20or%20mobile%20etc.%20Since%20having%20it%20tied%20to%20the%20list%20directly%20limits%20you%20in%20that%20regard%20to%20only%20new%20form%20%2F%20edit%20form%20%2F%20view%20form%20scenarios.%20Then%20just%20hide%20the%20list%2C%20or%20don't%20put%20link%20to%20it.%20But%20link%20people%20to%20the%20page%20with%20your%20PowerApp%20webpart%2C%20or%20direct%20to%20the%20powerapp%20from%20a%20link%20etc.%20Then%20you%20control%20what%20they%20see%20etc.%20through%20the%20Powerapp%20itself.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-486669%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Online%20Permissions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-486669%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%26nbsp%3BThat's%20what%20I%20thought.%20%3A(%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20we%20are%20going%20to%20do%20is%20set%20up%20a%20permission%20group%20that%20can%20add%20to%20a%20list%2C%20but%20not%20edit.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20way%20they%20can%20add%20to%20the%20list%20and%20then%20see%20all%20but%20not%20edit.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20will%20also%20set%20a%20view%20for%20them%20and%20instruct%20them%20to%20always%20switch%20to%20that%20view.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers!%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EScootter%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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's great, and I can set that group so they can add via the form, but cannot edit, as I don't want them editing the additional columns.

 

I'd like to have 3 views:

 

1. All Columns

2. 20 Columns in the form + 5

3. 30 other columns

 

What I can't seem to do is link a view to a permission group.

 

That is to say, make it so anyone in the Contributor Group can only see View 2, and someone in the 'Full Control Group' can see 1-3

 

Can anyone tell me how, or if, this can be done?

 

Thanks!

 

Scott

 

2 Replies
Highlighted
Best Response confirmed by Beau Cameron (MVP)
Solution
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.
Highlighted

Thanks, @Chris Webb 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