cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tahag
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 ?

 

3 REPLIES 3
PrasadAthalye
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

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

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

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (57,289)