Unanswered

Delete sharepoint file - not in JSON format

(0) Share

Report

Posted on by Adam_Lpl

Hi all

Hope you can help with this. I have a long flow which was working file until I added a delete sharepoint file command at the end.

The beginning of the flow creates the file

The is then an approval process. If the approval is rejected I want to delete the file which was made in the earlier step. I have used the following flow:

I get the following error message:

Please can anyone help.

Many thanks

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

abm abm 32,865 Most Valuable Professional on at

Like (3)

Report

Hi @Adam_Lpl

To delete the file you need the identifier. Please follow the below.

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report

Hi @Adam_Lpl,

Can you try and replace the path and only use the dynamic value called Identifier from the Create File action instead? Let me know if that works 🙂

Was this reply helpful? Yes No
tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report

Hello @Adam_Lpl ,
the 'Delete file' action expects 'File Identifier', that's a unique identifier of the file on the site, which is assigned when the file is created. You should use output from the 'Create file' action that provides you the 'Id' as a dynamic content.

Was this reply helpful? Yes No
Adam_Lpl 32 on at

Like (0)

Report

Thanks @abm

I should have showed the full flow as there are multiple document creations and a SharePoint list modification. When I use ID as the File Identifier it deletes the item from my SharePoint list which triggered the flow instead of the document I want deleting. Is there a way of identifying the correct item to be deleted in the file identifier amongst the various items created in my flow below?

I've put a red X next to the document I want deleting. Rest of flow to follow:
Thanks @abm

I should have showed the full flow as there are multiple document creations and a SharePoint list modification. When I use ID as the File Identifier it deletes the item from my SharePoint list which triggered the flow instead of the document I want deleting. Is there a way of identifying the correct item to be deleted in the file identifier amongst the various items created in my flow below?

I've put a red X next to the document I want deleting. Rest of flow to follow:

Was this reply helpful? Yes No
Adam_Lpl 32 on at

Like (0)

Report

Thanks @Expiscornovus

I should have showed the full flow as there are multiple document creations and a SharePoint list modification. When I use ID as the File Identifier it deletes the item from my SharePoint list which triggered the flow instead of the document I want deleting. Is there a way of identifying the correct item to be deleted in the file identifier amongst the various items created in my flow below?

I've put a red X next to the document I want deleting. Rest of flow to follow:
Thanks @abm

I should have showed the full flow as there are multiple document creations and a SharePoint list modification. When I use ID as the File Identifier it deletes the item from my SharePoint list which triggered the flow instead of the document I want deleting. Is there a way of identifying the correct item to be deleted in the file identifier amongst the various items created in my flow below?

I've put a red X next to the document I want deleting. Rest of flow to follow:

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @Adam_Lpl

It would be easier to split this into two flows. One for creating the files. Next you could use the below trigger to start the flow for your approval process.

Was this reply helpful? Yes No
Adam_Lpl 32 on at

Like (0)

Report

Thanks @abm

sorry to be a pain but splitting doesn’t work for me. The approval process need to contain all of the data from the SharePoint list and the creation of the document needs to happen before the approval for regulatory reasons.

I think there may be another way of approaching this without deleting the file.

the only reason I’m trying to delete the file created earlier in the flow is because if the approval is rejected the user needs to amend the data in the SharePoint list to correct it. This triggers the flow again but it then fails as the file it’s trying to create before the approval already exists.

Is there a condition I could put in so it skips the document creation step altogether under certain conditions? That would leave the original document created there but not make the flow fail.

sorry need your expertise on this one. It’s making my head hurt!

thanks

Was this reply helpful? Yes No