Delete file from Sharepoint library at end of Flow

[BrisM900]

Hi,

I've seen some posts on this but I've not been able to get anything to work yet.

I have a Flow which runs through an approval process and after the final approval copies the file to a "frozen" library.

After that I want to delete the original file but it always fails with JSON error.

If I test by going into the Flow and manually selecting the file by folder then name it works, but if I obtain same "folder/file_name.extension" as dynamic content it fails, even though both are observationally the same.

I have also tried the HTTP REST DELETE method but can't get that to work either.

Any ideas?

Regards,

Paul

[efialttes]

@BrisM900 

I guess you need the file identifier. See for example this post 

Hope this helps

[BrisM900]

Thanks, but I've tried file identifier too.

[efialttes · Accepted solution]

@BrisM900 

Mmmm... as you said, some posts point out that unless you get file identifier from your trigger, you would probably get a JSON error. 

THis second post explains how to do it via HTTP request via REST to delete it

Please note I haven't tested it myself

Hope this helps

[BrisM900]

Thanks for jumping on this quickly @efialttes.

The reference to the HTTP helped, but I also needed this reference from Microsoft on working with files using REST api and adjusting the URL to reference ('/sites/site name/library name/file name.docx from dynamic content')/recycle as the example MS uses in their reference only uses ('/folder name/file name') which failed.

[efialttes]

Thanks for sharing, @BrisM900 !