As an example, I've created the below Dataverse Table with the default Name column and another column called Currency of type number (decimal). The internal name for my Currency column is cra85_currency.
Below is my full flow that will get the sum of all the numbers. I'll go into each of the actions.
List rows retrieves all the data in my Dataverse Table.
We then use a Compose action (I've called it XML) to convert the JSON (body) from List rows to XML so we can use XPath to sum the numbers. This means we don't need to have a loop which makes it much more efficient/cleaner. The expression I use here is below. Effectively it's wrapping the output of List rows into a root element (required for valid XML), then converting to json then xml.
xml(json(concat('{"root": ', outputs('List_rows')?['body'], '}')))
Total is a Compose action that uses an XPath expression to sum all the numbers. The expression is below. Note that I've used my internal Currency name cra85_currency. You would need to put the internal name of your column here.
xpath(outputs('XML'), 'sum(//value/cra85_currency/text())')
And that's it. The output of Total is below:
You can then add the total to your other Table.
