Sharepoint approval status is not updated/ badgateway

[Hamid]

Hello,

I have created a flow when a file is added or modified ask for the approval and then change the status in Sharepoint.

The problem is that usually, I get BadGateway error on the Set Content approval status step. and in case I don't get an error the status in sharepoint is not changed. ( I am using a folder inside a folder.) I appreciate your help 

[ScottShearer]

@Hamid

In the set content approval status action, I believe that you need to provide the ETag value and use the ItemID rather than the ID.

[Hamid]

I replaced ID with itemID , I still get error of Badgateway. error 502

[ScottShearer]

@Hamid 

Take a look at a failed run.  At the bottom of the set content approval action (assuming that is what failed), you'll see an error message.  Cam you please post the full error message?

[Hamid]

it happens only after I approve/reject the request:

{

"error": {

"code": 502,

"source": "flow-apim-msmanaged-na-eastus2-01.azure-apim.net",

"clientRequestId": "230bca6b-2cb3-4b03-a3fa-1b95d08afc69",

"message": "BadGateway",

"innerError": {

"status": 500,

"message": "Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))\r\nclientRequestId: 230bca6b-2cb3-4b03-a3fa-1b95d08afc69\r\nserviceRequestId: 230bca6b-2cb3-4b03-a3fa-1b95d08afc69"

}

}

}

thank you 

[ScottShearer · Accepted solution]

@Hamid 

I assume that you are using your credentials for the Set content approval connection.  Can you go directly to the SharePoint site and verify that you can update items in the library?  The error contains an Access denied message.

[Hamid]

Hi Scott,

I have access to the Sharepoint as I am the one who test the flow and put/modify the items in the folder. is it possible the access denied is from Flow side? 

Thank you 

Hamid

[ScottShearer]

@Hamid 

Is the error still happening on the first set content approval action?  I noticed that you have 2 of these of these actions in a row - can you tell me why?

[Hamid]

Hi Scott, 

Yes that duplicate created by mistake, I eliminated it in the beginning. The error is still there 😞

thank you 

[Hamid]

I tried to modify it a little. still have the same issue. it says access denied although I created the folder in the sharepoint and put the file in it to be approved. I appreciate if you can help me to figure this out

[Hamid]

@ScottShearer 

I see this topic says it was solved but I still have the same problem. Can I put it back to unsolved so the ticket stays open

Thank you 

Hamid

[Hamid · Accepted solution]

I found it, The problem was because I was not the owner of the folder in Sharepoint I only had permission to edit. The person who created the file gave me "owner" permission and the was solved. 

Thanks