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

SharePoint Delete file, File identifier from a list

 

Hi,

 

I have a Flow which Create file in 3 different SharePoint location via metadata, when a file is created i also Create item in a list, on this list i have the File identifier stored.

 

I am know creating a Flow which is supposed to Delete file  - see below: 

 

Flow1.PNG

 

OrgID contains the File Identifier which is stored in a column, there is 3 conditions as i have 3 different destinationadress'.

 

Below is output from a run:

 

Flow.PNG

 

Body message

 
  "error": {
    "code"404,
    "source""europe-001.azure-apim.net",
    "clientRequestId""ef304424-2e36-4833-831d-b4caa7f7b8a1",
    "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."
 

 As per other posts i can se the issue could be "string" vs "uri", but how can i do that?

1 ACCEPTED SOLUTION

Accepted Solutions
makp
Advocate I
Advocate I

Found another solution or workaround.

 

I used "Send an HTTP request to SharePoint" with method DELETE:

 

Flow.PNG

 

 

 

View solution in original post

5 REPLIES 5
buildbod
Advocate III
Advocate III

I think you should be treating the files as items in a List calling the ID of the file and not the OrgID.

 

create delete workaround.png

I dont think that will help in my solution.

 

Workflow1

Create file based on querying the reason is the file can be created in 3 different folders or all

Create item based on properties from the file in "Mainlist"

 

Workflow2

Delete file based on "Mainlist".

 

As from another post it seems to be format problem string vs. uri.

makp
Advocate I
Advocate I

Found another solution or workaround.

 

I used "Send an HTTP request to SharePoint" with method DELETE:

 

Flow.PNG

 

 

 

Anonymous
Not applicable

Thank you.

AdilBIM
Frequent Visitor

AdilBIM_0-1655851889169.png

1. set file name

2. get list of all file names in the folder

3. find if the file name (step 1 ) already exist in the list (step 2)

4. if "Yes" Delete it

Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,009)