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 | name | hours | jobs | start date | end date | note | |
1 | Bob | 89 | 122 | 1/1 | 1/3 | continue | |
2 | 332@email | Jane | 90 | 125 | 1/1 | 1/2 | continue |
please help.
thank you
Solved! Go to 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.
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.
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.
User | Count |
---|---|
88 | |
40 | |
23 | |
20 | |
16 |
User | Count |
---|---|
130 | |
50 | |
48 | |
35 | |
26 |