Unanswered

Get Items filter query no longer returning any values when equaling start date

(0) Share

Report

Posted on by ThankfulforHelp

My flow is no longer returning any values/body of list items that equals to start date (trying to grab items that are 60 days past start date). My list items do equal start date indicated from the filter query but returns "{"body":{"value":[]}}" in the output. It had been working for atleast the past month and randomly stopped working yesterday (the column name is correct in filter query).

Any help is appreciated, thank you!

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

David_MA 12,982 Super User 2025 Season 2 on at

Like (1)

Report

I am surprised that it was working for you. In filter queries the date needs to be in ISO 8601 format. Try updating the expression in your filter to addDays(utcNow(), -60, 'yyyy-MM-dd') instead.

Was this reply helpful? Yes No
ThankfulforHelp 5 on at

Like (1)

Report

Thank you for the response! We actually did have it in the ISO 8601 format. We changed it hoping to try something new in matching the format in the SharePoint list, which didn't help as mentioned is the wrong format so we switched it back. Oddly, the flow started working again today as normal so might have been a Microsoft issue yesterday.

Was this reply helpful? Yes No