Send email to all addresses in an Excell column

Like (0) Share

Report

Posted on 11 Mar 2021 11:53:17 by gaborszollosy

Hi there!

I'm trying to create a scheduled flow that will execute each month.

What it should do is:

1. Check an XLSX file's contents

2. Read all email addresses and corresponding names present in Table1

3. Send individual emails to all emails with proper addressing of the recipient.

I was trying to use Read a row from a table, and use an Apply to each for all email addresses to send an email, but the apply to each element ran with an error telling me that the email value is not an array.

I'm sorry, I'm pretty new with Power Automate.

Thank you in advance for the help!

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

mahoneypat 1,720 on 12 Mar 2021 at 00:51:13

Like (1)

Report

Re: Send email to all addresses in an Excell column

Here is an example flow that shows how to do this. Use List rows ... to get the data from your Excel table, add a send email step and put the Email field in the To: field (this will trigger it being wrapped in an Apply To Each step). You can then customize the email to be sent to each person.

Regards,
Pat

Was this reply helpful? Yes No