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.
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
29 | |
27 | |
23 | |
17 | |
10 |
User | Count |
---|---|
66 | |
58 | |
29 | |
27 | |
25 |