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'
Please help me !
Solved! Go to Solution.
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
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.
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
User | Count |
---|---|
89 | |
44 | |
21 | |
18 | |
16 |
User | Count |
---|---|
133 | |
49 | |
42 | |
36 | |
28 |