Unanswered

Delete files in SharePoint

(0) Share

Report

Posted on by Chalaka

I have set up a copy job in SharePoint from one location to another and it is working. I want to create a delete function that should delete files in the destination if any files are deleted in the source location. I tried multiple methods but it's giving 404 files not found error.

Categories:

Building flows

I have the same question (0)

All responses (20)

Answers (0)

Sort by

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Could you include your flow design logic (screenshot) in the forum?

Was this reply helpful? Yes No
Sundeep_Malik 6,501 on at

Like (2)

Report
Copy link

Link copied!

Hey @Chalaka
The file has already been deleted, thats why you are getting the error.
Sorry, but I dont know of any alternative for this.

@Expiscornovus
@Pstork1
@v-yujincui-msft
Any solutions?

Was this reply helpful? Yes No
Chalaka 31 on at

Like (0)

Report
Copy link

Link copied!

This was my flow.

I'm trying the below one now. Not sure if it will work or not.

Was this reply helpful? Yes No
v-yujincui-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Chalaka ,

Maybe you could try the following.

1. Here are my folders.

2. Here is my Flow.

FileLeafRef eq '@{triggerOutputs()?['body/FileNameWithExtension']}'

Result Screenshot:

Best Regards,

Charlie Choi

Was this reply helpful? Yes No
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Or you could simply try using SharePoint REST API.
See this
Solved: SharePoint Delete file, File identifier from a lis... - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No
Chalaka 31 on at

Like (0)

Report
Copy link

Link copied!

Thank you. I will try these suggestions and give you feedback. Also, I have missed one thing, it is not only a file, but it can also be a folder as well. Whatever the things delete in the source, the same files/folders should delete in the destination.

Was this reply helpful? Yes No
Pstork1 69,159 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
Yes it is possible. The key is that the file Identifier is an encoded version of the path. So if I have a variable called varFolder contains the base path for the destination file folder then the file identifier would be

encodeUriComponent(concat(variables('varFolder'),'/',triggerOutputs()?['body/FileNameWithExtension']))

Was this reply helpful? Yes No
Chalaka 31 on at

Like (0)

Report
Copy link

Link copied!

I tried this and it works for the files 😊 but it does not work if we delete a Folder. Any suggestions?

Was this reply helpful? Yes No
Chalaka 31 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Could you please put a screenshot of how initialize variable should be? I tried but the variables are not picking up correctly.

Was this reply helpful? Yes No
Sundeep_Malik 6,501 on at

Like (0)

Report
Copy link

Link copied!

@Chalaka
Can you show what error you are getting or what are you putting in the expression. Maybe you are making a mistake there?

Was this reply helpful? Yes No