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

For those who want to learn Power Automate Cloud flow 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 Cloud flow to streamline your workflow.


String Functions(Power Automate Cloud flows)