Send an email when a file has not been added to a SharePoint folder in a month

[RGP]

Hi everyone

I'm a new Power Automate user so can someone please outline for me how I can create a flow where an email will be sent to me plus others in my organisation when no file has been added to a particular SharePoint folder in the last 31 days. 

Basically, a new Word document which represents meeting minutes from a monthly meeting, should be added to a SharePoint folder each month and I want to know if the minutes (Word document) has not been added to the SharePoint folder, so I only want to know about the exception not the norm.

I don't want to know about modifications to existing documents in that folder, just want to know if a file has not been created in the last month.

As I said I'm a new user to Power Automate and haven't had much practice with how to actually put together a flow so step-by-step instructions would be ideal.

Thanks everyone in advance.

[eric-cheng · Accepted solution]

HI @RGP ,

Try the below flow.

1. Use Get files (properties only) with a filter on the Created column  Use this expression: 

addDays(utcNow(),-31)

2. Store output value to Array

3. Get the length of the Array using this expression:  length(variables('Myarray'))

4. Add a condition to check for the output.  If output is true, send the email and if false, ignore

** You can merge step 3 and 4 together as I added the Compose step to show you the output.  In my case, I had 7 files created within past 31 days **

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

[RGP]

Thank you so much @eric-cheng. You're solution worked and I really appreciate it. You're one clever guy!

[RGP]

Hi Eric

Could you please advise how I can do the above but with one added step/condition.

In addition to the above, I'd like to add a step whereby the flow looks for certain words within a file name because there are many files saved in the folder.

For example, I would like to know if the file name contains the words "Minutes" in it, noting that the filename may also contain other words such as the date. 

Any help would be much appreciated.

Thanks