Extracting email address from excel and adding new member in MS Teams

(1) Share

Report

Posted on by Mhaonaigh

Hello Everyone,

I am new to Power automate and would love some advice. I am trying to extract the emails from a column in an excel table and use the email addressed to add the members to MS teams.

I am using the following the moment

manually trigger flow
list rows present in a table
apply to each, set variable and I pick the email column
add a member to a team

The flow always crashes at point 3. Can any of you suggest what I am doing wrong or how you would set up this flow? Thanks

I have the same question (0)

All responses (1)

Answers (0)

creativeopinion 10,480 Super User 2025 Season 2 on at

Like (0)

Report

Re: Extracting email address from excel and adding new member in MS Teams

@Mhaonaigh You do not need to set a variable for your flow.

Select Email Addresses
Use a Select action to pull the email addresses from the email column in the Excel table. Click on the icon to switch from key value to map mode.

Insert the dynamic content for the email column into the Map field.

Run a test.

The Select action will pull the email addresses into an array.

Apply to Each Email Address
Add an Apply to Each action and insert the Outputs from the select action. This action will loop through each email address returned.

Add an Add a member to a team action. Select the appropriate team. Insert the Current Item (current email address being looped through) dynamic content into the field.

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉Watch my tutorials on YouTube
👉Tips and Tricks on TikTok

Was this reply helpful? Yes No