How delete many files from OneDrive older than 30 days

(0) Share

Report

Posted on by frixel

969

Hi,

I want to make a flow for delete many files from OneDrive older than 30 days.

I have make this but no files will deleted.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

RobElliott 10,323 Super User 2025 Season 2 on at

Like (1)

Report

Hi @frixel , I've noticed in my tests that the "List files in a folder" OneDrive action only gets the first 20 items. I don't know why it does that but it might go some way to explain why the flow isn't working as expected.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
frixel 969 on at

Like (0)

Report

hi @RobElliott

Where can i find that 'test" from you so i can dublicate that for testing by myself.
Now i try so many times to make a Flow for delete files in my OneDrive but it is always a mistake.

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (2)

Report
Hi @frixel ,

Could you provide the details of the error message?

You could refer to the configuration below to create a Flow.

Expression reference:

formatDateTime(body('Get_file_metadata')?['LastModified'],'yyyy-MM-dd')

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

In addition, List files in folder action only returns 20 items. Currently there is such a restriction. If you want to increase the limit on the number of files returned, please consider voting for similar ideas:

List-files-in-folder-on-OneDrive-without-limit

Best Regards,

Was this reply helpful? Yes No
frixel 969 on at

Like (0)

Report

hi @v-bacao-msft

Also this flow don`t delete any file in the folder.
There are files from 04-06-2019 till today in that folder but the flow gives in the output van compose 01-07-2019.
I see that come back every time I try to create a flow to clean up files.

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

Hi @frixel ,

Note that only Last Modified Time can be obtained here.

If you are configuring Flow according to my method, the result is as expected, and compose is used to enter the last modified Time of the current file.

If the date is 2019-07-01, the result of the Condition judgment is false.

Best Regards,

Was this reply helpful? Yes No