Answered

Sum of multiple numbers in Power Automate

(1) Share

Report

Posted on by MV-01080728-0

I am relatively new to Power Automate. I have created a flow that retrieves values from Business Central. I get the following output:

[ 3.3, 1.65, 2.75]

This output can vary, with more or fewer numbers. I would like to use Power Automate to sum these numbers so that I end up with a single total number. I have tried everything. Does anyone have any tips?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

There is no function in Power Automate that will calculate the sum of an array directly. You would need to run an Apply to Each loop on the Array and then either increment a variable by the current item or use the Add() function to Add the current item to a variable.

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

Robby_WW 115 on at

Like (1)

Report

Hey,

You can make a json then use the xml function to sum the value's up. This will make the flow quicker then using an apply to each action.

example:

1 people found this reply helpful.

Was this reply helpful? Yes No