February 6, 2022
I have a power automate flow to trigger an email where todays date meets the reminder date contained on the row in the xls file.
The last stage of the process is to create HTML table where there is a record to report.
It has failed with the following error message:
The execution of template action 'Create_HTML_table' failed. The column values could not be evaluated: 'In function 'formatDateTime', the value provided for date time string '45118' was not valid. The datetime string must match ISO 8601 format.'.
When creating the date field we have the expression coded as: formatDateTime(item()['ReminderDate'], 'dd/MM/yyyy')
July 16, 2010
The screenshot and the error don't match. The error is referring to date time string 45118 which is the date 11 July 2023. This date is in the column CPR Expiry Date, not the ReminderDate column, which makes me think it's possible that there is another row in the ReminderDate column that contains the date serial number 45118 in an unformatted state.
Another point, in my step by step guide, in the Create HTML table step, I use this date format:
formatDateTime(item()['Due Date'],'MMM d, yyyy')
Even though my locale uses date format dd/mm/yyyy. I suggest you try the same to see if that resolves the issue.