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?
Thank you it has worked.
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
I have created a variable "Timestamp", which I have used the expression Addhours
Which I then put into Update Row
Then the output is
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