Graph API or Kusto

[Vishal1]

HI All,

Does anyone has created or called MS GRAPH API via PowerApps, I would like to retrieve user alias, email address, display name, Manager, Skip level, etc.

[StalinPonnusamy]

Hi @Vishal1 

PowerApps does not have a connector to Microsoft Graph, so we need to create a custom connector to access Azure AD and calls that API to get AD details.

User Microsoft Graph explorer to test Graph API. Here are the few API Calls which help to create Custom Connector. 

https://developer.microsoft.com/en-us/graph/graph-explorer

To Get Current User Details

https://graph.microsoft.com/v1.0/me

Get Specific details about the current user

https://graph.microsoft.com/v1.0/me?$select=displayName,employeeid,userPrincipalName,mail

To Get manager 

https://graph.microsoft.com/v1.0/me/manager

Get User by Employee ID

https://graph.microsoft.com/v1.0/users?$select=displayName,employeeid,userPrincipalName&$filter=employeeId eq 'sp0108'

I found this blog has details above the custom connector for Graph API.

Thanks,
Stalin - Learn To Illuminate

[Vishal1]

Thanks Stalin, I am aware of custom connector, I wonder if someone has already implemented the same and what is the best way to combine into a single query for user alias, email address, display name, Manager, Skip level

[StalinPonnusamy]

Hi @Vishal1 

We can combine the attributes like below

https://graph.microsoft.com/v1.0/me?$expand=manager($levels=1;$select=displayName,employeeid,userPrincipalName,mail,mailNickname)&$select=displayName,employeeid,userPrincipalName,mail,mailNickname&$count=true

Not sure about skip level.

Thanks,
Stalin - Learn To Illuminate

[Vishal1]

Stalin, thank you, can you try to get me employee status as well and skip level is nothing but my manager boss info.

[StalinPonnusamy]

Hi @Vishal1 

We can get employees account status

https://graph.microsoft.com/v1.0/me?$expand=manager($levels=1;$select=displayName,employeeid,userPrincipalName,mail,mailNickname,AccountEnabled)&$select=displayName,employeeid,userPrincipalName,mail,mailNickname,AccountEnabled&$count=true

 
Thanks,
Stalin - Learn To Illuminate

[Vishal1]

Thank you again, I see you have added account enabled? i wonder if we have column like employee status or employee active or not? and also, how to get manager next level (boss).

[StalinPonnusamy]

Hi @Vishal1 

Graph API V1.0 does not have status. Here is the to get manager hiereachy

https://graph.microsoft.com/v1.0/me?$expand=manager($levels=max;$select=id,displayName)&$select=displayName,employeeid,userPrincipalName,mail,mailNickname,AccountEnabled&$count=true

Bete version has more properties compared to V 1.0

https://graph.microsoft.com/beta/me

Thanks,
Stalin - Learn To Illuminate

[Vishal1]

the screenshot you have attached, looks like I don't have access to get manager hierarchy may be due to vendor? and not sure on the beta version. 

[StalinPonnusamy]

Hi @Vishal1 

https://docs.microsoft.com/en-us/graph/api/user-list-manager?view=graph-rest-1.0&tabs=http#code-try-...

The Beta version is not for production. MS exploring and can break anything and not guaranteed. For now, we can explore as POC and expect this in the future release.