formatNumber function. String.(Power Automate Cloud flows)
Converts numeric values to text in any format.
Contents
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 |
---