Power Apps check User is Manager & get Direct Reports (Role Based Apps)

In this video on Power Apps Office 365 User is Manager & Direct Reports (Role Based Security & Access Control chapter 2), we will explore how to show hide buttons, controls or screens based on the logged in user's roles / security permissions.

PowerApps Role Based Security video covers the following scenarios:
✅ Check if logged in User is a Manager in Active Directory using Office365Users connector
✅ Get Direct Reports of user using the Office 365 Users connector
✅ Query SharePoint list to get data for direct reports

Table of Contents:
00:00 - Intro
00:46 - Travel Request App scenario (SharePoint list)
01:38 - Get direct reports of user in PowerApps using Office365Users connection
03:22 - Get user profile image using Office365Users connector
05:47 - Show hide controls if user is a manager using Office 365 Users connector
08:42 - Show data based on direct reports of logged in user in Power Apps
12:52 - Subscribe to Reza Dorrani channel

#PowerApps #Office365 #Office365Users #SharePoint #RoleBasedApps

[MrAloha]

I like it, thanks! Really clear, and easy to understand steps.

[LisaSach]

You have saved my life countless times. Thank you for you content :)

[minstreltokunbo]

I screamed when I found this video! Thank you!

[MosesStephen-bp]

Once again Chef Reza Dorrani has made my day...😊😁 Excellent video as always. Thank you

[ricardoromo]

AWESOME JOB! Spent a lot of time trying to figure this out but this helped a lot!

If I wanted to see all requests for all the direct reports at once, not just the once select (to avoid clicking on each of the 15-ish direct reports I have), how would I got about that? I tried doing AllItems instead of Selected but that did not work. Thanks!

[anthonyanyoti]

Thanks alot Reza, really helpful as always, was having trouble figuring this out.

[wasif]

Thanks, Reza! This is very helpful! I wanted to filter & display data for all direct reports without selecting them. I want to show a table of all direct reports in a single view without selecting them 1 by 1

[danielzajac]

Dear Reza,

Great material, great JOB!!!
I have a question how resolve problem with transfer of responsibility (longer vacation) how setup takeover direct reports from to someone other ?

[avskadoo]

This is very awesome, Thanks a million... Loving it!! Thanks for being savvier for me 😇
Small query...
In this view org hierarchy you mentioned is at top Raza is there. Then Sarah reports to Raza. And Rahul Reports to Sarah.
So Raza can view data for Sarah. And Sarah can view data for Rahul.
But being as a senior manager Raza may be interested to view data for Rahul.

In other words CEO may wants to see full organization data and not only for direct reports. could you suggest how to achieve this functionality ?

[wadly]

Very Valuable, loved. it! how do you get around the issue of everyone needing to have access to the SP list to create items, but perhaps not wanting the end users with no direct reports being able to see it, find it use it in that form? This is a challenge I keep running in to particularly with things that need roll based apps!

[himanshusharma]

Hi Reza,

I love watching your powerapp videos.


Thank you for your great work and sharing.

I would like to ask you one question.

How can we get the list of all the subordinates i.e. the direct reports of direct reports in powerapps teams gallery?

[DidiKashemwa]

Hi Reza, this is amazing, I'm wondering if you can or do have a video that checks if the user is logged in as a manager or a user on the logging screen. (I'm talking with regards to the leave management system template that has two different logins for the users). Thank you so much for your videos.

[amritatalreja]

Thanks Reza! This is very helpful ! I wanted to check if we can filter display data for all direct reports without selecting . I want to show a table of all direct reports and sone value from SPlist in single view without selecting them 1 by 1. Is there sone other function we can use to achieve this?

[SirajAhmad-uogr]

Hi Reza,
my question is not relevant to this vedio but i have an issue, need your guidance.
our company has 3 attributes that needs to be added in office365 user profile and should be filled whenever create new user.
i am using office365 connector to retrieve user info from office365.but i havenot found any solution that help me to add attribute(properties) in office365 user profile.
please guide

[carinaslim]

Hi Reza, Thanks for this. I am trying this but am successful showing the selected person's data in my Sharepoint list. The difference with my Sharepoint list is that I can't use Created by since the list is created by a group and not the "selected" person. I was trying to filter based on the Display name but i don't think I'm doing this right. any suggestions on what I should check? The scenario is after selecting from the DirectReports gallery, I want to search for that person in my sharepoint list and show that record, but their record is created by a team and not the selected person. Thanks!

[vidanaweer]

Hi Reza,
Thanks for another valuable video. I have a requirement to have a staff directory in a sharepoint online page where staff can search contacts details. I m thinking to have a powerapp for this. Do you have a video for this. Thanks .

[pietervelkeneers]

Hi, I do get the idea of how to filter a gallery, based on the direct reports (thank you for this very clear explanation by the way). But with regards to the source list in Sharepoint, how can you avoid the 'manager' has access to the complete list instead of only the records from his direct reports, when this 'manager' is accessing the list in Sharepoint directly. I'd expect he would need read access to the complete list to be able to filter out the data in the Power App (which would breach the role base security).

[divyanshusoni]

Hi Reza,
What if we want to manage user profiles in an excel in onedrive?
How we will validate users thru excel data?
How can we change User() function to take values from excel data?

[rsxtypeo]

Is there a way to include the user that is opening the form in the Items as well ?

[christopherlove]

Hi Reza, is there a way of searching a distinct list of managers to retrieve Manager names only within Office365Users ? and Filter by Company ?