Unanswered

Filter all files / folders inside SharePoint site that are last modified 2+months

(0) Share

Report

Posted on by esfeir44

Hello,

I am working on a flow that looks into a sharepoint site documents, iterate through all folders and subfolders to get me the files that last modified 2+months ago.

Attached is the flow I built, seems to be working fine on small sites, but I have a site that contains around 1TB of data and 5000+ files, the flow keeps running indefinitely, left it for 40 hours last time with no luck, had to cancel it.

Any idea ? Attached is the flow.

I am using this when comparing in the condition:

formateDateTime(addToTime(utcNow(), -2,'Month'),'yyy-MM')

Categories:

Using flows

part 2.png

part 1.png

I have the same question (0)

All responses (2)

Answers (0)

AndreasN 318 Super User 2024 Season 1 on at

Like (0)

Report

Place the filter query on the first "get files", so the flow doesn't have to iterate through all 5000+ files multiple times.

Filter query expression:
Modified eq 'formateDateTime(addToTime(utcNow(), -2,'Month'),'yyy-MM')'

This should smoothen the flow out dramatically, the only files you will get in your "get files" output, are the ones within the past two months, everything is filtered away at the start.

Was this reply helpful? Yes No
esfeir44 2 on at

Like (0)

Report

Hello!

thank you for this! Unfortunately this does not help, as the main folder date is old, but there are some subfolders inside that are new, that way, the script does not cycle through the nested items 😕

Was this reply helpful? Yes No