Permission & Access Issues

How to Share Multiple Items in Microsoft Lists Without Sharing the Entire List

Muhammad TalhaMuhammad Talha Nov 2, 2026 870 views

Question details

The user wants to share multiple specific rows (items) in a Microsoft List with certain users without giving them access to the rest of the list.

How to Share Multiple Items in Microsoft Lists Without Sharing the Entire List
Product
Microsoft Lists
Device & OS
not provided
Scenario
Sharing selected data within a collaborative team tracking environment without exposing the entire list.
Observed behavior
Microsoft Lists requires sharing items individually or sharing the entire list, lacking a native batch-sharing feature for selected rows under a single permission set.
Before you start

Before modifying permissions in Microsoft Lists, ensure you have 'Full Control' or 'Design' access to the list. Modifying item-level permissions or creating folders can temporarily affect how data is displayed for other collaborators.

Solution 1Recommended

Use Folders to Group and Share Specific Items

The most straightforward workaround is to create a folder, move the target items into it, and share the folder with the intended users.

By placing multiple items into a single folder, you can manage permissions at the folder level. This allows you to share the folder once, and the recipients will instantly gain access to all the items inside it without seeing the rest of the list.

1
Enable folder creation

Go to your Microsoft List, click the 'Settings' gear icon, select 'List settings', click 'Advanced settings', and ensure 'Make New Folder command available' is set to 'Yes'.

2
Create a new folder

Return to your list view, click the 'New' dropdown menu at the top, and select 'Folder'. Give your folder a descriptive name.

3
Move items into the folder

Select the items you want to share, and drag and drop them into the newly created folder. Alternatively, edit the item properties to update their path.

4
Share the folder

Hover over the folder, click the 'Share' icon (or the ellipsis and select 'Manage access'), enter the email addresses of the intended recipients, adjust their editing permissions, and click 'Send'.

Use Folders to Group and Share Specific Items
Maintain a Flat List View: If you prefer not to see folders while navigating your list, you can modify your view settings. Go to 'Edit current view', scroll down to the 'Folders' section, and select 'Show all items without folders'.
Free Microsoft Office alternative

Collaborate on Data Securely with WPS Office

If managing complex item-level permissions in Microsoft Lists is too cumbersome, consider using WPS Spreadsheet. WPS Office is a lightweight, free alternative to Microsoft Office that offers robust spreadsheet collaboration, high compatibility with Excel formats, and easy-to-use worksheet protection features.

Seamless compatibility with Microsoft Excel (.xlsx, .xls) formats.Easily protect specific sheets or cell ranges to control what collaborators can edit.Familiar user interface requiring no steep learning curve.Lightweight installation and free to use for daily data tracking tasks.
microsoft office alternative - wps office

Frequently Asked Questions

Can I group Microsoft List items by a manager column to automatically grant access?

No, simply grouping items by a 'Manager' column does not automatically restrict or grant access based on the email address in that column. You must use a Power Automate flow to read that column and dynamically assign item-level permissions.

How do I remove a shared folder and return items to the main list?

To remove the folder, you must manually select the items inside it and move them back to the root directory of the list. Once the items are moved out, you can delete the empty folder. Note that items will revert to the default list permissions unless you manually configure unique permissions for them before moving.

Why does Microsoft Lists only let me share the entire list or one item at a time?

Microsoft Lists inherits its permission architecture from SharePoint. By default, items inherit permissions from the parent list to keep performance optimal. Breaking inheritance to share items selectively is done on a per-item or per-folder basis to prevent overly complex and unmanageable permission structures.