How to display date and time in specific locale in Power Automate

Hello everyone and welcome to my blog. In today’s blog I will show how you can display date and time in a specific locale in Power Automate.

Let’s get started. Power Automate has this wonderful formatDateTime function which can be used to display date and time values in various formats.

Today’s date is 10th of October, 2023. I am using the below expression to format my date.

formatDateTime(utcNow(), 'dd-MMMM-yyyy')

When I run the flow, I get the below output.

That’s great But what if my requirement is to display the value based on locale. For example – If I want to display in French or German, how do I accomplish that?

Quite unknown to many, formatDateTime has a third parameter where you can specify the locale. For example – If I want to display the above date in French locale, I can use the below formula.

formatDateTime(utcNow(), 'dd-MMMM-yyyy', 'fr-fr')

Now when we run the flow, we get the following output.

Following is the output for German language.

formatDateTime(utcNow(), 'dd-MMMM-yyyy', 'de-de')

I hope this helped. If you have liked the post and if this post has helped you, please subscribe to my blog.

Debajit Dutta