web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Need help looping thro...

Power Automate

Suggested Answer

Need help looping through employee list to return manager

(1) Share

Report

Report

Posted on by ElvirBotic

41

Hello,

I have an excel list currently that I will be maintained monthly. In the file I have an employee ID lookup to return that users email address. I would like to be able to have Power Automate loop through for each record in the Excel file use the 'Get manager' connector in Power Automate to pass it the users email, retrieve who the manager is for the employee and then write the managers email in a new column. How would this be approached?

Best,

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Expiscornovus 33,947 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
You can use an array variable for this. You can use an append to array variable action within a apply to each loop and store both email addresses in that array.

Below is an example

The Excel table setup

The flow setup.

The append to array variable uses the below value

{ "Employee": "@{items('Apply_to_each')?['EmailAddress']}", "Manager": "@{outputs('Get_manager_(V2)')?['body/mail']}" }

The end result

Was this reply helpful? Yes No

Join the conversation