formatDateTime function(Power Automate Cloud flows)

10/10/2023

Japanese version.

Converts a date and time to text in an arbitrary format.

While parseDateTime is a similar conversion function, formatDateTime mainly converts date and time to text, parseDateTime mainly converts text to date and time.

Spec

formatDateTime('<timestamp>', '<format>', '<locale>')
ArgumentDefaultDescription
timestampRequired fieldSpecifies the date of the conversion source.
Any format other than "yyyy-MM-ddTHH:mm:ss.ffffffffK" will result in an error.
formatyyyy-MM-ddTHH:mm:ss.ffffffffKSpecifies the format of the result. If not specified, the format is "yyyy-MM-ddTHH:mm:ss.ffffffffK" as well as "timestamp".
localeDefault localeSpecifies the locale of the text.
This affects the use of full names (dddd) and abbreviated names (dddd).

How to use

In most cases, it is used in the "value" when initializing or setting variables of type "string".

Click on the "Expression" tab, formatDateTime, and the function name and () will be set in the expression field.

The first argument is the date and time to be converted, and the second is the format.

When using dynamic content or variables, special specifications are required.

Click on the button, and if the display looks like the following, the setting is complete.

You can change the function by clicking this purple icon.

---

Links

Date and time Functions(Power Automate Cloud flows)