Power Automate Date Recipes

I use this mostly to format notification emails.

Using formatDateTime() provides a value based in the UTC timezone. Therefor, I start with convertFromUtc().

Code

These are the most common patterns I use.

Example 1 - short date

convertFromUtc(<Date Value>,'Eastern Standard Time','d')

Output: 9/25/2023

Example 2 - short time

convertFromUtc(<Date Value>,'Eastern Standard Time','g')

Output: 9/25/2023 2:20 PM

US timezones

• Eastern Standard Time
• Central Standard Time
• Mountain Standard Time
• Pacific Standard Time

References

• convertFromUtc()
• Custom date and time format strings
• formatDateTime()
• Standard date and time format strings
• Time Zone IDs (Compact 2013)

---