Answered

Delete SharePoint files after X days failure

(0) Share

Report

Posted on by KnucklezZ

Hi,

I have created a flow that looks through certain folders on SharePoint to delete files that are older than 30 days. I've repeated the steps 4 times because I have 4 folders to look through.

Two of those run successful, and two show failure. This is the failure message:

It's the same "does not exist" error every time but for different files.

The flow is pretty straight forward:

I have these repeated with just the Folder being different. The filter query is:

addDays(utcNow(), -30)

Any ideas how to fix this?

Thank you,

Mateusz

Categories:

Using flows

I have the same question (0)

All responses (10)

Answers (1)

Argy_Zadkine 51 on at

Like (0)

Report
Copy link

Link copied!

Thanks Bof, I was having the same issue , and now used your suggestion and it works fantastic!

Argy

Was this reply helpful? Yes No
KnucklezZ 8 on at

Like (0)

Report
Copy link

Link copied!

@v-bofeng-msft

Hey,

Thank you so much for your help. The flow is now successful. I will keep an eye on if it's actually deleting files after the 30 days in all folders. but for now I would say it's case closed.

Thanks again!

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

Like (0)

Report
Copy link

Link copied!

Hi @KnucklezZ ,

The argument in items() needs to correspond to the name of the current loop, if the current loop is 'Apply to each 2' then it should be items('Apply_to _each_2') or items('Apply_to _each2')

Best Regards,

Bof

Was this reply helpful? Yes No
KnucklezZ 8 on at

Like (0)

Report
Copy link

Link copied!

Hey @v-bofeng-msft

I actually noticed that after I sent the post, haha, thanks.

I am getting an error when I do the steps for the 2nd folder (1st seems fine):

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

Like (0)

Report
Copy link

Link copied!

Hi @KnucklezZ ,

you need to set the filter array's condition to 'is equal to false'

Best Regards,

Bof

Was this reply helpful? Yes No
KnucklezZ 8 on at

Like (0)

Report
Copy link

Link copied!

Hey @v-bofeng-msft

Should this work?

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

Like (0)

Report
Copy link

Link copied!

Hi @KnucklezZ ,

Is the problem solved? Do you need any help?

Best Regards,

Bof

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

Like (0)

Report
Copy link

Link copied!

Hi @KnucklezZ ，

Yes you need to ding it 4 times. Or you could try 'Delete item' instead of 'delete file'.

The key point is that the 'Delete file' action can not delete a folder , so you should add a filter action to filter out the folders.

Best Regards,

Bof

Was this reply helpful? Yes No
KnucklezZ 8 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft ,

Thanks for replying.

Just a few questions:

Do I repeat this for all 4 folders, so doing it 4 times? Also, do I keep the filter query I have used in my flow?

Thanks,

Mateusz

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @KnucklezZ ,

Please try:

Best Regards,

Bof

Was this reply helpful? Yes No