Unable to add sum more than 2 values using add expression

(0) Share

Report

Posted on by nicklim

391

Hi everyone,

In "Word Online Business" action, I am using the fx expression to sum the values of the other columns. However, it won't work if there are more than 2 values. Is there a workaround to it?

If I get rid of the 3rd if statement, it will work.

add(
 if(contains(body('Select_-_OptionalUpgrades'), 'Zip Tap'),
 variables('ZipTap'),
 0
 ),
 if(contains(body('Select_-_OptionalUpgrades'), 'V-Zug Combi Steam Oven'),
 variables('V-ZugCombi'),
 0
 )
 ,
 if(contains(body('Select_-_OptionalUpgrades'), 'V-Zug Warming Drawer'),
 variables('V-ZugWarming'),
 0
 )
)

Error:

Unable to process template language expressions in action 'Populate_a_Microsoft_Word_template' 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 seccond summand as the second parameter. The function was invoked with '3' parameter(s). Please see https://aka.ms/logicexpressions#add for usage details.'.

Categories:

General topics

All responses (3)

Answers (1)

Sort by

Verified answer

v-mingkz-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @nicklim,
The add function just except 2 parameters.
You can use two add.
add( add( if(contains(body('Select_-_OptionalUpgrades'), 'Zip Tap'), variables('ZipTap'), 0 ), if(contains(body('Select_-_OptionalUpgrades'), 'V-Zug Combi Steam Oven'), variables('V-ZugCombi'), 0 ) ), if(contains(body('Select_-_OptionalUpgrades'), 'V-Zug Warming Drawer'), variables('V-ZugWarming'), 0 )

Best Regards,
Kyrie
nicklim 391 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-mingkz-msft

Thanks for the prompt reply and you might want to edit your code as you are missing a closing bracket.
nicklim 391 on at

Like
a
(0)

Report
Copy link

Link copied!
@v-mingkz-msft sorry to bug you, I've added additional add function into the code but it seems to not like it. Am not sure if that's the way to do it? Can you have a look at it please.

add( add( if(contains(body('Select_-_OptionalUpgrades'), 'Zip Tap'), variables('ZipTap'), 0 ), if(contains(body('Select_-_OptionalUpgrades'), 'V-Zug Combi Steam Oven'), variables('V-ZugCombi'), 0 ) ), add( if(contains(body('Select_-_OptionalUpgrades'), 'V-Zug Warming Drawer'), variables('V-ZugWarming'), 0 ), if(contains(body('Select_-_OptionalUpgrades'), 'Pearl Finish'), variables('V-ZugWarming'), 0 ) ), add( if(contains(body('Select_-_OptionalUpgrades'), 'Electric opener'), variables('ElectricOpener'), 0 ), if(contains(body('Select_-_OptionalUpgrades'), 'Under Bench wine fridge'), variables('UnderBenchWine'), 0 ) ), if(contains(body('Select_-_OptionalUpgrades'), 'Tall Wine Fridge'), variables('TallWineFridge'), 0 ) )