cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FP_Sandra
New Member

Transaction Reports with Amount Total (Sum HTML?)

Hello all!

 

Looking to email a simple transaction report with a TOTAL amount paid. This can be either in the body of an email or on an Excel attachment. 

 

The data comes from one Excel doc that looks like this:

 

Excel Report.PNG

 

End Goal:

  • User@TheBatman.com receives an email with just three transaction lines and a total of the three amounts.
  • User@Joker.com receives an email with one transaction and total.
  • Etc...

 

I currently have a flow set-up so that the table appears in the body of the email, but I'm stuck on how to get the output of total from the HTML table created:

 

GoalEmail1.PNG

 

The total can be a row in the table or not.

 

Is it better to change the flow so that the recipients receive an attached Excel or CSV?

 

My current flow looks like this:

 

Flow OverviewFlow Overview

 

Detail of flow:

FlowImage1FlowImage1

FlowImage2FlowImage2

FlowImage3FlowImage3

FlowImage4FlowImage4

 

Thanks for any help anyone can provide!!

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @FP_Sandra ,

 

You could try to create the 3th variable (data type of float) at the begining of the flow.

vxiaochenmsft_0-1658207771495.png

Then you could try to use 'Increment variable' action in nested loop.

vxiaochenmsft_1-1658207942476.png

 

Now you can use this float variable in your email body. The vaule of the variable is the amount total .

Finally, don't forget to reset the variable to 0 .

vxiaochenmsft_2-1658208102418.png

 

Best Regards,

Wearsky

 

View solution in original post

2 REPLIES 2
v-xiaochen-msft
Community Support
Community Support

Hi @FP_Sandra ,

 

You could try to create the 3th variable (data type of float) at the begining of the flow.

vxiaochenmsft_0-1658207771495.png

Then you could try to use 'Increment variable' action in nested loop.

vxiaochenmsft_1-1658207942476.png

 

Now you can use this float variable in your email body. The vaule of the variable is the amount total .

Finally, don't forget to reset the variable to 0 .

vxiaochenmsft_2-1658208102418.png

 

Best Regards,

Wearsky

 

Hi Wearsky,

 

Apologies for delayed reply. 

 

This almost worked. It's resulting in a COUNT, not a SUM. 

 

Not sure if I have an error in how I added your suggestions. Here's what I added:

 

3RD VARIABLE

New 3rd Variable.PNG

 

INCREMENT VARIABLE

New Increment Variable.png

 

FLOAT IN SUBJECT

 

Float in Subject.PNG

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (3,459)