Hello! I am getting this error: The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@contains(formatDateTime(item()?['Date Opened'], 'MM-dd-yyyy'), triggerBody()['key-button-date'])' failed: 'In function 'formatDateTime', the value provided for date time string '45203' was not valid. The datetime string must match ISO 8601 format.'.
My goal is to only have the HTML created with rows where "Date Opened" = the date triggered. I tried this formula, but am still having issues:
formatDateTime(item()?['Date Opened'],'MM-dd-yyyy')
Below are the Excel table and screenshots of the failed flow.
