Delete files in OneDrive older than 60 day`s

Like (0) Share

Report

Posted on 10 May 2019 07:33:29 by frixel

899

I try to make a flow for Delete files in OneDrive older than 60 day`s with this example.

But for this point:

3-1. Action: Data Operations - Compose ( Inputs = "@div(sub(ticks(utcnow()), ticks(item()?['LastModified'])), 864000000000)" )

i can`t put it in the expression box, it gives a error.

Is there an other example to make a flow for Delete files in OneDrive older than xx day`s?

All responses (14)

Answers (1)

frixel 899 on 14 May 2019 at 05:36:19

Like (0)

Report

Re: Delete files in OneDrive older than 60 day`s

Hi @v-bacao-msft @ScottShearer

If i set that files older than 3 day`s must be beleted is delets file`s from 01-05-2019 -02-05-2019 and 03-05-2019
frixel 899 on 13 May 2019 at 08:58:21

Like (0)

Report

Re: Delete files in OneDrive older than 60 day`s

Hi @v-bacao-msft
See below. Mail is send but files are not deleted.
v-bacao-msft on 13 May 2019 at 08:22:24

Like (0)

Report

Re: Delete files in OneDrive older than 60 day`s
frixel 899 on 13 May 2019 at 08:19:20

Like (0)

Report

Re: Delete files in OneDrive older than 60 day`s
v-bacao-msft on 13 May 2019 at 08:06:49

Like (0)

Report

Re: Delete files in OneDrive older than 60 day`s

Hi @frixel ,

You can initialize an array to store information about the filtered files.

Use Length() function to calculate the number of files, or you could create an HTML table to display file information.

Image reference:

Please take a try.

Best Regards,
frixel 899 on 13 May 2019 at 07:51:01

Like (0)

Report

Re: Delete files in OneDrive older than 60 day`s

Can I ask one more question?
If I want to receive 1 mail when files have been deleted, how do I set it?
If I do it like the below, flow sent an email for each deleted file.(it would be even better if flow counts how many files have been deleted.)
frixel 899 on 13 May 2019 at 06:50:09

Like (0)

Report

Re: Delete files in OneDrive older than 60 day`s

Ahh,sorry. I forget to "update" the addDays(utcNow) expression
Now it works fine.
v-bacao-msft on 13 May 2019 at 06:43:08

Like (0)

Report

Re: Delete files in OneDrive older than 60 day`s

What happened, it should only delete the eligible files according to the conditions you set.
frixel 899 on 13 May 2019 at 06:38:21

Like (0)

Report

Re: Delete files in OneDrive older than 60 day`s

When i do this al the files wil be deleted
Verified answer

v-bacao-msft on 13 May 2019 at 05:59:25

Like (1)

Report

Re: Delete files in OneDrive older than 60 day`s

Hi @frixel ,

Please use Compose output Last modified and Is folder.

Please show the details of your Flow configuration.

Best Regards,