cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
johnjohn123
Post Prodigy
Post Prodigy

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
Community Champion
Community Champion

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
Post Prodigy
Post Prodigy

@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
Community Champion
Community Champion

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

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