Forum Discussion

Copper Contributor

May 05, 2022

Is it possible to create List View for Current Manager in SharePoint

Hi, Is it possible to create a list view that only the assigned user can see and also their manager can see? for example: Does anyone know who to do this? Regards, Henry

SharePoint Online

DaveMehr365

MVP

May 05, 2022

Hello Dynamicshs

manager is an dynamic value, that's not possible in a list view. But i think you have two other solutions to proof for that:

1. Power Automate Flow set permisson

- Set the permissions on list items with a flow. On change or save you can set permission for the user and the manager. only people with access see the items.

2. Search

- With PnP Modern Search WebParts you can build queries with dynamic user profile information. Maybe you can build a query around the user and manager.

Only 2 ideas, but both are not proofed.

Regards, Dave

Dynamicshs
Copper Contributor
May 06, 2022
Hi DaveMehr365,

Thanks for the reply.

I'm a little confused on how I would set this up on power automate?

Thanks,
HS
- DaveMehr365
  MVP
  May 06, 2022
  Hello Dynamicshs
  
  oh sorry i'm not a power automate specialist. Here is en example, how you can set permissions:
  https://steveknutson.blog/2021/12/10/setting-sharepoint-permissions-with-power-automate/#:~:text=Power%20Automate%20can%20be%20used,that%20triggers%20on%20item%20creation.
  
  And here an example, how you get the manager from a user:
  https://powerusers.microsoft.com/t5/Building-Flows/Get-manager-V2/td-p/185565
  
  Regards, Dave