How to get the current employee HireDate from AD?

(0) Share

Report

Posted on by EmilioRoqueta69

521

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!

All responses (5)

Answers (0)

VictorIvanidze 12,536 on at

Like (1)

Report
Re: How to get the current employee HireDate from AD?

The GRAPH request
https://graph.microsoft.com/beta/users/{userID}
returns
... "employeeHireDate": null, ...
Tjan 1,087 Super User 2025 Season 1 on at

Like (1)

Report

Re: How to get the current employee HireDate from AD?

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.
EmilioRoqueta69 521 on at

Like (0)

Report

Re: How to get the current employee HireDate from AD?

Ok, and how can I get this value in power automate?
Mister_Shaik 1,006 on at

Like (1)

Report

Re: How to get the current employee HireDate from AD?

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
Tjan 1,087 Super User 2025 Season 1 on at

Like (1)

Report

Re: How to get the current employee HireDate from AD?

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.