Get Items filter is not working for me when I tried to used it with a date column
I have a sharepoint list that have 11.000 row, I have an EndDate column as Date but the equal operator is not working
EndDate eq ‘2021-3-2’ is not working
EndDate ge ‘2021-3-2’ and EndDate le ‘2021-3-2’ is not working
EndDate gt '2021-3-1' and EndDate lt '2020-3-3' is giving me the rows which are End Date: 2020-3-1 and 2020-3-2 together (that’s confusing 🙂 )
I created a test list with 3 line - EndDate eq ‘2021-3-2’ is working there it’s really interesting column setting is same, sharepoint lists are same just the line count is different
EndDate column setting; Date only, standart
Get Items settings -> pagination enabled
How can I run this flow healthy ?
Can you use an expression like the below?
EndDate gt '2021-02-22T12:00:00z' and EndDate lt '2021-03-01T12:00:00z'
Thank your for the idea Prasad, but didnt worked
Tried EndDate gt '2021-03-01T12:00:00z' and EndDate lt '2021-03-03T12:00:00z'
But I got 2021-03-01 and 2021-03-02
but it got me thinking, I export the data to excel and checked, and it gave me times I have 2021-03-01 11:00, but why ? my list doesnt contain the time :s
what is the data type of the column? can you check? Is it DateTime OR was it earlier DateTime and now date?
When do you say it did not work what do you mean? Are you not expecting 1st March and 3rd march?
If yes, may be you can change time to 11: 50 p.m. EndDate gt '2021-03-01T23:59:00z'
Check out how to claim yours today!
Check out new user group experience and if you are a leader please create your group
Test your skills now with the Cloud Skill Challenge.