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.