Convert datetime to text Action(Power Automate Desktop)

08/27/2023

Japanese version.

This Action converts a date/time into a variable of text type.

This is the counterpart to "Convert text to datetime" and is similar to Excel's TEXT function.

How to use

Drag Convert datetime to text from Text onto the Workspace.

Set parameters.

Parameters

Datetime to convert

Specify the target date/time.

Format to use

Select whether the "datetime to convert" is the default format (Standard) or any date format (Custom).

Standard

The following table shows the choices and an example of specifying 11:30:45 on 5/10/2023.

Select Example Results
Short date05/10/2023
Long dateWednesday, May, 10, 2023
Short time11:30 PM
Long time11:30:45 PM
Full datetime(short time)Wednesday, May, 10, 2023 11:30 PM
Full datetime(long time)Wednesday, May, 10, 2023 11:30:45 PM
General datetime(short time)05/10/2023 11:30 PM
General datetime(long time)05/10/2023 11:30:45 PM
Sortable datetime2023-05-10T12:30:45
Custom

Specify for any date format.

Specify the date in "yyyyMMMdd" and the time in "hhmmss".

Variables produced

FormattedDateTime

The resulting text of the conversion is stored.

For those who want to learn Power Automate Desktop 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 Desktop to streamline your workflow.

Links

Text Actions

Examples of Use

How to deal with the case where the specified file already exists.

How to truncate the time portion from the date and time.

How to put today's date in a folder name or file name.