Flow - OneDrive - Delete files older than 30Days in Folder

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I cannot see this as an option in templates but can somebody help me design a flow that achives the following?

To automatically delete files in a Onedrive folder that are over 30days old?

Many thanks for the help

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (2)

v-yamao-msft on at

Like (0)

Report
Re: Flow - OneDrive - Delete files older than 30Days in Folder

Hi @Anonymous,

According to your description, I created a flow likes below.

The flow is triggered by a Button, followed by the OneDrive for Business action List files in folder, then add a Condition to check if the last modified time of the file is 30 days ago (as there is no dynamic content for Created date time, so I use last modified time instead). If yes, delete the file.

The code is:

@equals(formatDateTime(items('Apply_to_each')?['LastModified'], 'yyyy-MM-dd'),adddays(utcnow('yyyy-MM-dd'),-30))

Please check the following screenshot for a reference.

Best regards,

Mabel Mao

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Flow - OneDrive - Delete files older than 30Days in Folder

Awesome, thanks for this. I've set it up and will test when the test files I've placed in Onedrive are a few days old. I'll change the older than threshold for testing only and let you know

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Flow - OneDrive - Delete files older than 30Days in Folder

Hi,

So I've uploaded some files which are a day old and modified the time to this code but the flow has not deleted any of the files and the condition comes back as false for each file.

@equals(formatDateTime(items('Apply_to_each')?['LastModified'], 'yyyy-MM-dd'), adddays(utcnow('yyyy-MM-dd'), -1))

Was this reply helpful? Yes No
ScottShearer 25,268 Most Valuable Professional on at

Like (0)

Report

Re: Flow - OneDrive - Delete files older than 30Days in Folder

Just so I am clear, did you upload the documents yesterday?

Can you post a screen shot of the files in the library showing the last modified date?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Flow - OneDrive - Delete files older than 30Days in Folder

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

Like (0)

Report
Re: Flow - OneDrive - Delete files older than 30Days in Folder

Hi @Anonymous,

I modified the flow configuration, please check the following flow configuration.

First, use the action initialize variable, set Name as LastModified, Type as String.

Then the action List files in folder. Specify the folder from which you want to get files.

Then under Apply to each, add the action Set variable, select dynamic content Last Modified Time for the Value field.

Then use a Compose action to format the LastModified time. The code is:

formatDateTime(variables('LastModified'),'yyyy-MM-dd')

Then configure the Condition using code likes below:

@equals(outputs('Compose_2'),formatDateTime(adddays(utcnow(),-3),'yyyy-MM-dd'))

Under the If Yes branch, add the Delete file action, select dynamic content Id from the trigger.

Please try again with it on your side.

Best regards,

Mabel Mao

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (1)

Report

Re: Flow - OneDrive - Delete files older than 30Days in Folder

Hi,

Still nothing, it's pulled in the LastModified date/time but the conditions are still false so no deleted files

Was this reply helpful? Yes No
Verified answer

v-yamao-msft on at

Like (0)

Report

Re: Flow - OneDrive - Delete files older than 30Days in Folder

Hi @Anonymous,

It seems that the Compose doesn't return repect value. Please enter the function under the Expression tab then check the return value. It should return a date time value but not the function itself.

Best regards,

Mabel Mao

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Re: Flow - OneDrive - Delete files older than 30Days in Folder

Yep that worked but the flow failed as it tried to delete subfolders on top of the files in that subfolder

{
  "status": 400,
  "message": "Resource : '481915922BF7857F!71255' is a directory. This API works only on files",
  "source": "api.connectorp.svc.ms"
}

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Flow - OneDrive - Delete files older than 30Days in Folder

Anyone found a solution for this - seems struggling to get it working as I don't understand the condition statement.

Was this reply helpful? Yes No