Deleting a sharepoint item returns a 404

[MangoMan09]

I am currently having this issue and I am not sure why this is happening.

In short, I am calling this flow on a PowerApp on a step where a user chooses to delete an entry on a Sharepoint list. Each Entry has a column with the path to an image.

With this in mind i figured that using a flow would be the friendliest  and quickest way to delete this file. As you can see below the steps are simple, one var for debugging sake and the deletion connector itself


Here's where the trouble arises, whenever I try to run this I get a 404 error:

{
  "error": {
    "code": 404,
    "source": "europe-002.azure-apim.net",
    "clientRequestId": "ff47d7da-8bfa-4fd5-9482-b5decb9053d7",
    "message": "The response is not in a JSON format.",
    "innerError": "The resource you are looking for has been removed, had its name changed, or is temporarily unavailable."
  }
}

I tried running the deletion connector by selecting the files manualy and it worked, I double checked the path text and they matched which left me confused.

Does anyone have an idea of what I am doing wrong?

[abm · Accepted solution]

Hi @MangoMan09 

You can't pass the filename as file identifier for deleting the file. You need the id of the file. You can get the id using 'Sharepoint - Get Items' flow action using the filter query matching the filename.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

[MangoMan09]

Thanks @abm that really nudged me on the right path!

I was still unable to get the identifier to work directly after that but this tutorial helped me with the logic: https://powerusers.microsoft.com/t5/General-Discussion/Delete-SharePoint-document-library-document-u...

For those those who might need it here's the added steps:

[abm]

Hi @MangoMan09 

Good to know that you managed to resolve it. 

Please mark it as accepted answer and it help others in the community.

Thanks