Restrict SharePoint List Items by Location Column
Question details
The user needs to restrict which SharePoint list items people can access based on a Location value.

- Product
- Microsoft SharePoint Lists
- Device & OS
- not provided
- Scenario
- Users in different locations should access only the items relevant to their location, such as India, the United Kingdom, or the United States.
- Observed behavior
- Each location's users should be able to access only the corresponding items.
Identify the locations, the users or groups that need access to each one, and any existing access that should remain. You need permission to create lists and manage their permissions.
Create a Separate SharePoint List for Each Location
Use separate lists with unique permissions when users must not be able to access items belonging to other locations.
A view filtered by the Location column is useful for displaying relevant items, but it is not a security boundary. Users who have permission to the underlying items may be able to access them through another view or method.
In SharePoint or Microsoft Lists, select New list and create a list for each location. If available, choose From existing list to copy the original list's structure, then check that the required columns and settings are present.
Add or transfer each item to the list matching its Location value. Check the destination lists to make sure items and any required attachments or other data are present.
Open a location list and go to Settings > List settings > Permissions for this list. Select Stop Inheriting Permissions and confirm.
On the list permissions page, remove groups or users who should not access that location, then select Grant Permissions to add the appropriate location group with the required permission level. Repeat for each list, while retaining necessary administrator access.
Sign in or test with accounts from different location groups. Open each list and verify that users can access their own location's items but not the other lists; also review access to the original list.

Work With Location Data in WPS Office
WPS Office is a free, lightweight alternative for working with office files. Its familiar interface and Microsoft Office format compatibility make it easy to move between applications. SharePoint list permissions must still be managed in SharePoint.

Frequently Asked Questions
Can a filtered SharePoint view prevent users from seeing other locations?
No. A view filters what is displayed, but it does not change permissions on the underlying items. Use permissions, such as unique permissions on separate lists, to restrict access.
Where do I set unique permissions for a SharePoint list?
Open the list and go to Settings > List settings > Permissions for this list. Select Stop Inheriting Permissions, then review and change the users and groups on the permissions page.
Does stopping permission inheritance remove existing users?
No. SharePoint copies the inherited permissions to the list when you stop inheritance. Remove any users or groups that should no longer have access and grant access to the appropriate location group.
What should I do with the original combined list?
After transferring and checking the items, review the original list's permissions and sharing links so it does not continue to expose data to users who should no longer have access.




