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!
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
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2