cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Hamid
Level: Powered On

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

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

Hamid
Level: Powered On

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

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
Hamid
Level: Powered On

Re: Sharepoint approval status is not updated/ badgateway

Flow approval.png

 

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

Super User
Super User

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
Hamid
Level: Powered On

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

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

Hamid
Level: Powered On

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

Super User
Super User

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
Hamid
Level: Powered On

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 

Hamid
Level: Powered On

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

 
Hamid
Level: Powered On

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

Hamid
Level: Powered On

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

Power Platform Online Conference

Speakers, submit your sessions now! Call for speakers ends Feb. 10!

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!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,553)