Adding multiple variables in Power Automate

(0) Share

Report

Posted on by janineb

Good day

I have a flow that has to add multiple variables under the "SumAll" Compose item:

My formula looks like this:

add(variables('var2MulBusinessCase'), add(variables('var3MulKeyRisks'), add(variables('var4MulFitness'), add(variables('var5MulLegal'), add(variables('var5MulCreditRisk'), add(variables('var5MulESG'), add(variables('var5MulCompliance'), add(variables('var5MulCSG'), add(variables('var6MulTeamPerform'), add(variables('var7MulTurnaround'), add(variables('varmul1QltyRep'))))))))))))

This is the error I'm getting:

"Unable to process template language expressions in action 'SumAll' inputs at line '0' and column '0': 'The template language function 'add' expects two numeric parameters: the first summand as the first parameter and the second summand as the second parameter. The function was invoked with '1' parameter(s)."

Your kind assistance would be appreciated.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

shoog 2,164 on at

Like (1)

Report
Copy link

Link copied!
The very last add function only has 1 parameter, removing that should work:

add(variables('var2MulBusinessCase'), add(variables('var3MulKeyRisks'), add(variables('var4MulFitness'), add(variables('var5MulLegal'), add(variables('var5MulCreditRisk'), add(variables('var5MulESG'), add(variables('var5MulCompliance'), add(variables('var5MulCSG'), add(variables('var6MulTeamPerform'), add(variables('var7MulTurnaround', variables('varmul1QltyRep'))))))))))))

Was this reply helpful? Yes No
Brendan_Val 15 on at

Like (0)

Report
Copy link

Link copied!

Hi,

that didn't work for me so I had to add 2 sums in a separate compose then add the missing one to the ones i already added. I only had to add 3 sums together.

Was this reply helpful? Yes No