How to get the current employee HireDate from AD?

(0) Share

Report

Posted on by EmilioRoqueta69

565

Hi there,

I tested this formula in PowerApsp, but the result is wrong 1/1/1...

Office365Users.UserProfileV2(User().Email).hireDate

How can I connect with the employee AD data using the email or something?

Thanks for any help!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

CU05111601-0 1,091 Super User 2024 Season 2 on at

Like (1)

Report

Hi @EmilioRoqueta69 I think there's nothing wrong with your formula! It might be because the hireDate was never logged when the user was created in Entra. You can check this via the Azure portal > Microsoft Entra ID > Users > Add column 'Employee Hire date'. When doing this you can exactly check whether there is a correct hire date logged.

I also checked on my side and all the values were blank. Therefore PowerApps always provide me with 1/1/1 when using the .hireDate.

Was this reply helpful? Yes No
Mister_Shaik 1,008 on at

Like (1)

Report

Hi @EmilioRoqueta69 ,

Assuming that the employees are not contractors who are not hired after working for some time with the company, the "Created date time" might serve the same meaning as Hire date.

Unless specifically synced by the respective HR systems, I don't believe the Azure Entra/AD would contain any info for Hire date.

Hope this helps!

Kind Regards,
Shaik Sha

Was this reply helpful? Yes No
EmilioRoqueta69 565 on at

Like (0)

Report

Ok, and how can I get this value in power automate?

Was this reply helpful? Yes No
CU05111601-0 1,091 Super User 2024 Season 2 on at

Like (1)

Report

Do you mean Power Automate or PowerApps? Since you mentioned a PowerApps formula in your initial post. I know in PowerApps, there's is no such attribute for Created date (Office365Users.UserProfileV2(User().Email).Created) doesn't exist.

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (1)

Report
The GRAPH request
https://graph.microsoft.com/beta/users/{userID}
returns
... "employeeHireDate": null, ...

Was this reply helpful? Yes No