This video tutorial shows how to work with and convert Dates in Microsoft Power Automate. There are three different DateTime formats in Power Automate. One in the native Dataverse format (digits and a T and Z), one in an Excel Online format (e.g. five digits), and one in a custom format (e.g. a UK/US format). You’ll learn how to customize and convert your date just as you want.
VIDEOS FOR YOU:
🎥 Full Power Automate Course: https://youtube.com/playlist?list=PLXXz88_TPiHqGlJoWhBDCAxZ9m1N_jsB6
LINKS:
🔹 My Power Automate SoMe Groups: https://youtu.be/_QRI-Yo2h8U
🔹 Standard date and time format strings: https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-date-and-time-format-strings
🔹 Custom date and time format strings: https://docs.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings
FOLLOW ME:
👨👩👧👦 Discord: https://discord.gg/pJEXZNTCzs
💼 LinkedIn: https://www.linkedin.com/in/andersjensenorg
📸 Instagram: https://www.instagram.com/andersjensenorg
👨 Facebook: https://www.facebook.com/andersjensenorg
🐦 Twitter: https://twitter.com/andersjensenorg
💌 Email Newsletter: https://andersjensen.org/email-newsletter
MY GEAR (Amazon affiliate):
🖥️ My monitor
Samsung 49-inch CRG9 Curved Monitor = https://geni.us/MDpejc
– If you are buying this, I can recommend the Mi Monitor Light Bar = https://geni.us/3Wwad
⌨️ Keyboard
Logitech Backlit Keyboard = https://geni.us/aT0ltB
📹 Camera
Sony FDRAX53-B = https://geni.us/gnAE
Lenovo 500 Full HD Webcam = https://geni.us/cZS4
🎤 Microphone
Rode Wireless GO II = https://geni.us/iqy0g6H
Blue Yeti = https://geni.us/dDBjCB
0:00 Intro
Converting Date and times in Power Automate is very easy, as with everything in Power Automate.
0:53 The Dataverse date and time
The Dataverse (e.g. Power Apps, Power BI or Power Automate) generates a long date format with a T and Z in it. We can very easily convert it to a nice-looking format e.g. the MM/dd/yyyy (US) or the dd/MM/yyyy (UK) format. Use the FormatDateTime Function combined with either the .NET standard or custom date and time formats.
11:00 The 5 digit date and time format (from Excel online)
The 5 digit date and time format in Power Automate usually come from Excel Online. The 5 digits represent days after the 30th of December 1899.
18:59 Custom date formats
Convert a US date (MM/dd/yyyy) to a UK date (dd/MM/yyyy) by using a Split (to an array) and Concat function. We use this approach to work with all custom dates in Power Automate.
