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')
Solved! Go to 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?
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?
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
72 | |
27 | |
22 | |
15 | |
13 |
User | Count |
---|---|
141 | |
43 | |
42 | |
34 | |
30 |