Timestamp incorrect format

(0) Share

Report

Posted on by Skybluekid

262

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?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-peijunz-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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:
In excel file the date with format dd/MM/yy was successfully updated:

Best regards,
Sylvia

Was this reply helpful? Yes No
Skybluekid 262 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-peijunz-msft

I have created a variable "Timestamp", which I have used the expression Addhours
Which I then put into Update Row

Then the output is

Was this reply helpful? Yes No
Verified answer

v-peijunz-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Skybluekid 262 on at

Like (0)

Report
Copy link

Link copied!

Thank you it has worked.

Was this reply helpful? Yes No