Skip to main content

Display the digit division in the numerical value

Power Automate Desktop can handle numerical data as a variable, but as the number of digits increases, the numbers will not be possible as soon as they look.

This time, I will explain how to display the digit separation in the numerical value.

implemented with copy and paste

As an example, after defining the altitude of Mt. Fuji as a numerical data, a scenario is prepared to generate a character string that adds a girder cut.

Copy the following code and paste it on the edit screen of Power Automate Desktop to add the target action.

SET Elevation TO 3776
Text.FromNumber Number: Elevation DecimalPlaces: 0 UseThousandsSeparator: True FormattedNumber=> FormattedNumber
SET Result TO $'''The altitude of Mt. Fuji is %FormattedNumber%m.'''

Operate and implement Power Automate Desktop

  1. From "Search for action", enter "Convert numbers into text".

  2. Set the parameters as follows

    Parameter namevalue
    Numerical valuesTarget numerical data
    Number of digits below the decimal pointExample: If it is "2", it is output "3776.00"
    Use the girder cut symbolCheck when using a girder cut
  3. By execution, the numerical data is output as a digitized character string data.