cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
_sourcecod3_
Level: Powered On

How to get Employee ID from AD.

Hi,

 

I'm working on a leave request workflow and I'd like to be able to pull the employee's ID. This data comes from AD. I looked in the "Get user profile" but there isn't an option to get the employee ID. 

 

Any ideas? 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: How to get Employee ID from AD.

Hi @_sourcecod3_ 

 

It's easy 😄

 

Just use the Azure AD (Get User) passing the user email.

image.png

 

 

It's brings the ID as the first fieldimage.png

 

Hope this helps


Did I answer your question? Mark my post as a solution!

Gustavo Moraes, o astronauta brasileiro do Flow!


View solution in original post

7 REPLIES 7
Dual Super User
Dual Super User

Re: How to get Employee ID from AD.

Hi @_sourcecod3_ 

 

Get user profile only fetches basic list of properties

Any custom properties(extension attributes) - graph api will be the option

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

_sourcecod3_
Level: Powered On

Re: How to get Employee ID from AD.

@RezaDorraniThanks for your response. Do you happen to have any resources where i can find more information on that? 

Dual Super User
Dual Super User

Re: How to get Employee ID from AD.

@_sourcecod3_ 

 

https://powerusers.microsoft.com/t5/PowerApps-Ideas/Access-Azure-AD-Custom-Extension-Attributes-in-M...

check comments on this idea

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Highlighted
Super User
Super User

Re: How to get Employee ID from AD.

Hi @_sourcecod3_ 

 

It's easy 😄

 

Just use the Azure AD (Get User) passing the user email.

image.png

 

 

It's brings the ID as the first fieldimage.png

 

Hope this helps


Did I answer your question? Mark my post as a solution!

Gustavo Moraes, o astronauta brasileiro do Flow!


View solution in original post

Community Support Team
Community Support Team

Re: How to get Employee ID from AD.

Hi @_sourcecod3_,

 

Has your problem been solved?
If your problem has been solved, You could go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best Regards,
Community Support Team _ Lin Tu

_sourcecod3_
Level: Powered On

Re: How to get Employee ID from AD.

@gamoraesThanks and I apologize for the late response. What other attributes will this provide? 

 

Thanks

Super User
Super User

Re: How to get Employee ID from AD.

Hi

 

The return have:

 

Id
id string

A unique identifer for the user.

Business Phones
businessPhones array of string  
Display Name
displayName string

The name displayed in the address book for the user.

Given Name
givenName string

The given name (first name) of the user.

Job Title
jobTitle string

The user’s job title.

Mail
mail string

The SMTP address for the user.

Mobile Phone
mobilePhone string

The primary cellular telephone number for the user.

Office Location
officeLocation string

The office location in the user's place of business.

Preferred Language
preferredLanguage string

The preferred language for the user. Should follow ISO 639-1 Code; for example 'en-US'.

Surname
surname string

The user's surname (family name or last name).

User Principal Name
userPrincipalName string

The user principal name (UPN) of the user.

 

 

 
     

 

The full documentation is here


Did I answer your question? Mark my post as a solution!

Gustavo Moraes, o astronauta brasileiro do Flow!


Helpful resources

Announcements
firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (10,776)