How to set permissions on sheets based on the scenario?

Occasional Contributor


I have scenario, where I made multiple lists in SPO. In AAD, I created three groups of users to whom I need to assign permissions to use sheets.

The first group of users (Employees) should have permissions:
He only sees his list items. He can only edit his items.

The second group of users (Managers) should have the following permissions:
They should see all the items in the list. But they can only edit their own.

The third user group (Admin) should have permissions:
They should see everything (all items) and can edit all items.
Ideally, Admins could not modify the list structure. Thus, they are not 1 to 1 with a predefined group (Site Owners).

Can anyone advise me how to set permissions based on how I wrote the script above?

Thank you very much for any advice that would move me to the goal.

0 Replies