Combine data to a single email

[Galanopd]

Hi,

I am pulling data from an excel table into flow in order to send emails. Each excel row has 'ID' , 'NAME', 'EMAIL',...etc

I have created a manually trigger a flow --> List rows present in a table --> Apply to each (Send an email (V2)).

The issue that I am facing is that if the same 'ID' appears e.g. 3 times in the table, it will send 3 emails to the same person.

What I need is all rows having the same 'ID' or 'EMAIL' to be combined in a single email but to include all data of the rows.

In other words

ID	DATA	EMAIL
1234	DATA1	someone@somewhere.com
1234	DATA2	someone@somewhere.com
5678	DATA3	somebody@nowhere.com

If rows have the same 'ID' to get together in a single email and get the sum. So it will show something like

ID	DATA
1234	DATA1
1234	DATA2
	=SUM (DATA1+DATA2)

And then the rest of the rows (I have accomplished this and it works without issues)

ID	DATA
5678	DATA3

Thank you

[Mira_Ghaly]

@Galanopd 

Can you please check below topic for a similar issue:

https://powerusers.microsoft.com/t5/Building-Flows/Group-BY-in-Flow-to-send-email-of-aggregated-data...

[Galanopd]

Hi,

Thank you for your response but I am not sure if this solutions suits my case.

The recommended example it is using 'Get items' from Sharepoint, I am using just an excel table from Onedrive.

Unless I do something wrong, the solution doesn't really help.

Any alternative?

Thank you

[Galanopd]

@Mira_Ghaly 

After all, I think you might be correct...

Haven't solved my problem yet but I am working on it!

[Mira_Ghaly]

@Galanopd

Glad to hear let me know if you need more help on that.

[Mira_Ghaly · Accepted solution]

@Galanopd 

Thanks for reaching out!

I have made a detailed flow that match your requirement and I am describing it below:

1. List Rows Present in a table

2. Select step pass the ID as below which is the Customer ID

3. Add a new variable of Type Array and Set its name to Unique Customer ID Name and add the union Expression

Union Expression as below:

union(body('Select'),body('Select'))

Then if we added a Create HTML Table:

To get the sum you need to apply below:

Expression for Adding Sum:

add(outputs('Value'),variables('Sum'))