SharePoint “Get files (properties only)” OData filter on Created stopped working (previously fine)

(0) Share

Report

Posted on by CU16010044-0

I have multiple Power Automate flows using Get files (properties only) with an OData filter on the Created field.

Example:

This returns zero results, even though:

Files exist with Created timestamps after this date
substringof('FolderName', FileDirRef) alone returns many items
The date is hard-coded in valid ISO 8601 format
This logic worked for months and recently stopped
Older flows using the same pattern are now also broken

Is there a known regression or recent change in SharePoint OData filtering for the Created field when using Power Automate?

Categories:

Power Automate Desktop

I have the same question (1)

All responses (3)

Answers (0)

Sort by

Riyaz_riz11 4,204 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

SharePoint OData Created ge recently changed ---use dynamic expression instead of hard-coded date.

Replace '2026-01-15T00:00:00Z' with formatDateTime('2026-01-15','yyyy-MM-ddTHH:mm:ssZ') or use Created ge @{formatDateTime(addDays(utcNow(),-1),'yyyy-MM-ddTHH:mm:ssZ')}.

Recent SharePoint update requires exact UTC timezone format and dynamic dates.

Test with single condition first (Created ge '2026-01-15T00:00:00Z' alone), then add folder filter.

Clear flow cache and recreate connection if still broken.

If I have answered your question, please mark it as the preferred solution ✅ . If you like my response, please give it a Thumbs Up 👍.
Regards,
Riyaz

Was this reply helpful? Yes No
Suggested answer

abm abm 32,985 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

You need the below ODATA filter.

FileLeafRef eq 'invoices' and FSObjType eq 1 and Created ge '2026-01-15T00:00:00Z'

FSObjType is the folder name if you are trageting to filter only the folders.

You can use with out that as well then it look for folders and files.

FileLeafRef eq 'invoices' and Created ge '2026-01-15T00:00:00Z'

Let me know how it goes.

Was this reply helpful? Yes No
CU16010044-0 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Riyaz / abm,

Thanks for the suggestions. I’ve tested this thoroughly and wanted to share concrete outputs.

I’m using Get files (properties only) on a document library. Files exist that show Created = about an hour ago in the SharePoint UI.

However, even with a wide window and no folder constraint, the following filter still returns an empty array:

Created ge '2026-01-18T00:56:47Z' and FSObjType eq 0

The resolved filter in the connector output is:

$filter=Created ge '2026-01-18T00:56:47Z'

and the response body is:

"value": []

I also recreated the SharePoint connection, removed/re-added the action, and tested static dates as well as dynamic expressions.

Since the UI clearly shows files with Created timestamps inside this range, is this a known regression with Created filtering in Get files (properties only), or is there another supported field/property for filtering by file creation time in this action?

Was this reply helpful? Yes No