get 1st row, email data from row, get 2nd row, email data, get 3rd row, email data, etc

[clofgren34]

I have a table that has columns with email address, name, and 5 columns of data regarding the individual. I am trying to create a flow to grab the first row of data, extract and create an email to address in email column, place all info from this same line in email, send email, go to second row and repeat process until all 150+ emails are sent. this will then be scheduled weekly.

Example table

line	email	name	hours	jobs	start date	end date	note
1	ee1@email	Bob	89	122	1/1	1/3	continue
2	332@email	Jane	90	125	1/1	1/2	continue

please help.

thank you

[tom_riha · Accepted solution]

Hello @clofgren34 ,

that's exactly what 'Apply to each' action will do. You get all rows in the Excel table using the 'List rows present in a table' action and then add the 'Send an email' action using the columns from the table. Power Automate will automatically add 'Apply to each' around the 'Send an email' to process the rows one by one.

[clofgren34]

Thank you sir. I was way over complicating thinking I had to do some voodoo with loops, filtering, and get rows. I appreciate the help.