formatDateTime generator
Dates in Power Automate arrive as UTC timestamps like 2026-08-14T13:05:00Z, which nobody wants to read in an email. Pick where the date comes from and how it should look, optionally convert it out of UTC with convertTimeZone, and copy the finished expression.
Date Formatter
Pick a source and a format to get the formatDateTime expression.
How to use it
- Choose the date source, or enter your own expression.
- Choose a format, or type a custom format string.
- To convert out of UTC, enter a Windows time zone name such as
GMT Standard Time. - Copy the expression into the Expression tab of the dynamic content panel.
Nothing you type here is sent anywhere. The tool runs entirely in your browser.
Format strings, with examples
Power Automate uses .NET date format strings. Each output below is for Friday 14 August 2026 at 13:05 UTC.
| Format string | Output |
|---|---|
dd/MM/yyyy | 14/08/2026 |
MM/dd/yyyy | 08/14/2026 |
yyyy-MM-dd | 2026-08-14 |
d MMMM yyyy | 14 August 2026 |
dddd, d MMMM yyyy | Friday, 14 August 2026 |
ddd d MMM | Fri 14 Aug |
MMMM yyyy | August 2026 |
HH:mm | 13:05 |
hh:mm tt | 01:05 PM |
h:mm tt | 1:05 PM |
dd/MM/yyyy HH:mm | 14/08/2026 13:05 |
Letter case matters. MM is the month and mm is minutes, so dd/mm/yyyy gives 14/05/2026. HH is the 24-hour clock and hh the 12-hour one.
Related expressions
| Expression | What it does |
|---|---|
utcNow('dd/MM/yyyy') | Formats the current time directly, without formatDateTime |
formatDateTime(utcNow(), 'dddd d MMMM', 'fr-FR') | Writes day and month names in another language, here vendredi 14 août |
parseDateTime('14/08/2026', 'en-GB', 'dd/MM/yyyy') | Turns text such as a date typed into a form into a timestamp you can format or compare |
All of these work in UTC. For UK or other local time, set a time zone in the generator above, which wraps the date in convertTimeZone.
More free tools
Power Automate expression builder
Pick a function, fill in the values, copy a working expression.
Trigger condition and filter builder
Conditions in, a trigger condition or Power Fx Filter formula out.
SharePoint column formatting generator
Conditional background colour for a list column, as ready-to-paste JSON.
SVG to Power Apps image converter
Paste SVG markup, get a data URI for the Image property.
Parse JSON schema generator
Paste a sample payload, get the schema for a Parse JSON action.
Parse JSON schema loosener
Fix Parse JSON failing on null values or missing fields.
Adaptive Card builder
Title, body and Approve / Reject buttons, as card JSON for Teams.
Flow error handler (Try / Catch)
Run-after settings, error expression and alert body for a Try / Catch scope.
HTML email table styler
Column headers and a colour, as an inline-styled email table.
OData filter query builder
Conditions plus $select, $orderby and $top, as an OData query.
FetchXML builder
Dataverse’s own query language, for List rows or Advanced Find.
Microsoft Forms pre-filled link builder
Let an AI fill in a whole form at once, then check it and submit it yourself.
Browse every tool
All the free tools on one page.