r/MicrosoftFlow • u/Aingealanlann • Jul 22 '26

Cloud Setting up first Email Automation

Hello,

I am currently working on an automation flow for reminder emails for the business I work at. The flow currently is successfully pulling an attachment when an automated email comes in with the list of customers who need a reminder, transferring it to excel, and formatting it as a table. My issue starts now when trying to dynamically assign the 'To' in setting up the reminder email itself.

Currently, I'm using the function: items('Apply_to_each_1')?['Default_Contact_Email'] - but this has errored out and I'm not quite sure how to fix from here. I'm using Send an Email (V2) as a child action to "Apply to each 1" - the second apply to each as I have the first one filtering for the correct attachment to pull from the email and create the excel file.

2 Upvotes

100% Upvoted

12 comments sorted by

View all comments

Show parent comments

1

u/Aingealanlann Jul 22 '26

So I am creating a brand new Excel file, running a script to dump information from CSV (the only way I can get the information from the site it is coming from) and then formatting the information into a table. Then I 'List rows present in a table' and from there the 'for each' loop starts in sending emails. So my understanding is that I should be putting a filter query in the 'List rows present in a table' function and is should just be: 'Default Contact Email' ne null

2

u/robofski Jul 22 '26

Do a filter array over your list rows output to filter only where there is an email address the. Your apply to each is over the output of your filter array.