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

[johnjohn123]

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

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

[WarrenBelz]

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.

[johnjohn123]

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

any advice?

Thanks

[WarrenBelz]

@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]

@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..

[WarrenBelz]

@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 · Accepted solution]

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