cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
elaaadani
Helper V
Helper V

Sharepoint get items filter

Hello, good afternoon.
I have a query
I am dealing with error when viewing 5000 data with get items connector.
I would like to know how I can use the filters for a column that has only one date in simple date format.
I have tried with putting the name of the column +eq+ the data I need, but I can't get it to do it.

'Modified' eq '28/04/2017'

elaaadani_1-1618872103135.png

 

 


Please help me !

1 ACCEPTED SOLUTION

Accepted Solutions
henkenTech
Resolver II
Resolver II

It just came to me:

 

Modified is a timestamp with a time value, so if you are looking for a particular date, you’ll have to sandwich the timestamp between two values using an “and” operator. "2021-04-28" would literally be 00:00 on that date and your Modified column timestamp is not equal to that.

 

e.g.: for e.g. 2021-04-19 it would be: 

 

Modified ge '2021-04-19' and Modified lt '2021-04-20'

 

 

that wound filter any value between 00:00 on the 19th and 00:00 on the 20th.

 

Just tested this and works on my side 

View solution in original post

4 REPLIES 4
henkenTech
Resolver II
Resolver II

Try formatting the date as yyyy-MM-dd instead and no ‘ around Modified. That should do it 👍🏻

 

Modified eq '2017-04-28'

Thanks @henkenTech , I did it this way but apparently, it does not take the column, since I get an empty query.

"value":[]}}


I don't call sharepoint before as to get the column, only in get elements, as I am testing to handle this threshold. only in get items, as I am testing to handle this threshold.

henkenTech
Resolver II
Resolver II

It just came to me:

 

Modified is a timestamp with a time value, so if you are looking for a particular date, you’ll have to sandwich the timestamp between two values using an “and” operator. "2021-04-28" would literally be 00:00 on that date and your Modified column timestamp is not equal to that.

 

e.g.: for e.g. 2021-04-19 it would be: 

 

Modified ge '2021-04-19' and Modified lt '2021-04-20'

 

 

that wound filter any value between 00:00 on the 19th and 00:00 on the 20th.

 

Just tested this and works on my side 

Thank you for your kindness @henkenTech 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (5,062)