cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

SharePoint - Delete file

I am having trouble deleting files from SharePoint. I get a 404 error but I am certain it is pointing to the right file.

I first thought it must have been a typo but after running Update file, which executes just fine this seems to be a bug with Delete File.

 

The process is as follows:

- Task with TaskID is completed

- Get row gets the row with TaskId, this row has a field called Subject

- Subject is the filename of the file to be deleted

- Delete file deletes the file - this is where it errors out

 

See screenshots for flow configuration and error message:

 

Thanks a lot.

Lukas

201907081216181lukask.png201907081217050lukask.png

1 ACCEPTED SOLUTION

Accepted Solutions

Hi again

The file you update is the same you want to delete, right?

If so, I have just tested it successfully by using an output from "Update file", see the following screenshot

Flow_delete_file.png

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

9 REPLIES 9
Helper I
Helper I

Sorry for double post - I can't seem to figure out how to edit a post.

 

Here is the image of the error message:

 

Error MessageError Message

@lkaspar 

I guess the problem is with the File identifier you are using as input for SP DElete file action block.

I would suggest to add a "Compose" action block between "Update file" and "Delete file" and add "Path" (the one you are using for "Delete File") as input of the Compose action block, so you can inspect the content of its value

Hope this helps

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Hi again

The file you update is the same you want to delete, right?

If so, I have just tested it successfully by using an output from "Update file", see the following screenshot

Flow_delete_file.png

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

Thanks for the swift response!

 

The only reason I had the update file action in there was to test the file identifier.

 

I tested your solution of using the Id of the Update file action and it worked. I don't know how because when I used the compose function after the update file, the file path was correct but Delete File failed. When I copied the output of compose and manually entered it in the File Identifier field, it worked. I think the problem is with the Subject variable coming directly from Get a row.

 

I will mark your solution as accepted but I think there is a bug in Delete file.

 

Thank you for your help

@lkaspar

I agree, for some strange reason, values accepted as input for File Identifier in some action blocks are not valid in other related action blocks.

In the meantime, happy to see we found a reasonable workaround!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Advocate I
Advocate I

Hi @lkaspar 

The File Identifier field in the Delete file Action uses URI so if you have to change the '/' after the libaray name to 

%252f

So in your case i would use the Identifier field from your Update File action or if you know the filename in your case you do if should be:

Shared Documents/General/Emails/[Subject].msg

  • Shared%20Documents%252fGeneral%252fEmails%252f[Subject].msg
[LibarayName]%252f[Filename].[extension]

 image.png

You can also use the uriComponent() expression to turn you value into a URI value

image.png

 

Hope this helped.

Anonymous
Not applicable

Thanks a lot. This helped me resolve my current issue

Frequent Visitor

@Sub 

 

I cannot over state how much this has helped me. Thank you so much for your reply, hopefully others will find this thread. I have spent entirely waaaaayyyyyy to much time try to figure this out. Again THANK YOU!

Frequent Visitor

I really appreciate the variety of approaches offered to this problem. In my case, I was triggering the flow from a link inside the doc library and I wanted to delete the file if it was already present before creating the file of that same name and causing an error. I decided to loop through all the files in the library with an Apply to Each loop and compare the file name with the file name I was intending to delete. If found, I deleted the file using its Identifier.

 

However.... After I did a Compose on the Identifier and learned that the Identifier was the same as the file name except that any spaces were replaced with _x0020_, I realized that it would have been easier to just create the Identifier in a function based on the file name and be done with it. I'll do that next time.

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (77,305)