If Sharepoint folder is older than X month, notify via outlook mail

[spitzbirne]

We have a SharePoint site where users create folder in the document library to share them. As we expected, they forget to delete them after they are no longer needed.

Therefor we want to create a flow which checks once per month if a folder is older then 4 months and if so, send an email to the creater of the folder.

I'm a total rookie in terms of power automate and only used templates so far 😁 so please keep that in mind while answering

Any help is appreciated!

[MarconettiMarco]

Hello @spitzbirne ,

please follow these steps:

- Trigger: Recurrence 1 per Month:

- add "List Folder" action, from which you'll retrieve all the SP folders in a specific path:

- then add "Get folder metadata putting the Folder ID in File identifier from the previous action (the system will automatically add the Apply to each control):

- then add a "Compose" action in which you have to add the following expression:

formatDateTime(outputs('Get_folder_metadata')?['body/LastModified'],'dd-MM-yyyy')

- then add another "Compose" action in which you have to add the following expression:

formatDateTime(addDays(utcNow(),-120),'dd-MM-yyyy')

- finally add the Condition control in which you have to specify the first "Compose" outputs with the second one. The operator should be "is less than or equal to":

In the Yes branch you can add the "Send an email" action.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

[spitzbirne]

Hello @MarconettiMarco 

many thanks for your reply. I just followed your steps to rebuild the flow and tested it with a "send an email" with me as receiver action as you said.

80% of my question is solved. 

Whats left is that the ones that created the folder should get the email. I already had a look at the dynamic recommendations power automate gave me but none of them do the trick.

[MarconettiMarco · Accepted solution]

Hi @spitzbirne ,

you can refer to the following article in order to get the folder owner:

https://www.c-sharpcorner.com/article/sharepoint-rest-api-in-power-automate-ms-flow/

Please let me know.

BR,

Marco