Forum Discussion

michaelwangRaritan's avatar
michaelwangRaritan
Copper Contributor
Sep 25, 2019

Warning message "BadGateway" and "status : 500" of JSON context for SharePoint "Set Content Approval

Hi all, we are using this https://emea.flow.microsoft.com/zh-tw/galleries/public/templates/ebfd98c5055d4297acba1f0376a6d7f5/%E5%9C%A8%E6%AA%94%E6%A1%88%E6%96%B0%E5%A2%9E%E6%99%82%EF%BC%8C%E4%BD%BF%E7...
sharepoint
michaelwangRaritan's avatar
michaelwangRaritan
Copper Contributor
Sep 26, 2019

Hi, Norman Young 

I did have these setting as attached image and if there could be any other setting that I should check?

 

Norman Young's avatar
Norman Young
MVP
Sep 26, 2019

Hi michaelwangRaritan,

 

If you are still getting the warning message please share a screen shot of the error and of the Flow.

 

Norm

  • michaelwangRaritan's avatar
    michaelwangRaritan
    Copper Contributor
    Sep 29, 2019

    HI Norman Young ,

    I wonder if the RESTful API result of "set content approval status to approve" is correct so I compile the key-value pairs below in a table and if you can help to diagnose.

    keyvalue
    X-SharePointHealthScore0
    X-MS-SPConnector1
    X-SP-SERVERSTATEReadOnly=0
    DATASERVICEVERSION3.0
    SPClientServiceRequestDuration1234
    SPRequestGuidd16561c5-4097-4f5e-984e...
    request-idd16561c5-4097-4f5e-984e...
    MS-CVxWFl0ZdAXk+YTlVibJIwoQ.0
    Strict-Transport-Securitymax-age=31536000
    X-FRAME-OPTIONSSAMEORIGIN
    MicrosoftSharePointTeamServices(I ignore the address here)
    X-Content-Type-Optionsnosniff
    X-MS-InvokeApp1; RequireReadOnly
    Timing-Allow-Origin
    		*
    x-ms-apihub-cached-responsetrue
    Cache-Controlmax-age=0, private
    DateSun, 29 Sep 2019 05:18:06 ...
    P3PCP="ALL IND DSP COR AD...
    X-AspNet-Version4.0.30319
    X-Powered-ByX-Powered-By
    Content-Length467
    Content-Typeapplication/json
    ExpiresSat, 14 Sep 2019 05:18:06...
    Last-ModifiedSun, 29 Sep 2019 05:18:06...

    also the JSON content as below:

     

    {
  "error": {
    "code": 502,
    "source": "flow-apim-europe-001-francecentral-01.azure-apim.net",
    "clientRequestId": "d16561c5-4097-4f5e-984e-55626c9230a1",
    "message": "BadGateway",
    "innerError": {
      "status": 500,
      "message": "項目的目前狀態是「Draft」，因此無法實作後續動作Approve\r\nclientRequestId: d16561c5-4097-4f5e-984e-55626c9230a1\r\nserviceRequestId: d16561c5-4097-4f5e-984e-55626c9230a1"
    }
  }
}

     

    The Chinese section might be similar to "The current state of the item is Draft and the following action Approval cannot be implemented Approve\r\nclientRequestId: d16561c5-4097-4f5e-984e-55626c9230a1\r\nserviceRequestId: d16561c5-4097-4f5e-984e-55626c9230a1".

    I also attach some related https://powerusers.microsoft.com/t5/General-Flow-Discussion/Set-Content-Approval-Status-Action-works-as-expected-but-always/m-p/369876#M31166 and https://docs.microsoft.com/zh-tw/connectors/sharepointonline/#set-content-approval-status here for reference.

Resources