How to set permissions on sheets based on the scenario?

%3CLINGO-SUB%20id%3D%22lingo-sub-2293303%22%20slang%3D%22en-US%22%3EHow%20to%20set%20permissions%20on%20sheets%20based%20on%20the%20scenario%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2293303%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20scenario%2C%20where%20I%20made%20multiple%20lists%20in%20SPO.%26nbsp%3BIn%20AAD%2C%20I%20created%20three%20groups%20of%20users%20to%20whom%20I%20need%20to%20assign%20permissions%20to%20use%20sheets.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThe%20first%20group%20of%20users%20(%3CSTRONG%3EEmployees%3C%2FSTRONG%3E)%20should%20have%20permissions%3A%3CBR%20%2F%3EHe%20only%20sees%20his%20list%20items.%20He%20can%20only%20edit%20his%20items.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThe%20second%20group%20of%20users%20(%3CSTRONG%3EManagers%3C%2FSTRONG%3E)%20should%20have%20the%20following%20permissions%3A%3CBR%20%2F%3EThey%20should%20see%20all%20the%20items%20in%20the%20list.%20But%20they%20can%20only%20edit%20their%20own.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThe%20third%20user%20group%20(%3CSTRONG%3EAdmin%3C%2FSTRONG%3E)%20should%20have%20permissions%3A%3CBR%20%2F%3EThey%20should%20see%20everything%20(all%20items)%20and%20can%20edit%20all%20items.%3CBR%20%2F%3EIdeally%2C%20Admins%20could%20not%20modify%20the%20list%20structure.%20Thus%2C%20they%20are%20not%201%20to%201%20with%20a%20predefined%20group%20(Site%20Owners).%3C%2FP%3E%3CP%3E%3CBR%20%2F%3ECan%20anyone%20advise%20me%20how%20to%20set%20permissions%20based%20on%20how%20I%20wrote%20the%20script%20above%3F%3C%2FP%3E%3CP%3EThank%20you%20very%20much%20for%20any%20advice%20that%20would%20move%20me%20to%20the%20goal.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2293303%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hello, 

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