Flow
Power Automate,  Power Platform

Power Automate | Flow : Standard Date & Time

When you check date format in flow, you will see this kind of date format : yyyy-MM-ddThh:mm:ssZ. Actually microsoft flow gives you each date in this format. But some time we need better date format for visibility or understanding.

In flow, We use following expression for date format-

formatDateTime(utcnow(),’Date String’)

Replace Date String with one of the following letter and you will get desire result in mentioned format.

  • d :08/17/2000
  • D :Thursday, August 17, 2000
  • f :Thursday, August 17, 2000 16:32
  • F :Thursday, August 17, 2000 16:32:32
  • g :08/17/2000 16:32
  • G :08/17/2000 16:32:32
  • m :August 17
  • r :Thu, 17 Aug 2000 23:32:32 GMT
  • s :2000-08-17T16:32:32
  • t :16:32
  • T :16:32:32
  • u :2000-08-17 23:32:32Z
  • U :Thursday, August 17, 2000 23:32:32
  • y :August, 2000
  • dddd, MMMM dd yyyy :Thursday, August 17 2000
  • ddd, MMM d “‘”yy :Thu, Aug 17 ’00
  • dddd, MMMM dd :Thursday, August 17
  • M/yy :8/00
  • dd-MM-yy :17-08-00

Additional inputs- In case you need to format current date and time, you can simply pass your string inside UTCNOW() function to get desire result. Example- utcnow(‘yyyy-MM-dd’)

-Gopenly Team

Leave a Reply