Unanswered

Formula for Deletion of old files from sharepoint in a specific time period

(0) Share

Report

Posted on by MR-17020915-0

Hi All

I am attempting to setup an auto delete function for old files on a SharePoint however the formula is not working addDays(utcNow(), -100)

When testing the flow, the test is failing

Please can someone assist who has experienced with this

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@MR-17020915-0 It's hard to offer any recommendations without seeing your full flow and what action is failing. Toggle off the New Designer and click each action to expand it. Upload a screenshot of your flow in edit mode.

In the meantime, if you are using the Get Files (properties only) action—the name can be misleading as it returns files AND folders. You'll need to use a Filter Query to filter out files only. Refer to this YT Short. Additionally, if you have more than 100 files/folders in your selected document library you will need to ensure you toggle on pagination. By default the Get Files (properties only) action will only return 100 files and folders.

You might also be interested in this YT Tutorial:

How to Work with 📆 Dates in Power Automate | Example Scenarios and Tips & Tricks

Are you easily stumped when working with Dates in Power Automate? In this Power Automate tutorial, I’ll show you how to compose an expression that will return a future date, a past date, how to count the number of days between two dates, how to check for a birthdate and anniversary date as well as tips and tricks when working with dates in Power Automate. I’ll cover some common use cases and concepts that can help you to build better Power Automate flows.

Feel free to skip ahead using the timestamps listed below. I’ve also linked a few other tutorials that you might be interested in as well.

IN THIS VIDEO:
✓ 4 Date Functions You Need to Know
✓ How to use the Convert Time Zone Action
✓ How to Get a Future Date
✓ How to Get a Past Date
✓ How to Return SharePoint Items Due in a Number of Days
✓ How to Return SharePoint Items Due within a Date Range
✓ How to write a Filter Query for SharePoint Items Due in 30, 60 and 90 Days
✓ How to Calculate the Number of Days between Two Dates
✓ How to Check for a Birthdate and Anniversary Date
✓ How to work with Dates and Times in Excel
✓ How to use a Manual Trigger with Date Input
✓ How to Output Dynamic Text with an Expression
✓ How to Check if a Date Falls on a Weekend

Hope this helps!

Consider giving me a ❤️ if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

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

Like (0)

Report

It is best if you show your flow, otherwise one can only guess what you are doing. With that said, I assume you're using a get files action with a filter query, and the expression above is used in the filter. If so, is that all you have in the filter query? If so, that is one reason it does not work. You need to specify the field to filter on and the condition (gt, lt, ge, le). Also, query filters on dates must be formatted in ISO8601 format (yyyy-MM-dd).

Was this reply helpful? Yes No