formatNumber function. String.(Power Automate Cloud flows)
Converts numeric values to text in any format.
Spec
formatNumber(<number>,'<format>','<locale>')
| Argument | Default | Description |
|---|---|---|
| number | Required field | Number to be converted. |
| format | Required field | The format after conversion. |
| locale | en-us | Currency 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).
| - | Formula | Result |
|---|---|---|
| Currency | formatNumber(123456,'C') | $123,456.00 |
| fixed-digit decimal | formatNumber(123456,'F4') Specify the number of decimal digits to be fixed after F. | 123456.0000 |
| fixed-digit integer | formatNumber(123456,'D10') Specify the number of digits to be fixed after D. | 0000123456 |
| Fixed digits for both integers and decimals. | formatNumber(123456,'0000000000.00') Specify the number of digits with 0. | 0000123456.00 |
| Percent. | formatNumber(0.15,'P') | 15.00% |
| 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.