Do you know how to use the Power Automate isFloat() function in a flow? In this tutorial, I will explain to you how the Power Automate isFloat() function works and its syntax, along with examples of that function.
Power Automate isFloat() function
The isFloat() function in Power Automate, which is part of Microsoft’s Power Platform, is used to determine if a given input is a floating-point number. In simpler terms, it checks whether the input can be considered a decimal number, which includes numbers with fractional parts.
Syntax of isFloat() function in Power Automate
Here is the syntax of isFloat() function in Power Automate.
isFloat('<string>', '<locale>')Parameters:
- Value: This is the input that you want to check. It can be a string or a number.
- Return Value: The function returns true if the value is a floating-point number (i.e., a number with a decimal point). If the value is not a floating-point number, it returns false.
Examples of Power Automate isFloat() Function
Let’s understand the isFloat() function by implementing examples in a Power Automate flow.
Follow the below instructions for steps to create a Power Automate flow.
Example:-1
Here, I will explain the Power Automate isFolat() expression by ‘Instant cloud flow’.
1. Create an “Instant cloud flow” in Power Automate. Add a text input inside the trigger.
Instructions to create: Navigate to https://make.powerautomate.com -> click on “+Create” -> Select “Instant cloud flow” -> set the Flow name, choose “Manually trigger a flow” and click on Create.
2. Then, add an “Initialize variable” flow action to store the values. Set the properties like Name, Type, and Value.
isFloat(triggerBody()['text'])
3. To see the output returned, add a “Compose” data operation and provide and take the output of initialized variable.
4. The manual trigger flow is ready to save now. Save and Test it now Manually.
5. Expand the compose flow action to display the result of the isFloat() function inside a flow.
This is how to use the Power Automate condition isFloat() inside a flow.
Example:-2
I will also describe the Power Automate isFloat() string function using a SharePoint list in the second example.
To work with this, I have created a SharePoint list named ‘Travel Request Forms‘ with different datatypes as presented below.
For implementing this in a flow, I have used a SharePoint list ‘Travel Request Forms‘, with a Title column (Trip Title) as a reference column.
Here, we wanted to verify whether the newly created items in a SharePoint list with the list column “Travel Duration Days” had a float value or not.
Step-by-step process to create a Power Automate flow:
1. Navigate to https://make.powerautomate.com/ -> click on +Create and select “Automated cloud flow”. In the next window, provide a name for the flow, choose the trigger “When an item is created” and click on Create. Here are the details below:
- Site Address: Select a site name from the drop-down.
- List Name: Choose a list name from the drop-down
2. Next, add an “Initialize variable” flow action that stores variable value and is used during the flow. Provide details below.
- Name: Give a name for the variable.
- Type: Select datatype from the drop-down.
- Value: Select value from the dynamic content.
3. Then, add a “Compose” data operation and set the below details.
- Inputs: Take the below given code value in it.
isFloat(variables('Folat value'))
4. Now, the flow has been ready. Let’s Save it. Test it Manually. Now, add an item to the SharePoint list.
5. Then, the outputs of the compose flow action will give the result as true or false if the text has that specific value.
This is how to use an isFloat() string function in a Power Automate flow based on a SharePoint list.
Conclusion
Now, I hope you understand how to use the Power Automate isFloat() function to check if a string or number is a floating number. I have explained how to use the isFloat() function in Power Automate with two examples.
You may also like:
- Power Automate endsWith() Function
- Power Automate substring() Function
- Power Automate toUpper() Function
- Power Automate Chunk() Function
- Power Automate addDays() Function
Preeti Sahu is an expert in Power Apps and has over six years of experience working with SharePoint Online and the Power Platform. She is the co-author of Microsoft Power Platform: A Deep Dive book. As a Power Platform developer, she has worked on developing various tools using Power Apps and Power Automate. She also makes Microsoft 365 videos and shares them on YouTube.
