Power Platform Community Forum Thread Details

Hello!

What is the ODATA filter to return files created after a specific date?

I am struggling to find the right syntax. Is there a reference? Pity that Microsoft does not offer an autocomplete!

Thanks

Categories:

Building flows

@PowerAutomate3

To return the files that are created after a specific date you can use the filter

Created ge 'DateValue'

Usually all the dates in SharePoint are stored in UTC time, so when you are trying to do a comparison you must ensure that the date value that you are specifying is according to the UTC time and the date time value must be in format yyyy-MM-ddThh:mm:ssZ

to format datetime values in Power Automate you can make use of the format date time expression

formatDateTime('datetime value to be formatted','format')

Ex: Consider I want to retrieve all the files from SharePoint document library that are created after 10th October 2021

Filter query for the above statement would look as follows

Created ge '2021-10-10T00:00:00Z' (you can insert date value either manually or dynamically using Power Automate expressions)