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
From "Search for action", enter "Convert numbers into text".
Set the parameters as follows
Parameter name value Numerical values Target numerical data Number of digits below the decimal point Example: If it is "2", it is output "3776.00" Use the girder cut symbol Check when using a girder cut
By execution, the numerical data is output as a digitized character string data.