Mathematical Functions in Power Automate
Mathematical functions are the same as you expect. They allow you to add, subtract, multiply, and perform other similar functions. (eg: add() , mul(), max()).
| Mathematical Functions | Description |
| add | Returns the sum of two numbers. |
| div | Returns the division of two numbers. |
| max | Returns the maximum value from an array. |
| min | Returns the minimum value from an array. |
| mod | Returns the remainder by dividing two numbers. |
| mul | Returns the product of two numbers. |
| rand | Returns a random integer from a range of numbers. |
| range | Returns an integer array or set of numbers that start from a specified integer. |
| sub | Returns the subtraction of two numbers. |
Let's see how we can use these functions in a flow.
- Go to Microsoft Power Automate. Sign in to your account.
- Create a Manually Triggered Flow. Add two number inputs. Click on the New step.
- Select the Initialize variable from actions. Name the variable as Sum, choose Type as an Integer. Click on the Add dynamic content.
- Go to Expressions. To add two numbers we use add() function.
We use the following expression to add both numbers:add(triggerBody()['number'],triggerBody()['number_1']) - Add this expression in Expression (Add dynamic content) and click on OK.
- Click on Save and Run the flow.
- Enter two numbers to add and click on Run flow.
- We get the sum of the two numbers entered as the output.
About Author :
I am Sharvari Raut, having sound knowledge and experience in technical writing. Currently, pursuing my B.Tech in Computer Science and Engineering.
Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions
