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

Categories:

Building flows

@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.