ETAG mismatch Error

[PeterKuehlian]

Hi

I have embeded an approval workflow in our SharePoint document library based on flows.

It does pretty much what it is supposed to do. However I do have one problem:

At the end of the workflow I want to set the approval status of the document to either approved or rejected. Unfortunately that does not work. I have troubles with the ETag.

Here is the Error:

{

  "error": {

    "code": 502,

    "source": "flow-apim-europe-001-francecentral-01.azure-apim.net",

    "clientRequestId": "ca960cb9-4a5a-4445-a0c3-8a6ade77783b",

    "message": "BadGateway",

    "innerError": {

      "status": 500,

      "message": "Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))\r\nclientRequestId: ca960cb9-4a5a-4445-a0c3-8a6ade77783b\r\nserviceRequestId: 2941c99e-2057-8000-db55-a179f50d1bb4"

    }

  }

}

Unfortunetly this does not occour always. Just sometimes. 

• When a collegue of mine has to approve something and I send the approval, it does work.
• When I send the approval to myself, it does work. 
• As soon as the approval is sent to me by a collegue, it does not work. 
• Collegue to Collegue does work sometimes, but not always. 

Best regards.

Peter

[v-bacao-msft · Accepted solution]

Hi @PeterKuehlian ,

Could you share screenshots of Flow configuration?

You could use Get file metadata to get Etag instead of using Tags from trigger.

Also from the error message and the scenario you describe, this seems to be related to access rights.

I guess the account of the connection configured by Set content approval status action is yours, so it is up to you to set Approval Status of the current file.

But if you don't have enough permissions, there is not able to access the file and rely on this action to set the Status.

Best Regards,

[PeterKuehlian]

Hi Barry Cao

Thanks, it was a problem with my permission management. 

I put my collegues in the contributor class on sharepoint. Because of that, they were not allowed to update the approval status. 

My solution now is to give approval rights to my contributor class - seems to work pretty well. 

Thank you for your help

Peter