Permission & Access Issues

Restrict SharePoint List Items by Location Column

Kushani NimanthikaKushani Nimanthika Nov 14, 2026 868 views

Question details

The user needs to restrict which SharePoint list items people can access based on a Location value.

How to Restrict SharePoint List Items by Location
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.
Before you start

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.

Solution 1Recommended

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.

1
Create matching lists

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.

2
Place items in the correct lists

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.

3
Stop inheriting permissions

Open a location list and go to Settings > List settings > Permissions for this list. Select Stop Inheriting Permissions and confirm.

4
Assign location access

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.

5
Test 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.

Create a Separate SharePoint List for Each Location
Review existing access: Stopping inheritance copies the current permissions to the list; it does not automatically remove them. Review group membership, sharing links, and administrative access as part of testing.
Free Microsoft Office alternative

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.

Organize and filter location data in WPS SpreadsheetsOpen and edit Microsoft Excel XLSX filesUse a familiar interface for everyday office workWork with compatible files when moving between office applications
QA img-9

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.