Unanswered

Gather employee emails from list of employee ID number

(0) Share

Report

Posted on by davinelm

My goal is to convert a list of employee ID numbers to their email addresses. I think I have all the pieces needed to make it happen but I'm unsure how to connect them all together. If it isn't obvious I'm a power automate noob so please bear with me.

Here what I got so far,
A .xlsx file on a teams page,
The excel sheet has table with several columns but Column2 is where i have a list of employee IDs.

Im at a loss as to what the next step should be to grab all of those IDs and return their corresponding emails.
Ive been able to take one ID at a time and get their user info which includes an email by following this guide:

https://powerusers.microsoft.com/t5/General-Power-Automate/How-to-get-Employee-ID-from-AD/td-p/373437

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-yujincui-msft on at

Like (1)

Report

Hi @davinelm ,

Do you want to get the corresponding email address based on all employee IDs in excel table?
I have made a test for your reference.

1. Here is my excel table.
2. Here is my Flow.

Result Screenshot:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
Riyaz_riz11 3,844 Super User 2025 Season 2 on at

Like (2)

Report

Hi @davinelm ,

For getting Details from excel, you need to go for List rows present in the table.

After you can add the next conditions.

Regards

Ahammad Riyaz

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
EmilioRoqueta69 565 on at

Like (0)

Report

Hi, I cannot find the Get User function that you are using in the solution, which is it?
Thanks in advance.

Was this reply helpful? Yes No