How to get a date in 'MM/dd/yyyy' format in Microsoft Power Automate

This video tutorial shows, how to convert a UK (dd/MM/yyyy) date to a US date (MM/dd/yyyy) in Microsoft Power Automate.

You could also watch:

0:05 Present the date use case
We want to convert a UK date to a US date (dd/MM/yyyy to MM/dd/yyyy).

0:40 Create a new flow

0:56 Initialize date variable
Our date variable could come from all sources (Excel, Sharepoint, Outlook mail etc.). In this case we initialize it manually.

1:40 Split our date string
We split the three components in our date (days, months and year). Using the split function we can write an expression, that split our date string. By that we can easily work with it.

3:16 Concate our date elements to a string
After we splitted our string to a list, we can now refer to them and concate them to a new string.

Connect with me:

#powerautomate #microsoft #powerapps

[maaliali]

Hello,
This is a very helpful video. I wanna know how to integrate this to an automatic Birthday email flow ?

[sivaprakasamganesan]

Hi Anders,
Thank you so much for sharing many videos on MS Power Automate / Flows. I am a beginner.
I wanna know how to send out a Birthday Wish automatically by reading from an excel table that has around 300+ names with their respective Birthday in the dd-mmm format. There is no year in that format.
I will schedule this to run every day mid-night and check the entire table for any dd-mmm that matches today's dd-mmm. Also, it should be able to send out multiple emails, if there is more than 1 name having dd-mmm same as today's dd-mmm.

[gerfer]

Thanks, good one - it will be good if you include the expression formula in the description for beginners like me please

[BenSchut-mnri]

Hi Anders, this brought me in the right direction, however in the Initialize variable is a set/fixed date. How would I use this to use a date from the list. I have a field called Effective Date and need that field to be included in an email. Now it used the date that is the variable. Thanks

[dianamgdata]

I have a question, what if I want to get the date of another day that's not today? I mean, I am in Monday 27 but I want the flow to show the date of Monday 20...

[schnubbyy_]

nur mal so, man sieht das Ergebnis nicht, da die Werbung davor steht, schade.

[MehmetDegirmenci]

You entered just a string value. The important question How to get a date from a date column in sharepoint list? This video not responsed this question.