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

 

 

 

 


Thanks,
Stalin

Learn To Illuminate

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

 

 

 

 


Thanks,
Stalin

Learn To Illuminate

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (801)