SharePoint List view depending on user group

[BenCrowe]

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 · Accepted 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.

Reference: How 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.

[#3]

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

[#4]

@BenCrowe 

That is very easy to achieve. You already have the locations information in some column. 

So, what you can do is that you can

1: Go to list settings.

2: Scroll down and click on create new view. You will create separate view for each of your location.

3: Then in every view you have to mention the filter. In filter you will choose Location in the column and in the value, you will write the appropriate value like London, USA etc. 

4: Then you can give separate view link to your clients based in the separate locations. 

[#5]

@ganeshsanap not sure if this would be a best option if we can assume that list will exceed 5000 items which is recommended limit for item based access rights.

[#6]

What if one location people have a URL of another location view.
for example if people from London have a URL of the view for USA.

[#7]

@Yogendra_Singh In that case, people from London will be able to see the USA list items using the URL of the view for USA if you haven't broke permissions at list item level.

Also, users can change the view from list itself, without needing the direct URL to list view: 

---

Please consider giving a Like if my post helped you in any way.