Allowing managers access to list items

%3CLINGO-SUB%20id%3D%22lingo-sub-212909%22%20slang%3D%22en-US%22%3EAllowing%20managers%20access%20to%20list%20items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-212909%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20created%20a%20list%2Fform%20for%20managers%20to%20do%20evalulations%20of%20staff.%26nbsp%3B%20%26nbsp%3BWe%20also%20used%20Flow%20to%20create%20an%20approve%20process.%20Once%20the%20employee%20fills%20the%20form%20out%2C%20an%20approval%20gets%20sent%20to%20their%20manager%2C%20if%20the%20manager%20approves%20it%20goes%20the%20the%20VP%20of%20HR%2C%20and%20if%20the%20VP%20of%20HR%20approves%20it%20goes%20to%20the%20CEO.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPermissions%20are%20set%20up%20so%20staff%20can%20view%20their%20own%20items%2C%20and%20VP%20of%20HR%20and%20CEO%20are%20owners%20so%20they%20can%20see%20everything.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20I%20have%20is%20when%20the%20approval%20goes%20to%20the%20manager%2C%20they%20can't%20see%20the%20form%20(because%20of%20the%20view%20own%20items%20permission).%26nbsp%3B%20%26nbsp%3BNot%20a%20problem%20with%20VP%20and%20CEO%20obviously.%26nbsp%3B%20Is%20there%20a%20way%20for%20a%20manager%20to%20inherit%20permissions%20to%20view%20what%20was%20created%20by%20their%20staff%20member%20but%20now%20have%20access%20to%20everything%20via%20the%20Owner%20setting%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-212909%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Apps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESecurity%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-217424%22%20slang%3D%22en-US%22%3ERe%3A%20Allowing%20managers%20access%20to%20list%20items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-217424%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F162567%22%20target%3D%22_blank%22%3E%40Blain%20Harrison%3C%2FA%3E%2C%20did%20you%20ever%20manage%20to%20implement%20this%3F%20I've%20blogged%20exactly%20how%20I%20did%2C%20so%20if%20you%20need%20a%20step%20by%20step%20guide%2C%20hopefully%20this%20should%20help.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fmattwestonuk.wordpress.com%2F2018%2F07%2F20%2Fusing-microsoft-flow-to-secure-a-list-item-to-my-manager-and-i%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmattwestonuk.wordpress.com%2F2018%2F07%2F20%2Fusing-microsoft-flow-to-secure-a-list-item-to-my-manager-and-i%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-213512%22%20slang%3D%22en-US%22%3ERe%3A%20Allowing%20managers%20access%20to%20list%20items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-213512%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Blain%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20a%20plugin%20called%20Plumsail%20SP%20-%20Change%20SharePoint%20permissions%20which%20will%20do%20the%20job%20in%20a%20single%20step%2C%20but%20you'll%20need%20to%20put%20your%20hand%20in%20your%20pocket%20to%20buy%20the%20credits.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20preferred%20method%2C%20because%20I%20like%20doing%20it%20myself%2C%20is%20by%20following%20this%20blog%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fnoellawlor.wordpress.com%2F2018%2F01%2F18%2Fsetting-sharepoint-item-list-permissions-with-flow%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fnoellawlor.wordpress.com%2F2018%2F01%2F18%2Fsetting-sharepoint-item-list-permissions-with-flow%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20only%20difference%20that%20you%20should%20be%20aware%20of%20to%20make%20it%20match%20your%20scenario%20is%20that%20you%20can%20get%20the%20manager%20UPN%20by%20using%20the%20Office%20365%20Users%20-%20Get%20Manager%20(V2)%20action.%20I'm%20going%20to%20write%20up%20the%20example%20of%20giving%20your%20manager%20access%20as%20a%20blog%20and%20then%20I'll%20share%20that%20too.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20quite%20similar%20to%20what%20I've%20previously%20done%20with%20SPD.%20I'm%20working%20through%20this%20example%20as%20well%2C%20but%20let%20me%20know%20how%20you%20get%20on%20with%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-213397%22%20slang%3D%22en-US%22%3ERe%3A%20Allowing%20managers%20access%20to%20list%20items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-213397%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Matt%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20reply%2C%20any%20info%20you%20have%20or%20links%20would%20be%20great.%26nbsp%3B%20The%20manager%20is%20assigned%20on%20the%20account%20in%20AD%20and%20sync'ed%20to%20office%20365.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-212916%22%20slang%3D%22en-US%22%3ERe%3A%20Allowing%20managers%20access%20to%20list%20items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-212916%22%20slang%3D%22en-US%22%3E%3CP%3EWhilst%20I'm%20not%20a%20massive%20fan%20of%20list%20item%20permissions%2C%20you%20could%20use%20the%20SharePoint%20REST%20API%20to%20assign%20permissions%20to%20the%20list%20item.%20Depending%20on%20how%20you%20get%20the%20manager%2C%20you%20could%20either%20get%20the%20manager%20claims%20information%20from%20the%20list%20(if%20you're%20capturing%20that%20as%20a%20piece%20of%20metadata)%20or%20you%20could%20call%20Get%20Manager%20(v2)%20from%20the%20Office%20365%20Users%20connector.%20Once%20you've%20got%20the%20manager%20information%20you%20could%20make%20a%20REST%20call%20to%20SharePoint%20to%20assign%20the%20permission.%20I%20did%20something%20similar%20in%20SPD%20workflows%20a%20while%20ago%2C%20so%20the%20same%20thing%20could%20apply%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20can%20let%20me%20know%20where%20you%20get%20the%20manager%20info%20from%2C%20then%20I'll%20provide%20a%20fully%20worked%20example.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

