cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Piter_D
Responsive Resident
Responsive Resident

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

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

Piter_D_0-1643625648297.png

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')

1 ACCEPTED SOLUTION

Accepted Solutions
Expiscornovus
Super User
Super User

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?



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


View solution in original post

1 REPLY 1
Expiscornovus
Super User
Super User

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?



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,378)