Answered

Sharepoint - Send mail if no new files added to sharepoint

(0) Share

Report

Posted on by NJessen

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.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

Pstork1 69,490 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
NJessen 31 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Pstork1 69,490 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
NJessen 31 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Pstork1 69,490 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The error is about the length() statement in the condition. Re-do that one to get rid of the error.

Was this reply helpful? Yes No