formatNumber function. String.(Power Automate Cloud flows)

Japanese version.

Converts numeric values to text in any format.



numberRequired fieldNumber to be converted.
formatRequired fieldThe format after conversion.
localeen-usCurrency and comma delimitation methods.

How to use

The substring function is used for text parameters.

Clicking on formatNumber in the "Expression" tab sets the function name and () in the formula field.

Specify text enclosed in "'" and delimited by "," and click OK.

If you want to use dynamic content or variables, the ,delimiter is the same.

(How to get dynamic content with expressions.)

If you see something like the following, your settings are complete.

You can change the contents of the function by clicking on the purple icon.

As in the example, formatNumber(123456,'C') will result in "$123,456.00".

Examples of arguments and results

Typical examples of format are as follows (all).

fixed-digit decimalformatNumber(123456,'F4')
Specify the number of decimal digits to be fixed after F.
fixed-digit integerformatNumber(123456,'D10')
Specify the number of digits to be fixed after D.
Fixed digits for both integers and decimals.formatNumber(123456,'0000000000.00')
Specify the number of digits with 0.
Comma separated.formatNumber(123456,'N')123,456.00
Comma separated (Integer).formatNumber(123456,'N0')123,456
Comma Separated and Fixed Digits.formatNumber(123456,'000,000,000')000,123,456



String Functions(Power Automate Cloud flows)