Answered

Combine data to a single email

(0) Share

Report

Posted on by 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

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@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/td-p/397420

Was this reply helpful? Yes No
Galanopd 23 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Galanopd 23 on at

Like (0)

Report

@Mira_Ghaly

After all, I think you might be correct...
Haven't solved my problem yet but I am working on it!

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@Galanopd

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

Was this reply helpful? Yes No
Verified answer

Mira Ghaly 11,413 Moderator on at

Like (1)

Report
@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'))

Was this reply helpful? Yes No