How to handle date and time data.(Power Automate Cloud flows)

Japanese version.

Dates have numeric content in Excel, while many programming languages have a data type for dates and times, Power Automate handles dates as strings.

In addition, dates are in UTC (Universal Coordinated Time), which must be changed if they are to be handled in other locales.

Set the current time in a variable.

Specify the "variable type" as a string and the "value" as an expression as shown below.

Use the convertTimeZone and utcNow functions.

convertTimeZone(utcNow(), 'UTC', 'TimeZone')

Dynamic content, such as timestamps for triggers, is also If they are to be used in some form, it is easier to handle them by storing them in variables.

Format conversion.

For example, on August 9, 2020 at 22:30:40, the data would look like this


As it is very difficult to understand when displayed as it is, the format conversion is necessary with the following expression.

Use the formatDateTime function.

formatDateTime(variables('variable name'), 'format')

Please change the red part in each case.

For those who want to learn Power Automate Cloud flow effectively

The information on this site is now available in an easy-to-read e-book format.

Or Kindle Unlimited (unlimited reading).

You willl discover how to about basic operations.

By the end of this book, you will be equipped with the knowledge you need to use Power Automate Cloud flow to streamline your workflow.


Introduction(Power Automate Cloud flows)