Truncate number Action(Power Automate Desktop)

08/15/2023

Japanese version.

This action truncates a number to an arbitrary number of decimal places.

Get the minority or integer portion, or round to the specified number of digits.

How to use.

Truncate number Action from Variables onto the workspace.

Set parameters.

Parameters

Number to truncate

Specifies the number to be truncated.

Operation

Specifies the truncation method.

  • Get integer part
  • Get decimal part
  • Round number

When rounding a number, specify the number of digits.

Decimal places

To round a number, specify the number of digits.

0 is for a whole number, 1 is for one decimal place, and anything less than or equal to two places is rounded to the nearest whole number.

The range is 0 to 28.

Similar to Excel's ROUND function, but integer digits cannot be rounded. (Specify a negative number of digits).

In that case, the following processing is required.

  • Divide the number by a multiple of 10 and round off the truncated portion to the decimal point.
  • This action truncates the number.
  • Multiply the divided number by a multiple of 10 to restore the original digit.

If you want to truncate instead of rounding, the number must be subtracted by -0.5 (depending on the digit).

Variables produced

TruncatedValue

The value of the result of truncation is stored.

---

For those who want to learn Power Automate Desktop effectively


The information on this site is now available in an easy-to-read e-book format.

Or Kindle Unlimited (unlimited reading).

You willl discover how to about basic operations.

By the end of this book, you will be equipped with the knowledge you need to use Power Automate Desktop to streamline your workflow.

Table of Contents.

Update History.

Links

Variables Actions

Examples of Use

How to get the quotient and remainder of a division.