Do you want to convert string to float in Power Automate? In this Power Automate tutorial, we will see how to convert string to float in Power Automate.
Converting a string to a float in Power Automate means changing a piece of text that looks like a number into an actual number so that Power Automate can use it.
In Power Automate, sometimes what seems like a number is actually treated as text. This can lead to problems in workflow when we want to do calculations or other operations with these values in Power Automate.
To convert a string to float in Power Automate, we will use float(), which will take the value as a string and convert it into float in Power Automate.
Syntax
float(string, locale)Here, we will see the topics below
- How do you convert string to float in Power Automate?
- How do you convert string to float dynamically in Power Automate?
Convert string to float in Power Automate
Here, we will see how to convert string to float in Power Automate.
For example, we have a string ‘234.56’, and we will convert it into float using float() in Power Automate. The result will be 234.56.
1. Open Power Automate Cloud, then click on +Create -> select Instant Cloud Flow.
Then, provide a flow name and select Manually trigger a flow action. Then click on Create.
Now, you can see the “Manually trigger a flow” action is added to the flow page.
2. We will initialize a string variable, for this click on +New step -> select Initialize variable action. Then provide the below information:
- Name: Provide the name of the variable
- Type: Provide the type as a string
- Value: Provide the value like below
3. We will convert the above string to a float; for this, click on +New step -> select Compose action and then provide the information below.
- Inputs: Provide the below expression
float(variables('str'))
4. Now save and run the flow manually. You can see the string is converted to float in Power Automate.
This is how we can convert string to float in Power Automate.
Convert string to float dynamically in Power Automate
Here, we will see how to convert the string to float dynamically from SharePoint in Power Automate.
For example, I have a SharePoint list called Product, which contains two columns i.e., Product name and Price, both are of single line of text.
We will get the items from the SharePoint list, and we will convert the single line of text to float in Power Automate.
To do this in Power Automate, follow the below steps:
1. Open Power Automate Cloud, then click on +Create -> select Instant Cloud Flow.