Convert text to number Action(Power Automate Desktop)

05/05/202305/16/2023

This action converts a text type value that can be recognized as a number to a numeric type.

This function is the opposite of "Convert Number to Text" and is similar to the NUMBERVALUE function in Excel.

However, text that can be recognized as numeric is automatically converted when used in an action, so this action is not used very often.
This action is used only in some cases.
If you want to generate an error that cannot be recognized as a number, or if you want to incorporate it into a formula, use this action in such cases, since it is not automatically converted.

Contents

1. How to use
- 1.1. Parameter
  - 1.1.1. Text to convert
- 1.2. Variables produced
  - 1.2.1. TextAsNumber
2. Links
- 2.1. Text Actions

How to use

Drag Convert text to number from Text onto the Workspace.

Set parameters.

Parameter

Text to convert

Specify the target text.

If the text can be recognized as a number, such as "1234" or "1,234", it is converted to a number, If the text cannot be recognized as a number, an error is generated.

Variables produced

TextAsNumber

The numeric value of the result of the conversion is stored.

---