Permission & Access Issues

How to Prepopulate SharePoint List Items with Restricted User Access

Aamir Naveed Akram Oct 13, 2026 868 views

Question details

The user needs a way to allow specific sellers to view and edit deals prepopulated by an administrator in SharePoint without giving them access to view other sellers' records.

How to Prepopulate SharePoint List Items with Restricted User Access

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Administrators prepopulate deal records for sellers in a SharePoint list, requiring strict visibility rules so each seller only sees their assigned deals.
Observed behavior: Default SharePoint item-level settings prevent sellers from viewing admin-created deals if the list is restricted to only allow users to read items they created themselves.

Before you start

Ensure you have Site Owner or Full Control permissions in your SharePoint site and have access to Microsoft Power Automate to configure custom workflow automations.

Solution 1Recommended

Automate Item-Level Permissions with Power Automate

Use a Power Automate flow to break permission inheritance and assign specific seller access automatically when an administrator creates a record.

While SharePoint allows users to read or edit only the items they created, admin-prepopulated items are technically owned by the administrator. Power Automate solves this limitation by automatically updating permissions on a per-item basis based on an 'Assigned To' column.

Create a new automated flow

Open Microsoft Power Automate, click on 'Create', and select 'Automated cloud flow'. Choose the trigger 'When an item is created' for SharePoint.

Configure the site and list

Select your SharePoint Site Address and the specific List Name where administrators prepopulate the deal items.

Stop sharing the item

Add a new action and search for 'Stop sharing an item or a file'. Select your Site Address, List Name, and use dynamic content to insert the Item ID. This removes the default inherited permissions.

Grant access to the assigned seller

Add another action called 'Grant access to an item or a folder'. Input the Site, List, and Item ID. In the 'Recipients' field, insert the dynamic content for the 'Assigned To Email' column, and set their role to 'Can edit'.

Automate Item-Level Permissions with Power Automate

Scalability: This automated method easily scales as your team grows, ensuring permissions are applied instantly and accurately without manual administrator intervention.

Solution 2

Manually Apply Permissions to Individual SharePoint Items

For small-scale operations or one-off records, administrators can manually grant individual sellers access to specific list items.

Free Microsoft Office alternative

Try WPS Office for Seamless Document Management

While complex list permission configurations require Microsoft SharePoint and Power Automate, WPS Office provides a free, lightweight, and highly compatible alternative for creating, editing, and managing your daily office documents offline and in the cloud.

1. Download the installer: Visit the official WPS Office website and click the free download button for your specific operating system.
2. Install and launch: Run the downloaded installation file and follow the straightforward on-screen instructions to set up WPS Office on your device.
3. Open your documents: Launch WPS Office and instantly open, edit, and save your existing Microsoft Office files without losing any formatting.

Fully compatible with Microsoft Word, Excel, and PowerPoint file formatsLightweight application that runs smoothly on Windows, Mac, Linux, and mobile devicesBuilt-in cloud storage for easy document sharing and team collaborationFamiliar user interface with zero learning curve for seamless migration

microsoft office alternative - wps office

Frequently Asked Questions

Can I use default SharePoint list settings to hide items from other users?

Yes, by navigating to List Settings > Advanced Settings, you can set 'Item-level Permissions' to 'Read items that were created by the user'. However, this prevents sellers from seeing items prepopulated by administrators, as the administrator is the creator.

Why are my sellers unable to see the deals I assigned to them?

If your SharePoint list is configured to only show items created by the active user, any items created by an administrator will automatically be hidden from sellers. You must grant explicit item-level permissions to the assigned seller using Power Automate or manual sharing.

Are there limits to unique item-level permissions in a SharePoint list?

Yes, SharePoint lists have a supported limit of 50,000 unique item-level permissions, though performance degradation can occur well before that. For extremely large lists, using Power Apps to filter views based on the logged-in user is a more scalable approach than breaking permission inheritance.

Document & File Issues