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

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 

View solution in original post

Thank you for your kindness @henkenTech 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,090)