'Extract archive to folder' failed - BadRequest - Status Code 400

(3) Share

Report

Posted on by gentsuki

Running out of ideas how to fix a pretty simple flow for extracting ZIP file in OneDrive for Business folder.

Tried various changes like different triggers, and overwrite off/on still exactly the same outcome.

UPDATE: I found that when copying ZIP file from FTP to OneDrive For Business, MS Flow changes the file slightly, which then breaks ZIP structure and doesn't allow extraction after this.

Any recommendations, on how to copy ZIP files from FTP without affecting their structure?

Please help!

image

Categories:

Building flows

I have the same question (0)

All responses (17)

Answers (0)

v-yamao-msft on at

Like (0)

Report

Hi @gentsuki,

Could you share more details on your flow? How is it created?

What’s the detailed error message?

I have made the following test to copy ZIP file from SharePoint library to OneDrive for Business, then Extract archive to folder.

It is configured likes below. Please check it for a reference and try again on your side.

Best regards,

Mabel

Was this reply helpful? Yes No
vz 4 on at

Like (0)

Report

hi @v-yamao-msft
I have a similar flow extracting a folder stored in the SharePoint library.
Strange thing is that it was working before but it's not working anymore...

Was this reply helpful? Yes No
JenVitug 264 on at

Like (2)

Report

@v-yamao-msft , please help me, i have the same error for below flow , error occurs in Extract folder STEP 😞

Error message :
Unable to extract contents of file '/Geo IT PH Documents/Message Report.zip'.
clientRequestId: fba1f522-f37a-41b9-a4cc-e1be66c20abf
serviceRequestId: d04a6d9f-e085-b000-12ef-23893697c3a9;d04a6d9f-d089-b000-12ef-258390175731;d04a6d9f-c08b-b000-12ef-2b440c2b19fc

I have tried the same flow for a zip file that contains an excel file (xlsm) and it did not encounter error.

The Zip file that i get this error is one that contains a CSV file in it . Could it be that CSV files that are ZIPPED cannot be extracted ?

Was this reply helpful? Yes No
Spinner 101 on at

Like (1)

Report

@gentsuki- similar problem here, though in my case I'm uploading to a SharePoint library. Sometimes the unzipping works, but often it fails. However, pressing "Resubmit" on the flow in Power Automate often works without any problem.

I saw a similar problem here: https://powerusers.microsoft.com/t5/Connecting-To-Data/Sharepoint-Extract-Folder-gives-400-BadRequest/td-p/208105
In that problem, the zip file contained a CSV file, like @JenVitug reported. Did your zip file also contain something similar? Mine doesn't contain a CSV file, but does contain XML.

Was this reply helpful? Yes No
marioS 36 on at

Like (0)

Report

I have the exact similar issue right now. My zip file contains CSV and XML 😉 did not really find a solution after few hours... any idea is warmly welcomed...

@JenVitug and @Spinner kindly ask you to share your solution if you could make it work ...

Was this reply helpful? Yes No
Spinner 101 on at

Like (1)

Report

@marioS It's not a solution, but a couple of days ago I introduced a 5-minute Delay action directly after the trigger. Since then all the runs have gone through successfully (so far).

Was this reply helpful? Yes No
marioS 36 on at

Like (1)

Report

@Spinner i will at least give it a try… will let you know if it worked…

Was this reply helpful? Yes No
El_Diego76 7 on at

Like (0)

Report

Did it work or did you find another solution?

Was this reply helpful? Yes No
marioS 36 on at

Like (1)

Report

@El_Diego76 unfortunately it did not work with the delay. Still getting the same error... Other solutions are still appreciated

Was this reply helpful? Yes No
27Merlins 5 on at

Like (0)

Report

I am having this same issue, and I have also not been able to find a solution. Does anyone have any update on this?

Was this reply helpful? Yes No