You’re offline. This is a read only version of the page.
Announcements
3
Hi All,
I am writing a Flow for Outlook to Excel - When I flag an email in Outlook it is added as a new row in a Excel sheet. I am capturing Date and Subject in that row.
I am using below expression string,
formatDateTime(triggerBody()?['receivedDateTime'],'dd/MM/yyyy')
For some strange reason - When I flag about 20 emails, about 10 emails date s are captured in wroong format, i.e MM/dd/yyyy (reversed). I peeked in to the code, where Output shows in the correct format i.e dd/MM/yyyy
I could not figure out where is the issue. Kindly advise.
When I read a date field from excel it comes in as a number which is the number of days since 12-30-1899 (30th December 1899).
I am fairly sure that if it is a datetime it comes in as a decimal value (sorry have not needed to decode a datetime).
Anyway, to turn it into a date I use the following
Share
Report
All responses (
Answers (
