Answered

To show the sum of all prices of books

(0) Share

Report

Posted on by Jabbar CRM

Hello Dear Flow People,

Here what I am doing is that there is my custom entity i.e "Books" so I am obtaining all books records and creating the HTML table and adding all obtained fields to that Table and showing that HTML table as Body of an email and sending it to specific users.

But I am stuck where I need to do the addition of all books prices and show it as Total or Sum in row of HTML table ??

Looking forward to hear from you all

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please have a look at this link below.

https://flow.microsoft.com/en-us/blog/calculate-running-totals-and-tracking-maximum-values-in-flow/

Thanks

Was this reply helpful? Yes No
manuelstgomes 6,625 on at

Like (0)

Report
Copy link

Link copied!
HI @JabbarCRM

I think we need to created a Loop of the data and increment a variable with that.

Just do the following:
Create a numeric variable
For Each value in Book Records
Increment the variable with the price
Then include that in your email.

Makes sense?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers
Manuel

Was this reply helpful? Yes No
Verified answer

v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @JabbarCRM,

There are many posts about how to sum the prices in the table if you want to add the sum into the table, you should initialize the output of Select action as an array variable:

1. I get these data from a SharePoint list instead of CDS, and initialize an array variable named Table. At the same time, I initialized an integer variable named Sum.

2. After that, create an Apply to each action to loop through all the items of the table, if the Price property is not null, use the increment variable action to increase the Sum variable:

3. After get the sum of price, create the following JSON and append to array variable. Then you can put the table variable into your email.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No