Integer or fractional digit numeric value Power Automate
A lot of times while designing a business process automation for financial processes.
We need to get the integer or fractional digit of numeric value or round up the value to a specified number of decimal places.
In this article, we will discuss how to achieve this task using Power Automate Desktop.
Let’s get into the practical implementation of this task:
Step1: Drag and Drop Truncate number from actions panel to the designer panel as shown below:
Let’s talk about the parameters of truncate number action:
- Number to truncate – Provide the input value for which we are doing these actions.
- Operation – Select which type of operation you need to perform.
Get integer part:
The integer part of a real number is the part of the number that appears before the decimal.
Step2: Pass the number to truncate and select get integer part in the drop-down as shown below:
Step3: The output for this truncate number action is shown below:
Get decimal part:
The decimal part of a real number is the part of the number that appears after the decimal.
Step4: Pass the value and select get a decimal part in the drop-down as shown below:
Step5: The output of this action is shown below:
Round Number:
It will provide the rounded number of the input basing on the decimal places that are given as input.
Step6: Pass the input value and select round number from the drop-down as shown below:
Step7: The output of this action is shown below:
Here:
It rounded the value with three decimals because we provided the decimal places as 3 in the input as shown above.
If you provide the decimal places input as zero then it won’t give value after the decimal.
This is how we can get the integer part or fractional digit of values.
How to remove ” .” and ” ,” in excel using power automate desktop ?
For example :
1000.900
1990,000
2000.900
=========
results
1000
1990
2000