Power Automate: startOfDay function
Resets a timestamp to midnight.
Power Automate expressions are where a lot of the real magic happens, and this is my reference for the functions that power them. When the point-and-click designer runs out of road, a well-placed expression gets you exactly what you need. I document the everyday date and time helpers like the "addDays" function, the "addHours" function, and the "addMinutes" function, along with the more flexible "addToTime" function for shifting timestamps. I cover math with the "add" function, logic with the "and" function, and data shaping with the "addProperty" function and the "array" function. Need to convert data types? The "base64ToBinary" function gets its own walkthrough, and the "action" and "actions" functions let you reach into earlier steps. Every entry gives you the syntax, the parameters, the return value, a practical example, and the edge cases that catch people out.
Resets a timestamp to midnight.
Returns the last element of an array or the last character of a string.
Returns an action's full results inside an expression. The mechanism behind Dynamic Content.
Returns the current value of a variable.
Returns the domain name from a URL. Strips protocol, path, and query string.
Returns the position of the Nth occurrence of a substring. -1 if not found.
Converts a number to currency, percentage, or a custom format with locale support.
Returns the trigger's body as JSON. Use ?['key'] to reach a single value.
Generates a unique hexadecimal identifier.
Negates a boolean value. Strict boolean input required.
Checks if a string begins with specific text. Case-insensitive, space-sensitive.
Converts strings and integers to floating-point numbers.