Filtering Arrays for Date Match

(0) Share

Report

Posted on by bsprakermg

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.

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

Re: Filtering Arrays for Date Match

Update your List Items in a table action to return dates in ISO 8601 format.

Was this reply helpful? Yes No
bsprakermg 20 on at

Like (0)

Report

Re: Filtering Arrays for Date Match

Yes! It was that simple, thank you!!

Was this reply helpful? Yes No