Power Automate: parseDateTime function
Converts a date string into an ISO 8601 timestamp using a locale and optional format. Locale comes second.
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.
Converts a date string into an ISO 8601 timestamp using a locale and optional format. Locale comes second.
Converts a timestamp between two time zones, daylight saving included. Output drops the zone marker.
Returns the current timestamp plus a number of time units. Always counts from UTC now.
Converts a UTC timestamp into a target time zone. Returns a string with no offset or Z marker.
Converts a timestamp from a source time zone to UTC using Windows time zone names.
Checks if a string is an integer.
Extracts a substring by position. Supports negative indices; endIndex is exclusive.
Checks if a string is a floating-point number.
Returns the day of a timestamp as an integer 1-31.
Converts a string to a precise decimal number.
Returns true when the first value is smaller than the second.
Creates an array of consecutive integers from a start and a count.