Stuck on trying to send email with multiple senders from spreadsheet

[Jarred_hall]

Hi,

I'm stuck on trying to send a email to multiple recipients through one email. The flow needs to look at two different columns that contain multiple email address some of them are the same. From the picture I've attached of the test table, you can see the two columns with test emails address. The column on the left as all the same email address, where the column on the right has two different ones. I needs to send two emails from the first column, but with each of those different email address from the right column, need to be added as extra recipients in those two emails, but not make sure that Test 2 email address receive a email that as the test 3 email address in it. So there should be two separate emails address but only Test 2 in one and Test 3 in the other. I've done this with one column, but not sure how to do it with two. You can see from the flow that I've put the table into an array, and have created two arrays for unique Authoriser and unique query Authorisers. I've then done a apply to each from the output of the Unique Authorisers, and then flited it to equal the column from the spreadsheet. Not sure what to do from here though next to filter out the the query authorisers so can send separate emails. Hope this makes sense.

[jaaronanderson]

I instantiate a string variable uptop my flow and continue to append <email value>; in a for loop to the purple variable then send to that if it helps

[jaaronanderson]

read if sending you can connect using password and change account but youll need to be sure to maintain health in binding to the external account that is not what the flow is in .. you may have to fix connection from time to time or add a flow with same actions in that account that just does its dedicated email jobs 

[jaaronanderson]

looking at flow 1 Id maybe add a column in excel that is a key qualifier for which Email Sender is identified... then just cross evaluate that and choose which canned email action corresponds in a logic conditional action for each column value possibility ... make sense ?