Adding multiple variables in Power Automate

Like (0) Share

Report

Posted on 20 Oct 2022 08:22:48 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.

All responses (2)

Answers (1)

Brendan_Val 15 on 20 Nov 2023 at 07:00:53

Like (0)

Report

Re: Adding multiple variables in Power Automate

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.
Verified answer

shoog 2,164 on 20 Oct 2022 at 09:19:25

Like (1)

Report
Re: Adding multiple variables in Power Automate

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'))))))))))))