Managing Large SharePoint List: Restricting Viewing Permissions by Department

Copper Contributor

How can I set up item-level permissions in a large SharePoint list to restrict access so that, for example, IT managers can view and edit only IT-related items, and have no read or edit access to items from other departments like HR, Culture, Parking, or Finance?

1 Reply

Hello @HamidBee 


how large is a larg list for you? Here are more about limits and boundaries in SharePoint :


You can use Power Automate for item level permissions:


Or split every department in their own list, so you can set permission on list level.


Best, Dave