Answered

How Sum Dataverse Fields Rows?

(0) Share

Report

Posted on by PeterKa

Hi,

i have searched the internet, tried several approaches, i can't manage to sum the fields of a dataverse query, maybe someone can help me. SumCost is 0 every time, i have no more ideas what can i do for sum the rows of my dataverse query. Thanks you.

I have the following flow:

1.2.3.4.

regards peter

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

wskinnermctc 6,519 Moderator on at

Like (1)

Report
Can you show what you are doing in "ComposeExcelRow" and the "Set Temp SumCost Var" actions?

Instead of trying to add variables together, try using the "Increment Variable" action. It is basically like adding, but you only need one action. You wouldn't need to manage multiple variables. You could have a single variable and Increment it each time.

Initialize Variable - SumCost

Apply to Each - Dataverse Row

Increment Variable - SumCost - by dataverse row data

Was this reply helpful? Yes No
PeterKa 10 on at

Like (0)

Report

Hi, thanks for you answer,

this try i get it from: How to Sum an Array in Power Automate - Power Tech Tips

i tried now with increment variable, but still be 0... now i'm not sure if the dataverse Result rows are the problem,
what i would do, is list each day of a month, and summary the line items for this day. In Dataverse Table i have only 4 entries for the month i'm testing, perhaps this is my problem, i will check this

Was this reply helpful? Yes No
WillPage 2,307 Super User 2025 Season 2 on at

Like (1)

Report

I would suggest you try this method using XPATH: https://www.tachytelic.net/2021/06/power-automate-instant-sum-array/ it's much simpler and more efficient that running loops

Was this reply helpful? Yes No
PeterKa 10 on at

Like (1)

Report

let me say that increment variable works, however i find the loop quite slow, i will try the method with the arrays, thank you both very much

Was this reply helpful? Yes No