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:

truncate number action

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:

Integer or fractional digit

Step3: The output for this truncate number action is shown below:

output

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:

Integer or fractional digit

Step5: The output of this action is shown below:

decimal output

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:

Integer or fractional digit

Step7: The output of this action is shown below:

random number output

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.

Happy Learning!

Like this post then let your friends know about this-:

1 thought on “Integer or fractional digit numeric value Power Automate

    • Author gravatar

      How to remove ” .” and ” ,” in excel using power automate desktop ?

      For example :
      1000.900
      1990,000
      2000.900
      =========
      results
      1000
      1990
      2000

Leave a Reply

Your email address will not be published. Required fields are marked *