cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dual Super User III
Dual Super User III

ODATA to filter Get Items Sharepoint: DateTime values

Hi all 

I am trying to get items from a Sharepoint list matching a specific rule, so a date from a column called 'LastHistoryUpdate' shall be equal or greater than 1st of October.

 

I've tried with the following ODATA expressions, however, Flow does not include in the response the only item from the List where 'LastHistoryUpdate' is set to 1st of October (2018-10-01 as shown in the screenshot).

 

 
LastHistoryUpdate ge '2018-10-01T00:00:00.0000000Z'
 
LastHistoryUpdate ge datetime'2018-10-01T00:00:00.0000000Z'

 

Sure there must be a workaround by using Filter Array instead, but due to efficiency reasons I need to solve it via ODATA filter (as explained at https://docs.microsoft.com/en-us/previous-versions/dynamicsnav-2016/hh169248(v=nav.90)

 

Suggestions are welcome!

 

ODATA_filure.png

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Hi @efialttes,

 

I have made a test on my side and don't have the issue that you mentioned.

 

The expression LastHistoryUpdate ge '2018-10-01T00:00:00.0000000Z'  is worked on my side.

 

The screenshot of my flow as below:

Capture.PNG

 

The flow would run successfully as below:

Capture.PNG

 

Please make sure you list have items that meet the condition in the Filter Query.

 

 

Best regards,

Alice

View solution in original post

1 REPLY 1
Community Support
Community Support

Hi @efialttes,

 

I have made a test on my side and don't have the issue that you mentioned.

 

The expression LastHistoryUpdate ge '2018-10-01T00:00:00.0000000Z'  is worked on my side.

 

The screenshot of my flow as below:

Capture.PNG

 

The flow would run successfully as below:

Capture.PNG

 

Please make sure you list have items that meet the condition in the Filter Query.

 

 

Best regards,

Alice

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Top Kudoed Authors
Users online (13,287)