Power Automate ParseDateTime Function Explained

Power Automate ParseDateTime Function

The Power Automate parseDateTime function lets you convert any string into date in ISO format. The benefit of converting the date string to ISO date is that you can use the date in other Power Automate date functions.

So whenever you have an uncommon date format of some data source, just convert it to an ISO date with the parseDateTime function.

Let’s take a look at the function and how to use it!

Power Automate ParseDateTime Function

Power Automate parseDateTime

Returns the timestamp from a string that contains a timestamp.

Syntax

parseDateTime('<timestamp>', '<locale>'?, '<format>'?)

Input parameters

  • timestamp (mandatory): The timestamp string that needs to be parsed. (Converted to a date.)
  • locale (optional): The Locale to use. (default = en-us)
  • format (optional): A format string to define the output format. (For details, take a look at: How to format date and time in Power Automate)

Return value

  • An ISO date, if the parsing is successful.

Power Automate ParseDateTime Expression Example

Let’s imagine you have a date in this format ‘2022_12_24_01_33_58’, maybe of a filename. No you can parse the date, by providing a custom Power Automate date format.

parseDateTime('2022_12_24_01_33_58','en-US','yyyy_MM_dd_hh_mm_ss')
=> 2022-12-24T01:33:58.0000000

Leave a Comment

Your email address will not be published.