We created a list/form for managers to do evalulations of staff.   We also used Flow to create an approve process. Once the employee fills the form out, an approval gets sent to their manager, if the manager approves it goes the the VP of HR, and if the VP of HR approves it goes to the CEO.

 

Permissions are set up so staff can view their own items, and VP of HR and CEO are owners so they can see everything.

 

The problem I have is when the approval goes to the manager, they can't see the form (because of the view own items permission).   Not a problem with VP and CEO obviously.  Is there a way for a manager to inherit permissions to view what was created by their staff member but now have access to everything via the Owner setting?

 

Thank you

4 Replies
Highlighted

Whilst I'm not a massive fan of list item permissions, you could use the SharePoint REST API to assign permissions to the list item. Depending on how you get the manager, you could either get the manager claims information from the list (if you're capturing that as a piece of metadata) or you could call Get Manager (v2) from the Office 365 Users connector. Once you've got the manager information you could make a REST call to SharePoint to assign the permission. I did something similar in SPD workflows a while ago, so the same thing could apply here.

 

If you can let me know where you get the manager info from, then I'll provide a fully worked example.

Highlighted

Hi Matt,

 

Thanks for your reply, any info you have or links would be great.  The manager is assigned on the account in AD and sync'ed to office 365.

 

Thanks!

Highlighted

Hi Blain

 

There is a plugin called Plumsail SP - Change SharePoint permissions which will do the job in a single step, but you'll need to put your hand in your pocket to buy the credits.

 

My preferred method, because I like doing it myself, is by following this blog: https://noellawlor.wordpress.com/2018/01/18/setting-sharepoint-item-list-permissions-with-flow/

 

The only difference that you should be aware of to make it match your scenario is that you can get the manager UPN by using the Office 365 Users - Get Manager (V2) action. I'm going to write up the example of giving your manager access as a blog and then I'll share that too.

 

This is quite similar to what I've previously done with SPD. I'm working through this example as well, but let me know how you get on with it.

Highlighted

Hi @Blain Harrison, did you ever manage to implement this? I've blogged exactly how I did, so if you need a step by step guide, hopefully this should help.

https://mattwestonuk.wordpress.com/2018/07/20/using-microsoft-flow-to-secure-a-list-item-to-my-manag...