web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Changing the format of...
Power Automate
Unanswered

Changing the format of the date

(0) ShareShare
ReportReport
Posted on by

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!

Categories:
I have the same question (0)
  • efialttes Profile Picture
    14,756 on at
    Re: Changing the format of the date

    Hi

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

    Flow_ConverTimeZone2.png

    Hope this helps

  • RobElliott Profile Picture
    10,313 Super User 2025 Season 2 on at
    Re: Changing the format of the date

    @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.

  • AB21 Profile Picture
    on at
    Re: Changing the format of the date

    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 

  • AB21 Profile Picture
    on at
    Re: Changing the format of the date

    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!

  • Verified answer
    efialttes Profile Picture
    14,756 on at
    Re: Changing the format of the date

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard