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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
72 | |
22 | |
17 | |
17 | |
13 |
User | Count |
---|---|
125 | |
34 | |
31 | |
28 | |
26 |