cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

sum and merge column data and sends in single email

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

sgr_3-1599298845080.png

 

 

Output that i want to send through single email.

sgr_2-1599298723490.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Frequent Visitor

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.

 

BiPHiT_0-1599470015053.png

BiPHiT_1-1599470154062.png

 

View solution in original post

5 REPLIES 5
Frequent Visitor

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 stepMost improtant step

 

HelpPA1.png

 

 

 

 

 

 

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?

sgr_0-1599461521520.png

--

sgr_0-1599463914493.png

 

 

Frequent Visitor

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.

 

BiPHiT_0-1599470015053.png

BiPHiT_1-1599470154062.png

 

View solution in original post

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_0-1599476264662.png

 

 

sgr_2-1599476459032.png

 

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

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (6,311)