Share
ReportMy flow takes the date ('receviedDateTime') of an email into a shared inbox. Then uses formatdatetime to convert it to a date format dd/MM/yyyy. The output is then added to a cell in an Excel sheet. The output is a text string '01/01/2022' (rather than numerical value for a date Excel uses).
This worked fine until 3 May, but now the output that appears in excel is numerical (44656) and it is reading the day date in reverse. i.e. it the actual date (and the date that appears in the run history) is 04/05/2022 (dd/mm/yyyy), but the number that appears in excel is for 05/04/2022 (dd/mm/yyyy).
See pics below, apologies that the orders of pics is a bit garbled, but hopefully you get the idea!
All I want is to get the date the email was sent into the Excel cell in dd/mm/yyyy format. Any help or suggestions much appreciated!
All responses (
Answers (
425
