Unanswered

Creating an automation to delete files on a SharePoint folder after 7 days, teams private group

(0) Share

Report

Posted on by Chandni

Hello, I am trying to build an automation to delete files on a SharePoint folder, after 7 days. The sharepoint site is a Teams private group but I am getting this error message. Can anyone please help?

I have the same question (0)

All responses (3)

Answers (0)

David_MA 12,515 Super User 2025 Season 2 on at

Like (0)

Report
Re: Creating an automation to delete files on a SharePoint folder after 7 days, teams private group

Your filter query is not properly formatted. It needs to be like this:

The expression used is the following and needs to be within single quotes:

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

Since your screen shot shows ['LastModified'], I assumed you want the logic based on the Modified date. If you want to base it on the created date, replace Modified with Created in the filter query.

Was this reply helpful? Yes No
Chandni 2 on at

Like (0)

Report

Re: Creating an automation to delete files on a SharePoint folder after 7 days, teams private group

Thank you so much for responding.
Part of the issue was a permission thing, I wasn't an owner to the Teams site so I added myself as the Owner but now I get this error message

error.jpg

Was this reply helpful? Yes No
David_MA 12,515 Super User 2025 Season 2 on at

Like (0)

Report
Re: Creating an automation to delete files on a SharePoint folder after 7 days, teams private group

Based on the screen shot, the error is because you typed the expression into the filter query rather than using the expression builder to create the expression in the filter query. If you look at my screen shot I posted, the expression is in a pink box, which indicates it was created with the expression builder. When your cursor is in the filter query box, this window will open. Choose the Expression tab and enter it there and press OK.

And I just noticed, I don't know what I was thinking when I gave you the earlier expression. This is the expression you want to use:

addDays(utcNow(),-7,'yyyy-MM-dd')

Was this reply helpful? Yes No