How to work with Dates in Microsoft Power Automate (Full Tutorial)

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:

LINKS:

FOLLOW ME:

MY GEAR (Amazon affiliate):
🖥️ My monitor

⌨️ Keyboard

📹 Camera

🎤 Microphone

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.

[andersjensenorg]

Did the video help you? You can help me a lot by liking the video then 🙂

[helencronin]

I've spent two days trying to work out how to get today's "day"! First part of your video nailed it. Thank you

[ugurmenekse]

Your points are valid. It's very difficult to understand what you're saying because of the way you explain it. I listen to the video repeatedly and try to predict what you are saying in order to understand. Thank you tho.

[jamescanning]

This is an AMAZING tutorial. This has made my day thank you very much Anders!

[Rulzan]

you're great. Your style is just the best, thank you so much!

[franciscom.paredesarias]

Thank you very much for sharing, how could I condition a date, if today is Monday subtract two days... could it be done with power automate?

[Tycoon]

Absolutely brilliant tutorial, well explained with great detail.

[saihaism]

Thank you very much for a very detailed video, this is very good.

[AutoBots_Siva]

Excellent video😇expecting more tutorial videos in power automate.

[michaelkerwath]

Hi Anders - Your videos are really good and especially also very structured and also super explained.

However, I do not get on with one point. I want to create a CSV from an Excel table and change the date format. When I go through the steps, it works, but when I go to create the CSV table, it does not accept the changed format for the date.

How can I include the changed date format in my CSV?

[nikolaidedenkov]

Great and very clear explanation, thank you!

[indushreeb]

Hi Anders, thanks for the very helpful tutorial. Need some help:) when I used the same expression to manage date from excel sheet I'm getting this error : "Unable to process template language expressions in action 'Compose_2' inputs at line '0' and column '0': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'". How to solve this?

[robh]

Really useful, thank you. I just need to get this to work on a Form to List view as a Calendar!

[ManojKumar-zngf]

Hello, Thanks for the beautiful video! I need to get clarity for a question from you. I have an Excel file with a couple of columns, kept the file in SharePoint location, and with the help of list rows present in a table operation trying to read data from the Excel file with date format as "ISO 061", the output looks like "Joining Date": "2021-01-18T00:00:00.000Z" but I need only the date and month from above value Expected output - "01-18". How do I need to specify the condition in ''Enter custom Value" to get the desired output

[LeandroWilby]

Hi! thanks so much for this tutorial it has been very helpful! I am still having a few issues gettting my flow to work from an excel template, to update a Sharepoint List. Basically, I have been copy/pasting from a source file into the excel template where the table is. But, for some reason, PA continues giving me this error message The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/field_21' is required to be of type 'String/date'. The runtime value '"44998"' to be converted doesn't have the expected format 'String/date'." Any idea what I'm doing wrong?

[rogeryang]

Hi Anders, another amazing lesson from you! Just have a question about date -- I am creating a PAD flow to read from some excel files and write into a master file. One of the columns is date formatted as "dd/MM/yyyy'. The iteration with conditions went smoothly. But after the flow was completed, I found that the date column in the master file was messy with various date formats. Some were "MM/dd/yyyy" and some were "MM/dd/yyyy hh:mm:ss". I simply just want the date column formatted as "dd/MM/yyyy" as the original files. Is there an effective way I can do that? Thanks in advance!

[DS]

Hi. Great video. But the native Microsoft Dataverse GMT timezone is GMT. How do I convert it to my local Timezone?

[chandanchan]

hi am using Microsoft Power automate desktop, according to my requirement i need only date and it should be in date format, am trying to that but am getting date along with that time as well, i dont want time, please help out

[matheusdias]

Hello. I'm from Brazil. I got a doubt... I have 4 date's colomns. How may I do it for all the columns.

I tried this

addDays('1899-12-30', int(items('Aplicar_a_cada')?['INÍCIO'], ['TÉRMINO'], ['TÉRMINO REAL']), 'dd/MM/yyyy')

But gets wrongs.

sorry for my english. Hope u understand.

[mallikarjunjk]

How to get rows when one of its column is blank.? I need to collect the data for which date column is empty. I mean, need data for the goods not yet in our building.