Is it possible to set up a flow where I check a sharepoint folder for new files, based on amount of days since last file.
So for example: Check if there has been added any new files to a specific folder in the last 8 days.
If there has don't send email.
If there hasn't send email.
Thanks in advance.
The error is about the length() statement in the condition. Re-do that one to get rid of the error.
Thank you for helping!
I'm now getting an error message.
I've tried posting exactly what you had in filter query in, but I get the same error.
I've tried all the things I could come up with in the query filed but nothing worked.
I also tried writing "modified ge 'inserted add days formula' - gave same error
Your filter query is incorrect in the get files properties only. It needs to include the name of the field and the operation. Like this: Make sure to add the single quotes around the AddDays() function.
You should also have a condition to test the size of the array returned to see if you need to send the email or not.
Thank you for your reply!
This makes sense, however I cannot manage to make it work.
This is my attempt: I can click test but I never seem to get any mail.
I'd like the mail to be sent in case the folder has no files updated in the last 7 days.
If any file has been updated in the last 7 days do nothing.
Sorry for the inconvenience.
1) Build a flow with a recurrence trigger to run at whatever interval you want to check for new files
2) Get all the files in a folder where the created date is greater than AddDays(UTCNow(), -8)
3) If the array returned has a length of 0 (no files found) send the email.
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2