Power Automate: float function
Converts strings and integers to floating-point numbers.
This is my reference library, the place I send people when they need precise, dependable answers about how a specific function, action, or trigger actually behaves. Tutorials teach you a workflow, but a reference tells you exactly what a piece does, what it expects, and where it bites. My Excel Function Reference breaks down worksheet functions like the "Count" function with clear syntax and examples. The Power Apps Function Reference covers the Power Fx functions you use to build canvas apps, and the SharePoint List Function Reference explains the calculated column functions that shape list data. For automation, the Power Automate Trigger Reference documents how each trigger fires, while the N8N Node Reference and N8N Trigger Reference do the same for the open-source world. An OData Reference handles the query syntax for filtering and sorting data. Every page delivers real syntax, real parameters, and the gotchas I have hit.
Converts strings and integers to floating-point numbers.
Removes leading, trailing, and extra internal spaces from text.
Adds text to an existing string variable.
Checks whether a substring, array element, or object key is present. Case-sensitive, no type coercion.
Returns true when a string, array, or object has no value. Numbers and booleans throw an error.
Assigns a value to an existing variable. Strict type enforcement.
Fires when a user selects an Excel row via the Power Automate add-in.
Converts a string, integer, or float to boolean. Zero is false, non-zero is true.
Converts a string into a date-time value.
Declares a variable. Required first step before any other variable action.
Rounds a number to a given number of decimal places.
Returns true when any expression is true.