SOLVED

SharePoint List view depending on user group

%3CLINGO-SUB%20id%3D%22lingo-sub-2077064%22%20slang%3D%22en-US%22%3ESharePoint%20List%20view%20depending%20on%20user%20group%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2077064%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20client%20who%20has%20asked%20if%20a%20SharePoint%20list%20could%20be%20filtered%20by%20a%20persons%20permissions%20group%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThey%20have%20several%20locations%20which%20each%20have%20a%20user%20rights%20group%20to%20the%20SharePoint%20list%2C%20for%20example%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHead%20Office%20(List%20Owners)%3C%2FP%3E%3CP%3ELondon%20(View%20only)%3C%2FP%3E%3CP%3EMidlands%20(View%20only)%3C%2FP%3E%3CP%3ENorth%20(View%20only)%26nbsp%3B%3C%2FP%3E%3CP%3ESouth%20(View%20only)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThey%20have%20a%20list%20with%20information%20which%20they%20want%20to%20limit%20the%20items%20viewable%20to%20users%20in%20London%20to%20only%20those%20with%20the%20value%20London%20in%20the%20location%20column%2C%20Midlands%20to%20Midlands%2C%20North%20to%20North%20etc%20and%20Head%20office%20all%20items.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20achieve%20this%20OFTB%20with%20SharePoint%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20with%20this%20would%20be%20most%20appreciated.%3C%2FP%3E%3CP%3EBen%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2077064%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPermissions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2077522%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20view%20depending%20on%20user%20group%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2077522%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F935410%22%20target%3D%22_blank%22%3E%40BenCrowe%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can't%20filter%20the%20list%20view%20based%20on%20user%20permissions.%20If%20user%20have%20read%20permissions%20on%20all%20items%20in%20list%20then%20they%20will%20be%20able%20to%20see%20all%20items.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20want%20to%20hide%20the%20items%20from%20other%20users%20then%20you%20can%20create%26nbsp%3B%3CSTRONG%3Eitem%20level%20permissions%20%3C%2FSTRONG%3Eand%20assign%20only%20those%20permissions%20which%20are%20required%20based%20on%20location.%20This%20way%20users%20can%20only%20see%20the%20items%20on%20which%20they%20have%20permissions.%20No%20need%20to%20use%20any%20view%20filtering%20in%20this%20case.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EReference%3C%2FSTRONG%3E%3A%26nbsp%3B%3CA%20title%3D%22How%20to%20enable%20Item%20Level%20Permissions%20in%20SharePoint%22%20href%3D%22https%3A%2F%2Fsharepointmaven.com%2Fhow-to-enable-item-level-permissions-in-sharepoint%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EHow%20to%20enable%20Item%20Level%20Permissions%20in%20SharePoint%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CHR%20%2F%3E%3CP%3EPlease%20click%20%3CSTRONG%3EMark%20as%20Best%20Response%3C%2FSTRONG%3E%20if%20my%20post%20helped%20you%20to%20solve%20your%20issue.%20This%20will%20help%20others%20to%20find%20the%20correct%20solution%20easily.%20It%20also%20closes%20the%20item.%20If%20the%20post%20was%20useful%20in%20other%20ways%2C%20please%20consider%20giving%20it%20%3CSTRONG%3ELike%3C%2FSTRONG%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2077616%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20view%20depending%20on%20user%20group%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2077616%22%20slang%3D%22en-US%22%3EUnfortunately%20SharePoint%20does%20not%20support%20permissions%20at%20the%20view%20level%2C%20so%20no%20way%20to%20my%20knowledge%20to%20achieve%20this%20with%20out%20of%20the%20box%20features%3C%2FLINGO-BODY%3E
Regular Visitor

I have a client who has asked if a SharePoint list could be filtered by a persons permissions group?

 

They have several locations which each have a user rights group to the SharePoint list, for example: 

 

Head Office (List Owners)

London (View only)

Midlands (View only)

North (View only) 

South (View only)

 

They have a list with information which they want to limit the items viewable to users in London to only those with the value London in the location column, Midlands to Midlands, North to North etc and Head office all items.

 

Is there a way to achieve this OFTB with SharePoint?

 

Any help with this would be most appreciated.

Ben

2 Replies
best response confirmed by BenCrowe (Regular Visitor)
Solution

@BenCrowe 

 

You can't filter the list view based on user permissions. If user have read permissions on all items in list then they will be able to see all items.

 

If you want to hide the items from other users then you can create item level permissions and assign only those permissions which are required based on location. This way users can only see the items on which they have permissions. No need to use any view filtering in this case.

 

ReferenceHow to enable Item Level Permissions in SharePoint 


Please click Mark as Best Response if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Unfortunately SharePoint does not support permissions at the view level, so no way to my knowledge to achieve this with out of the box features