Skip to main content

Notifications

Power Automate - Building Flows
Answered

Timestamp incorrect format

(0) ShareShare
ReportReport
Posted on by 252

Hi All,

 

I have a flow that puts a time stamp in an excel table.  I have formatted my timestamp, in the flow as  dd-MM-yy HH:mm.  But when it is placed in the sheet, it comes out as mm-dd-yy HH:mm.  I have checked the value in the flow and it shows dd-mm-yy HH-mm and I have checked the regional settings to be correct.

 

Any thoughts?

 

 

  • Skybluekid Profile Picture
    Skybluekid 252 on at
    Re: Timestamp incorrect format

    Thank you it has worked.

  • Verified answer
    Re: Timestamp incorrect format

    Hi @Skybluekid 

     

    Could you please try to format the date again in "Add a row" action?

    i.e., 

    formatDateTime(variable,'dd/MM/yy HH:mm')

     

    Best regards,

    Sylvia

  • Skybluekid Profile Picture
    Skybluekid 252 on at
    Re: Timestamp incorrect format

    Hi @v-peijunz-msft 

     

    I have created a variable "Timestamp", which I have used the expression Addhours

    Skybluekid_0-1683809465284.png

    Which I then put into Update Row

    Skybluekid_4-1683812924291.png

     

    Then the output is 

    Skybluekid_5-1683812945825.png

     

     

  • Re: Timestamp incorrect format

    Hi @Skybluekid 

     

    How did you format the timestamp from flow to excel?

    It would be clearer if you could share a screenshot of your flow and excel.

     

    Based on your description, I have made a simple test:

    vpeijunzmsft_0-1683783839812.png

    In excel file the date with format dd/MM/yy was successfully updated:

    vpeijunzmsft_1-1683783910524.png

     

    Best regards,

    Sylvia

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard