Power Platform Community Forum Thread Details

Hello,

we have a flow that saves .zip attachments from our reporting mails, which then extracts the files to different folders in Sharepoint depending on the name of the .zip file.

It works most of the time but sometimes the Create File action that creates the zip file in a folder, fails and gives status code 400 with message "Cannot open file".

As I said, it works most of the time but every other 5th try it fails for some reason. The account behind the flow has complete access to the Sharepoint folder.

Here's the raw input from the error:

{
    "statusCode": 400,
    "headers": {
        "Cache-Control": "max-age=0, private",
        "Vary": "Origin",
        "X-NetworkStatistics": "0,525568,0,0,60,0,24441,15",
        "X-SharePointHealthScore": "3",
        "X-MS-SPConnector": "1",
        "X-SP-SERVERSTATE": "ReadOnly=0",
        "DATASERVICEVERSION": "3.0",
        "SPClientServiceRequestDuration": "339",
        "SPRequestDuration": "340",
        "X-DataBoundary": "EU",
        "X-1DSCollectorUrl": "https://eu-mobile.events.data.microsoft.com/OneCollector/1.0/",
        "X-AriaCollectorURL": "https://eu-mobile.events.data.microsoft.com/Collector/3.0",
        "SPRequestGuid": "4f06d959-4941-417b-8499-4c08eabaf426",
        "request-id": "4f06d959-4941-417b-8499-4c08eabaf426",
        "MS-CV": "oVykILqgAKBN+SjQz27h6A.0",
        "Alt-Svc": "h3=\":443\"",
        "Strict-Transport-Security": "max-age=31536000",
        "X-Frame-Options": "SAMEORIGIN",
        "Content-Security-Policy": "frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.microsoft.us local.teams.office.com teams.cloud.microsoft *.office365.com goals.cloud.microsoft *.powerapps.com app.powerbi.com *.yammer.com engage.cloud.microsoft word.cloud.microsoft excel.cloud.microsoft powerpoint.cloud.microsoft *.officeapps.live.com *.office.com *.microsoft365.com *.stream.azure-test.net *.microsoftstream.com *.dynamics.com *.microsoft.com onedrive.live.com *.onedrive.live.com securebroker.sharepointonline.com;",
        "MicrosoftSharePointTeamServices": "16.0.0.25402",
        "X-Content-Type-Options": "nosniff",
        "X-MS-InvokeApp": "1; RequireReadOnly",
        "P3P": "CP=\"ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI\"",
        "X-AspNet-Version": "4.0.30319",
        "X-Powered-By": "ASP.NET",
        "x-ms-tenant-id": "225fb9df-060c-4c2d-b5c1-1bbae1e9cdfb",
        "Timing-Allow-Origin": "*",
        "x-ms-apihub-cached-response": "false",
        "x-ms-apihub-obo": "false",
        "Date": "Wed, 23 Oct 2024 06:34:10 GMT",
        "Content-Length": "305",
        "Content-Type": "application/json",
        "Expires": "Tue, 08 Oct 2024 06:34:10 GMT",
        "Last-Modified": "Wed, 23 Oct 2024 06:34:10 GMT"
    },
    "body": {
        "status": 400,
        "message": "Cannot open file \"https://xxxx.com/sites/Data/CZ_PAST_20241022.zip\".\r\nclientRequestId: 4f06d959-4941-417b-8499-4c08eabaf426\r\nserviceRequestId: 20a45ca1-a0ba-a000-4df9-28d0cf6ee1e8"
    }
}

Categories:

Building flows