How to Share Multiple Items in Microsoft Lists Without Sharing the Entire List
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.

- 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 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.
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.
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'.
Return to your list view, click the 'New' dropdown menu at the top, and select 'Folder'. Give your folder a descriptive name.
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.
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'.

Automate Access with Power Automate
For lists that must remain strictly folder-free, use Power Automate to dynamically grant access to multiple items based on specific column values.
Adjust Permissions for Individual Items
If you only have a few items to share, managing unique permissions per item is a reliable, though manual, approach.
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.

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.




