Power Automate isFloat() Function

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>')


  • 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.


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 NameType, and Value.

Power Automate isFloat() Function

3. To see the output returned, add a “Compose” data operation and provide and take the output of initialized variable.

Power Automate functions isfloat() function

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.

Power Automate functions isFloat() function explained

This is how to use the Power Automate condition isFloat() inside a flow.


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.

Power Automate Endswith Function

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
isFloat() function in Power Automate

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.
Power Automate string functions isFloat()

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'))
Using isFloat() function in Power Automate

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.

What isFloat() function in Power Automate

This is how to use an isFloat() string function in a Power Automate flow based on a SharePoint list.


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: