How to send two different tables in one email to each recipient in the list

[WasimChhipa]

Hi

I have two datasets with same email ID in 2 different sheets as below.

1st Data Set. (This is Summary Mgr wise) 

Name	Tot1	Tot2	Tot3	Email_ID
Mgr1	149	187	133	Mgr1@anyone.com
Mgr2	192	142	127	Mgr2@anyone.com
Mgr3	177	175	126	Mgr3@anyone.com
Mgr4	109	101	125	Mgr4@anyone.com
Mgr5	146	182	168	Mgr5@anyone.com

2nd data Set ( This is the List of Emp Mgr wise)

Name		Tot1	Tot2	Tot3	Email_ID
Emp1	Mgr2	149	187	133	Mgr2@anyone.com
Emp2	Mgr5	192	142	127	Mgr5@anyone.com
Emp3	Mgr2	177	175	126	Mgr2@anyone.com
Emp4	Mgr5	109	101	125	Mgr5@anyone.com
Emp5	Mgr4	146	182	168	Mgr4@anyone.com
Emp6	Mgr5	168	132	131	Mgr5@anyone.com
Emp7	Mgr5	166	149	107	Mgr5@anyone.com
Emp8	Mgr3	198	180	151	Mgr3@anyone.com
Emp9	Mgr5	147	120	193	Mgr5@anyone.com
Emp10	Mgr3	118	131	160	Mgr3@anyone.com
Emp11	Mgr3	166	102	136	Mgr3@anyone.com
Emp12	Mgr1	153	146	163	Mgr1@anyone.com
Emp13	Mgr5	194	149	179	Mgr5@anyone.com
Emp14	Mgr3	108	194	169	Mgr3@anyone.com
Emp15	Mgr3	184	151	154	Mgr3@anyone.com

I want to send 2 different data sets in 1 email creating 1 single flow where Mgr's email ID is same in both data sets.

Name	Tot1	Tot2	Tot3	Email_ID
Mgr2	192	142	127	Mgr2@anyone.com

Name		Tot1	Tot2	Tot3	Email_ID
Emp1	Mgr2	149	187	133	Mgr2@anyone.com
Emp3	Mgr2	177	175	126	Mgr2@anyone.com

Your immediate help will be highly appreciated.

Thanks in advance.

[DamoBird365]

Hi @WasimChhipa 

Are these data sets arrays?

I would supply the first array to an apply to each and then filter the 2nd within the apply to each (filter array) based on the emails matching.  Then create a table on the filter result and send an email.  The apply to each will run 5 times and send 5 emails with the filtered html table.

Damien

Please consider accepting my answer as a solution if it helps to solve your problem.

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts, or take a look at my website. Thanks

[WasimChhipa]

Hi Dam,

These are Data sets,

Actually I am new with Flows, & not much talented to understand your solutions.

Could you please help me with visuals or screenshots with process to carry out this flow.

It would be a great help of yours.

Thanks

[DamoBird365]

Hi @WasimChhipa 

can you tell me what actions you are using to get the data? Is it from a list, excel an api? Then I can be more specific with a solution.

Damien

[WasimChhipa]

Hi Damien,

I am using Excel located on One Drive.

Thanks

[DamoBird365]

Hi @WasimChhipa 

I've knocked up a quick demo, showing you how I would solve your problem using Excel, and Power Automate and a few tips on formatting and selecting columns for the HTML table.

Hopefully this is of use Send Unique Emails with HTML Table using Data from Excel #PowerAutomate - YouTube

***Updated the video to also include a demo of select / distinct values so that you could create your email without the first table of data***

Please consider accepting my answer as a solution if it helps to solve your problem.

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts, or take a look at my website. Thanks

[DamoBird365]

Hi @WasimChhipa 

I've updated the original video as the sound wasn't great.  I've also included how to get distinct emails using select and union, which might be useful if you or anyone else don't have the first table.

Please let me know if this has solved your problems.

Damien

[N_K]

Hi Damien,

This is to bring to your notice that Filter array does not give an option to select the Email_ID field and by typing the expression item()?['Email_ID'] it returns blank output as [] (Screenshot#2). Is there any solution for this?

[DamoBird365]

Hi @N_K 

Email_ID as the name of the fields in my example, it looks like you have the field named Email.  You would need to match our solution, including field names to use the exact same expressions OR change the expressions to match your field names. 

Damien

[N_K]

The problem was with the filter array. It was receiving the input correctly. However, the filter was not being applied properly. I could resolve it with expression items('Apply_to_Each')['Email'].

[WasimChhipa]

Hi Dam,

I have a table called Process List with Reporting Manager & Manager.

I want to send an email with list of processes to Manager with respective Reporting Manager in CC.

Since both are duplicate & I am unable to find the way out, tried a lot.

It would be great help of yours if you can help automate this.

The table looks like this.

Process	Reporting Manager email ID	Manager Email ID
Process1	RepMgr1@anyone.com	Mgr1@anyone.com
Process2	RepMgr1@anyone.com	Mgr1@anyone.com
Process3	RepMgr1@anyone.com	Mgr1@anyone.com
Process4	RepMgr2@anyone.com	Mgr1@anyone.com
Process5	RepMgr2@anyone.com	Mgr1@anyone.com
Process6	RepMgr2@anyone.com	Mgr1@anyone.com
Process7	RepMgr3@anyone.com	Mgr2@anyone.com
Process8	RepMgr3@anyone.com	Mgr2@anyone.com
Process9	RepMgr3@anyone.com	Mgr2@anyone.com
Process10	RepMgr4@anyone.com	Mgr2@anyone.com
Process11	RepMgr4@anyone.com	Mgr2@anyone.com
Process12	RepMgr4@anyone.com	Mgr2@anyone.com