Get date from forms and it is in US format mm/dd/yyyy and I need it in UK format dd/mm/yyyy

[Liron]

I have a flow that pulls information from a form submission. The date entries that pull are in US format mm/dd/yyyy and I need them in UK format dd/mm/yyyy. Is there anyway to do this?

[CFernandes]

Heey @Liron 

You use the Formula 

formatDateTime('<your-value>', 'dd/MM/yyyy')

For details see - https://learn.microsoft.com/en-us/troubleshoot/power-platform/power-automate/how-to-customize-or-for...

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

[Liron]

Like this? If so, do I have to include this formula every time the date is mentioned?

[CFernandes · Accepted solution]

Hey @Liron 

You need to get rid of the<> and create an expression... Please see screenshot below - 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

[Liron]

This does not work, the flow runs but the date format is not being converted. Do I need more steps?

[CFernandes]

Hey @Liron I assume you are using the date in the Send to Email... If yes, use the "Compose 2" which hold the formatted date in the Send to email action...

[Liron]

Ok, how do I add formatting for the 'end date' also? Just add 2 more composes to the beginning?

[CFernandes · Accepted solution]

@Liron - Yes, or directly add the dynamic value...

So is the problem resolved? If this reply has answered your question or solved your issue, please mark this question as answered.