Extract Folder Issue limitations of connector or other issue?

(2) Share

Report

Posted on by CU21021532-0

Hi all,

I have a flow that pulls down documents via API from an external system and saves them as a .zip file in Sharepoint. I then want to extract that folder so I can move the documents to their respective locations in Sharepoint. The issue I am running into is that the "Extract Folder" step seems to start working as it creates one new folder that is within the .zip file then stops working and eventually throws a 404 error that the file does not exist.

The .zip folder has a structure of 1+ folders beneath it (varies based on the day) then documents in each one of those folders (I cannot change this structure as it is this way from the API call). I have verified the .zip is "MediaType": "application/zip" in the create folder connector and it is identified correctly as it technically "starts" extracting. Any advice or help to get this extracted would be massively appreciated. Thanks in advanced

.zip file structure

- Folder 1

- document 1

- document 2

- folder 2

- document 3

- folder 3

- document 4

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Michael E. Gernaey 53,963 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi

Please always share your flow so we have the details necessary to help. Both the design mode with inputs and a flow run with inputs, outputs, errors etc,

Thanks

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

I tried something simmilar but it worked fine for me

Are you using pdf document or any file type ?

Thanks & Regards,
Nived N

Stay connected:
LinkedIn | YouTube | Blogs

Was this answer helpful?
If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
Your feedback motivates me to keep contributing. Thank you!

Was this reply helpful? Yes No
CU21021532-0 12 on at

Like (0)

Report
Copy link

Link copied!

Update: so I think I found the issue but am still without a solution - looks like the flow fails when the sub folder name in the zip ends with a "." - flow runs perfectly if none of the folders end with a "." so I'm assuming it is just triggering that it is invalid. Is there any way to change the folder names first before extraction9? We cannot change them on the source side pre-api.

Hi all, thanks for the responses. The 9documents within the folders will always be PDF's. I have also tried adding a delay before extract folder as well and did not make a difference.

Here is the full flow and source file path for the extract folder:

Flow Run Inputs for Extract Folder:

{

    "host": {

        "connectionReferenceName": "shared_sharepointonline",

        "operationId": "ExtractFolderV2"

    },

    "parameters": {

        "dataset": "https://karbonpartnersinc.sharepoint.com",

        "source": "Automations Test/Staging/CanoeDocuments.zip",

        "destination": "/Automations Test/Staging",

        "overwrite": true

    }

}

Flow Run Outputs:

{

    "statusCode": 404,

    "headers": {

        "Cache-Control": "no-store, no-cache",

        "Pragma": "no-cache",

        "Set-Cookie": "ARRAffinity=78cc7ed2e16cd9d0de735360d27b2d80c6dbba9425ecf0dbe0884f7517a0ca11;Path=/;HttpOnly;Secure;Domain=sharepointonline-eus2.azconn-eus2-003.p.azurewebsites.net,ARRAffinitySameSite=78cc7ed2e16cd9d0de735360d27b2d80c6dbba9425ecf0dbe0884f7517a0ca11;Path=/;HttpOnly;SameSite=None;Secure;Domain=sharepointonline-eus2.azconn-eus2-003.p.azurewebsites.net",

        "Strict-Transport-Security": "max-age=31536000; includeSubDomains",

        "x-ms-request-id": "93ac87a1-90e1-8000-1183-018bf66a3f80;93ac87a1-70e5-8000-1183-0418a0d2e4bd",

        "X-Content-Type-Options": "nosniff",

        "X-Frame-Options": "DENY",

        "x-ms-environment-id": "default-ef657141-779e-4503-a502-11f856cef57f",

        "x-ms-tenant-id": "ef657141-779e-4503-a502-11f856cef57f",

        "x-ms-dlp-re": "-|-",

        "x-ms-dlp-gu": "-|-",

        "Timing-Allow-Origin": "*",

        "x-ms-apihub-cached-response": "true",

        "x-ms-apihub-obo": "false",

        "Date": "Wed, 05 Mar 2025 23:20:35 GMT",

        "Content-Length": "512",

        "Content-Type": "application/json",

        "Expires": "-1"

    },

    "body": {

        "status": 404,

        "message": "The file /Automations Test/Staging/CanoeDocuments.zip does not exist.\r\nclientRequestId: a8fd1eb9-4c23-4872-a95e-1d6577fcbf96\r\nserviceRequestId: 93ac87a1-90e1-8000-1183-018bf66a3f80;93ac87a1-70e5-8000-1183-0418a0d2e4bd",

        "source": "https://karbonpartnersinc.sharepoint.com//_api/web/GetFileByServerRelativePath(decodedUrl=@p)/Etag?@p='%2fAutomations+Test%2fStaging%2fCanoeDocuments.zip'",

        "errors": [

            "-2130575338",

            "Microsoft.SharePoint.SPException"

        ]

    }

}

Was this reply helpful? Yes No
Suggested answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

May be yes - folder name ending with dot may have created the problem, I have tried to create a folder with name ending with . but unable to do so. Also when i create a folder with name test2.. , when i click on the folder, it is saying folder name test2 does not exists, I think this folder naming convention is not supported.

So as you said - we need to remove the folder name dot part within the zip file prior to extracting - I think there is a script which can help to do that - using powershell - which can do the renaming of folders within zip file. But for that cloud flow can't be used. You have to try using desktop flows to perform that.

Thanks & Regards,
Nived N

Stay connected:
LinkedIn | YouTube | Blogs

Was this answer helpful?
If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
Your feedback motivates me to keep contributing. Thank you!

Was this reply helpful? Yes No