I have to admit that this function and all the other analogous functions (sub, mul, and div) are quite strange. This function will add two numbers. Having functions to do basic arithmetic is not common in programming languages or platforms. Usually, we can do things like “number + number,” but not in Power Automate. This is a source of many “head-scratching moments” since the function looks correct with a plus sign, but Power Automate will return an error.

Note: The concepts will be similar to all 4 functions so expect that the reference will be quite similar.

Usage

It follows a simple pattern.

  1. Number
  2. Number

The function will return the first plus the second number.

Example:

add(4,2)

will return 

6

It will always return a number.

Limitations

There’s a hard limitation on the size of the numbers you can pass, in this case, 19. Power Automate will return an error for:

add(12345678901234567891,1)

But it won’t return an error for:

add(1234567890123456788,1)

However, not returning an error doesn’t mean that the calculation is correct. In the first case, we would expect “1234567890123456789” but instead, we get “1234567890123456800”. Notice that after the 18th number, all is truncated to zero. This may be a source of errors since no error is returned, but instead, you get an invalid calculation. Be very careful with the size of your number since it won’t return an error, but the result is incorrect.

Recommendations:

  1. Keep the numbers as small as possible and all in variables. Don’t put the numbers directly in the function, at least the first one. It’s quite useful to have the second hardcoded when performing some pre-defined actions like incrementing a variable.
  2. Don’t nest it. You may nest operations, but it will make debugging a lot harder. Do the calculations in individual steps to see the results in each one and see if you get the desired value.
  3. Please note that formulas may have localization-based differences. For example, you should write “sub” with “separating each of the arguments, but if your regional settings are set to Portugal, you should use “;” instead.

Sources:

Microsoft’s add Function Reference

Back to the Power Automate Function Reference.

Photo by Alexandre Debiève on Unsplash

Manuel Gomes

I'm a Project Manager with experience in large projects and companies. I've worked in the past for companies like Bayer, Sybase (now SAP) and I'm currently working for Pestana Hotel Group.

View all posts by Manuel Gomes →

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: