Showing results for 
Search instead for 
Did you mean: 
New Member

Get Items Filter by Date is not working properly

Hello Everyone,


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 ?


Super User
Super User

Can you use an expression like the below?


EndDate gt '2021-02-22T12:00:00z' and EndDate lt '2021-03-01T12:00:00z'


Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

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' 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

Helpful resources

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (42,793)