Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities - Lets Get Started!
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Convert time from dd/M...
Power Automate - Building Flows
Answered

Convert time from dd/MM/yy to yyyy-MM-dd

Like (0) ShareShare
ReportReport
Posted on 11 Jun 2021 06:24:39 by PMM 14

Hello,

 

i stuck on this.

i have date 01/07/2021 dd/MM/yyyy i need convert it to 2021-07-01.

 

whatever commands or time converter i am using i get 2021-01-07 

convertTimeZone(outputs('Compose_4'),'UTC','Romance Standard Time','yyyy-MM-dd')
formatDateTime(outputs('Compose_4'),'yyyy-MM-dd')
 
any tips how convert it?
 
thank you
  • PMM Profile Picture
    PMM 14 on 11 Jun 2021 at 13:30:55
    Re: Convert time from dd/MM/yy to yyyy-MM-dd

    Hello,

     

    that worked. amazing

     

    Thank you

  • Verified answer
    Expiscornovus Profile Picture
    Expiscornovus 31,732 Most Valuable Professional on 11 Jun 2021 at 13:07:37
    Re: Convert time from dd/MM/yy to yyyy-MM-dd

    Hi @PMM,

     

    Sorry, I misread your current format. It is actually the 1st of July and not the 07th of January, my bad 😁

     

    Try this instead:

    formatdatetime(formatdateTime(split(outputs('Html_to_text_2')?['body'], '_')[3], 'dd/MM/yyyy'), 'yyyy-MM-dd')

     

  • PMM Profile Picture
    PMM 14 on 11 Jun 2021 at 11:49:22
    Re: Convert time from dd/MM/yy to yyyy-MM-dd

    Yes it is from same task 🙂

     

    but still i get yyyy-dd-MM

    PMM_0-1623412152410.png

     

  • Expiscornovus Profile Picture
    Expiscornovus 31,732 Most Valuable Professional on 11 Jun 2021 at 08:17:57
    Re: Convert time from dd/MM/yy to yyyy-MM-dd

    Hi @PMM,

     

    Just to double check. Is this still the date you are extracting from the subject of an e-mail.

     

    Discussed in this thread:

    https://powerusers.microsoft.com/t5/Building-Flows/Extract-date-from-outlook-subject-or-body/m-p/949100

     

    If so, try and use this directly after your split action:

    formatdateTime(split(outputs('Html_to_text_2')?['body'], '_')[3], 'yyyy-MM-dd')

     

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

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard >

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans