how can i filter sharepoint list by default date in created column

[Piter_D]

Hi, i create flow with to variables where i have the beginning of the day and its end, and i want to filter my sharepoint list by this dates and i get error: BadRequest

in yesterday_start i have: formatDateTime(startOfDay(addDays(utcNow(),-2)),'yyyy-MM-ddT00:00:00Z') and in end i have:

formatDateTime(startOfDay(addDays(utcNow(),-2)),'yyyy-MM-ddT23:59:00Z')

[Expiscornovus · Accepted solution]

Hi @Piter_D,

In OData greater than and less than are written in a different way. Can you try gt instead of > and lt instead of < in your filter query?