cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Sharepoint approval status is not updated/ badgateway

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 

 

 

 
 
 

Error.pngFlow approval.png

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Sharepoint approval status is not updated/ badgateway

@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.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

Highlighted
Helper II
Helper II

Re: Sharepoint approval status is not updated/ badgateway

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

View solution in original post

11 REPLIES 11
Highlighted
Super User III
Super User III

Re: Sharepoint approval status is not updated/ badgateway

@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.

 

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Highlighted
Helper II
Helper II

Re: Sharepoint approval status is not updated/ badgateway

Flow approval.png

 

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

Highlighted
Super User III
Super User III

Re: Sharepoint approval status is not updated/ badgateway

@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?

ETagError.jpg

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Highlighted
Helper II
Helper II

Re: Sharepoint approval status is not updated/ badgateway

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 
Highlighted
Super User III
Super User III

Re: Sharepoint approval status is not updated/ badgateway

@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.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

Highlighted
Helper II
Helper II

Re: Sharepoint approval status is not updated/ badgateway

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

Highlighted
Super User III
Super User III

Re: Sharepoint approval status is not updated/ badgateway

@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?

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Highlighted
Helper II
Helper II

Re: Sharepoint approval status is not updated/ badgateway

Hi Scott, 

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

thank you 

Highlighted
Helper II
Helper II

Re: Sharepoint approval status is not updated/ badgateway

 

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

 
Highlighted
Helper II
Helper II

Re: Sharepoint approval status is not updated/ badgateway

@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

Highlighted
Helper II
Helper II

Re: Sharepoint approval status is not updated/ badgateway

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

View solution in original post

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (8,095)