cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper V
Helper V

Changing the format of the date

Hi !

 

 

I have set a convert time zone as the time was an hour out which has now been resolved but now im getting the date format incorrect. 

 

so at the in its mm/dd/yyyy but I want it as dd/mm/yyyy

 

Screenshot 2020-03-25 at 1.14.25 PM.pngScreenshot 2020-03-25 at 1.14.49 PM.png

 

Please help!

1 ACCEPTED SOLUTION

Accepted Solutions

Hi!

My suggestion is, leave 'format string' as

Flow_ConverTimeZone.png

Then use expression based on formatDateTime() on the email body

 

formatDateTime(body('Converted_time_zone'), 'dd/MM/yyyy H:mm')

All possible formats here

https://docs.microsoft.com/es-es/dotnet/standard/base-types/custom-date-and-time-format-strings

 

Or, as @RobElliott suggests, in the Format string field, scroll down to the bottom of the dropdown list, select custom value and type in 

dd/MM/yyyy H:mm

 Havent tested this second approach, but eems easier than mine

 

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

5 REPLIES 5
Super User III
Super User III

Hi

Didn't you find any suitable format by playing with 'format string' options?

Flow_ConverTimeZone2.png

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Super User
Super User

@AB21 in the Format string field, scroll down to the bottom of the dropdown list, select custom value and type in dd/MM/yyyy. 

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Hi @RobElliott 

 

Thank you hat about the time would I need to state a formate for the time in the custom value too? if so what would i have to put if I just want the time to be for example 1:45

 

 

Thanks in advance 

Hi @efialttes 

 

There isnt a suitable one

 

I need DD/MM/YYYY with short time

 

Is this possible as a custom value I know @RobElliott  mentioned putting DD/MM/YYYY which works but I also need the short time to go along with it. 

 

Please help!

Hi!

My suggestion is, leave 'format string' as

Flow_ConverTimeZone.png

Then use expression based on formatDateTime() on the email body

 

formatDateTime(body('Converted_time_zone'), 'dd/MM/yyyy H:mm')

All possible formats here

https://docs.microsoft.com/es-es/dotnet/standard/base-types/custom-date-and-time-format-strings

 

Or, as @RobElliott suggests, in the Format string field, scroll down to the bottom of the dropdown list, select custom value and type in 

dd/MM/yyyy H:mm

 Havent tested this second approach, but eems easier than mine

 

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (5,020)