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
Norman Young's avatar
Norman Young
MVP
Sep 25, 2019

Hi michaelwangRaritan,

 

Did you set the Document Library Versioning Settings correctly?

 

I would not expect the version number to change, only the "Approval Status".

 

I hope this helps.

 

Norm

  • 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