Group by a column value and send email to first record in the email column.

[Anonymous]

I am using union to group a set of records based on repeated column value of an excel file, and appending it as an array to send as table.

I want pick the first record in the email column of same row for the to email address. 

In the above example data: for every set of unique ID, I need to send data of that union to first email entry (highlighted in yellow).

Also Im not able to get the sum value of Amount column entry for any particular ID union set.

Looking forward for some inputs! Thanks.

@tom_riha 

[ManishJain]

Hi @Anonymous ,

Please follow the steps to group by data using this url : 

http://johnliu.net/blog/2018/6/do-group-by-in-flow-with-two-simple-elegant-loops

Thanks