Send email to all addresses in an Excell column

(0) Share

Report

Posted on 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!

All responses (1)

Answers (1)

Verified answer

mahoneypat 1,720 on at

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