sum and merge column data and sends in single email

[sgr]

I just got lost, I am able to get the sum of the Budget and Expenses based on Dfuncode using increment variable but I am not able to merge rest column items and display as below output and sends in single email.

I want to send a compact Email using html table

is it possible.

Image 1: SharePoint List Monitor

Output that i want to send through single email.

[BiPHiT]

Hi there,

maybe not the most elegant solution but its working: 

1. Get all items from the sharepoint list
2. Initialize array variable, which will contain all the DFundCodes from the SP list
3. Initialize array variable, which will contain the final data for the HTML table
4. Get all the occurring DFundCodes
5. Initialize float variable for the sums
6. Sumup for each DFundCode and save into array 
7. Create HTML Table

Most improtant step

[sgr]

Hi! @BiPHiT 
Thanks for your reply.  but I am not able to include GName and other 10 such row as show in my  previous output screen shot; did i miss any thing?

--

[BiPHiT · Accepted solution]

Hi there,

you did everything according to my proposal. TO add any merged values, i would suggest adding a variable for each column and setting it in the Loop where you increment the SUM.  And then at the point to where you adding things to the array adding it like in the picture. 

I know its not a very elegant solution. I have an idea, but during the workweek i'm not able to spend much time on it. In the meantime i hope that you can work it out with this update.

[sgr]

Hi @BiPHiT 

I did as per your idea, with some adjustment. I got the output too. Looking forward for the improved version in your free time.
Thank you once again;

[sgr]

@BiPHiT seems like this method does not work in big data.
My flow is running since 1.5 hours and nothing 😞