cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
johnjohn123
Super User
Super User

Can we get Active Directory property named Employee ID using Office365Users connector

Inside our active directory we have a property named "Employee ID" as follow:-

 

employee id.png

 

 

so inside our PowerApp form i want to get the value of this property,,, but i checked the Office365Users connector  @ https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-office365-users seems it does not provide such a data.. so how i can get the Employee ID property inside our PowerApp form?

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
StalinPonnusamy
Super User
Super User

Hi @johnjohn123

 

The employee ID that you are looking for does not exist in the Office365 connector. We have to use Microsoft Graph which is we need to have/write our own custom connector.

 

Microsoft Graph Explorer

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

 

StalinPonnusamy_1-1631981507104.png

StalinPonnusamy_2-1631981548569.png

 

 

 

 

View solution in original post

6 REPLIES 6
WarrenBelz
Super User
Super User

Hi @johnjohn123 ,

The syntax would be

First(Office365Users.SearchUser({searchTerm:"YourUserEmailHere"})).EmployeeID

if this field was available and the name is as above. 

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

@WarrenBelz  i tried your formula, but i got this error "Name is not valid"

 

johnjohn123_0-1631924635485.png

 

 

any advice?

Thanks

@johnjohn123 ,

As I said, this has to be the name (I guessed it based on your post) and it needs to be available. I do not have this field in my company's AD, so you need to find out what it is called in yours.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

johnjohn123
Super User
Super User

@WarrenBelz  it is named Employee ID.. but seems the

First(Office365Users.SearchUser({searchTerm:"YourUserEmailHere"}))

will not allow us to get custom properties,, seems there are predefined properties that we can only get..

@johnjohn123 ,

That is the search syntax in the connector, so I guess they are not available in Power Apps.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

StalinPonnusamy
Super User
Super User

Hi @johnjohn123

 

The employee ID that you are looking for does not exist in the Office365 connector. We have to use Microsoft Graph which is we need to have/write our own custom connector.

 

Microsoft Graph Explorer

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

 

StalinPonnusamy_1-1631981507104.png

StalinPonnusamy_2-1631981548569.png

 

 

 

 

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (2,187)