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
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
14 | |
14 | |
9 | |
7 | |
6 |
User | Count |
---|---|
24 | |
17 | |
10 | |
8 | |
7 |