Unanswered

Increment variable giving wrong result

(0) Share

Report

Posted on by sgr

I got dynamic custom HTML table generated through flow getting data from SharePoint list based on filter query as shown in below fig. Here I am able to get filter data in dynamic HTML table but I could not got the way to get Total sum value from Budget. It is giving wrong result.

I tried increment variable but its not giving exact results

1st iteration , i got correct result but in 2nd iteration it is adding result of 1st iteration as well. Any idea how to solve this? IS this possible????

flow-r (2).png

Categories:

Using flows

I have the same question (0)

All responses (12)

Answers (2)

MJain 2,450 on at

Like (0)

Report

Hi @sgr ,

Are you filtering the data by code first and then summing the data .

Thanks

Was this reply helpful? Yes No
rsaikrishna 3,703 on at

Like (0)

Report

@sgr

Please check the flow execution result and check how many items the Get Items action returned in every iteration. If the Get Items return more than you expected, then something wrong in the Filter Query in Get Items action. Once you correct it, everything will be fine.

Please let us know if you have any more questions.

Regards
Krishna Rachakonda
If my reply helped you solving the issue, please mark the reply as Accepted Solution.

Was this reply helpful? Yes No
sgr on at

Like (0)

Report

@ManishJain That what i wanted; and filtered the data first and convert to HTML.
The HTML output is fine; all the budget amount in row/column are correct result.
Only problem is sum.

Was this reply helpful? Yes No
sgr on at

Like (0)

Report

@rsaikrishna as show in figure, it produced two output
in 1st output total budget sum is correct, in 2nd output it is summing total budget from previous output as well.

the html output is correct, i have no issues with that; it shows budget and project correctly.

Was this reply helpful? Yes No
rsaikrishna 3,703 on at

Like (0)

Report

@sgr

In the Apply to each, before setting a variable, place a Compose action.
In the compose action, place the expression from the variable.
Then, set the variable value to the output of Compose.

NOTE: variables can not be used to set values to itself in a loop.

Please give a try and let me know if this works for you.

Regards
Krishna Rachakonda
If my reply helped you solving the issue, please mark the reply as Accepted Solution.

Was this reply helpful? Yes No
MJain 2,450 on at

Like (0)

Report

Hi @sgr,

Please use the following url to compute the sum :

https://powerusers.microsoft.com/t5/Building-Flows/Calculate-sum-of-multiple-numbers/td-p/334399

Thanks

Was this reply helpful? Yes No
sgr on at

Like (0)

Report

@rsaikrishna

You mean this? i got same result as before

Was this reply helpful? Yes No
rsaikrishna 3,703 on at

Like (0)

Report

@sgr

Something is missing from your screen shot.

Can you please share your entire Apply to each condition? I do not see where you are adding the values?

Regards
Krishna Rachakonda

Was this reply helpful? Yes No
sgr on at

Like (0)

Report

@rsaikrishna here is the full one..

Was this reply helpful? Yes No
Verified answer

rsaikrishna 3,703 on at

Like (0)

Report

@sgr

Do you have any more flow actions after "Increment Variable" action?

Regards
Krishna Rachakonda

Was this reply helpful? Yes No