Answered

Delete files inside Document Sets which have folders and subfolders in a SharePoint Library

(0) Share

Report

Posted on by Malou

Hello there!

I want to delete all files inside Document Sets which have folders and subfolders in a SharePoint Library when the status is "Closed".

Is it possible to do it with "Send an HTTP request to SharePoint"?

The flow runs "When an Item or File is Modified" and it creates a Document Set with multiple folders. When the document set is updated with a status of "Closed", it is moved to an "Archive library" and thus deleted from the "Source Library". It works perfectly in my Test environment, but unfortunately in Production it doesn't work, because there is a "Retention Policy" that means I have to delete all files/documents first before I can delete the folders and thus the Document Set

So I have been looking for several days now to find out a way how to deal with this.. Deleting first the files/documents and then deleting the Document Set is the way to go. I found some solutions, but it doesn't work in my case.

There is one which is quite close but I couldn't get it to work: https://www.youtube.com/watch?v=LG8aFEutJyU

The structure of my Document Library looks like this:

Library Name --> Document Set Name --> Folder --> File/Document

Glad to hear from you.

Cheers.

Screenshot 2024-01-07 at 21.32.55.png

Screenshot 2024-01-07 at 21.40.58.png

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Malou,

You need to select the Identifier parameter from the dynamic content to delete the file.

To achieve this, you need to add a get file properties action before the Deletion file action, then Delete the file through the File Identifier property from the get file properties action.

Was this reply helpful? Yes No
Malou 4 on at

Like (0)

Report
Copy link

Link copied!

Thank you for taking your time @v-qiaqi-msft.
The ID of Get Files properties, how did you get it?

Thanks.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Malou,

Since you have a Filter array after yout Get items action, you need to select the ID from the filter array as below:

item()?['ID']

Was this reply helpful? Yes No
Malou 4 on at

Like (0)

Report
Copy link

Link copied!

Unfortunately, it did not work. I get an error which says "The file does not exist".
In the last step "Delete file" it does not find the file. Is there where the error shows.
I follow your advice, so I really do not know where the error lies.

Again:
The structure of my custom library looks like this:
Library Name --> Document Set Name --> Folder --> File/Document

Please, look at the image below, perhaps can help to understand where the issue lies.

Was this reply helpful? Yes No