Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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.


Solution Sage
Solution Sage

Hi @Anonymous ,


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




Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,922)