cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Hamid
Resolver I
Resolver I

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

@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

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

@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

Flow approval.png

 

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

@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

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 

@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

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

@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

Hi Scott, 

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

thank you 

 

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

 

@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

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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,697)