Answered

How to retrieve 'employeeId' attribute from MS flow?

(0) Share

Report

Posted on by Community Power Pla...

Dear Flow Gurus,

I am trying to pull out employeeId field but as shown below, there is no "Employee Id" field available.

According to the documentation, here and here, it seems like 'employeeId' should be able to pickup from "Office 365 Users" service.

I have no luck and stuck on it for few days. Hopefully can get some input from the advanced users here.

Thank you.

Categories:

Building flows

I have the same question (2)

All responses (5)

Answers (1)

Verified answer

v-litu-msft on at

Like (0)

Report

Hi @Anonymous,

Please refer to this post and this Idea:

Get Employee ID from AD

https://powerusers.microsoft.com/t5/General-Flow-Discussion/How-to-get-Employee-ID-from-AD/m-p/373437

Idea - Access Azure AD Custom Extension Attributes in MS Flow

https://powerusers.microsoft.com/t5/PowerApps-Ideas/Access-Azure-AD-Custom-Extension-Attributes-in-MS-Flow/idi-p/107087

Hope something help.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I think i have to accept this as solution but i can never apply it.
https://powerusers.microsoft.com/t5/PowerApps-Ideas/Access-Azure-AD-Custom-Extension-Attributes-in-MS-Flow/idc-p/187791#M7268

Invoke HTTP request is a premium tier and i can't call it in my production environment. 😞
So it's a dead end for me.

Was this reply helpful? Yes No
blink 14 on at

Like (6)

Report

I was looking for the same thing as you were and also got stopped by HTTP being a premium feature. I have a working alternative solution using the built in graph feature of get user profile. Hopefully this helps future users searching for this issue.

In my case I'm going to update an new SharePoint list item on creation to add the employee number as a separate column. here is the basic flow:

Initialize variable can be replaced with anything else as after parse JSON we will have the employee id

Get User Profile (V2) -> Show advanced options and put "employeeid" in select fields. "employeeid" is the field name for the azure employee id.

Parse JSON -> In content use dynamic content "User from Graph API". "User from Graph API" was generated in the last step by adding "employeeID" in the advanced options "Select Field".
Add the following to "Schema" to turn our Graph API into dynamic content.
{
    "type": "object",
    "properties": {
        "ODdata": {
            "type": "string"
        },
        "EmployeeID": {
            "type": "string"
        }
    }
}

You will now have "EmployeeID" as dynamic Content and you can use where needed.

1 people found this reply helpful.

Was this reply helpful? Yes No
grandtotal 31 on at

Like (0)

Report

Nice solution, thanks!

Was this reply helpful? Yes No
esjimenezp 485 on at

Like (0)

Report

Works, thanks @blink

Was this reply helpful? Yes No