isFloat function.(Power Automate Cloud flows)
Checks if the text is in Float or Integer format.
In the official help it belongs to the String function, but in the PowerAutomate screen it belongs to the Logical function.
Spec
isFloat('<string>', '<locale>')
| Argument | Default | Description |
|---|---|---|
| string | Required field | Target text. |
| locale | Invariant culture | Locale for determination. |
How to use
In actions it is often used in "Condition".
It is also used to initialize or set variables of type Boolean.
Clicking on isFloat in the "Expression" tab sets the function name and () in the formula field.
When dynamic content or variables are used as arguments, special settings are made.
(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.
For example, isFloat('10.5') will result in true because of decimals.
As far as we have verified, the results are as follows.
There are cases of unintended results because of the existence of ambiguous judgment results.
| Expression | Result | Remarks |
|---|---|---|
| isFloat('10.0') | true | |
| isFloat('10') | true | Integers are also true. |
| isFloat('10.5') | true | |
| isFloat('10,5') | true | Comma judgments are not good. |
| isFloat('100,0,00,5') | true | Comma judgments are not good. |
| isFloat('100.000.5') | false | More than one period is present. |
| isFloat('10-5') | false | |
| isFloat('1000.5') | true | |
| isFloat('1,000.5') | true | |
| isFloat('1.000,5') | false | Mainly German form. |
| isFloat('100 000,5') | false | Mainly French format. |
| isFloat('a') | false | Alphabet. |
The second argument sets the locale.
By default, the format is mainly English-speaking, with digits separated by "," and decimal points by "." for the decimal point.
In most cases, this is fine, but there are many countries that have a different format, such as Germany, France, Russia, and Switzerland, for example.
To handle such country notations, set the locale as the second argument.
For example, set 'fr-FR' for French format.
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.