Hello,
I'm creating a custom approval workflow which allows employees to use the 'Start an Approval' Action to approve or reject items on a SharePoint Online List.
My flow is always erroring out on the 'Set Content Approval Status' step. However, it appears to be doing what it's supposed to: it properly sets the Approved/Rejected status on the SharePoint List, and it adds the comments.
However, it also starts showing that it's 'retrying' up to 4 times, and it always ends with the following error:
Outputs Details
4 Retries - Details:
1st Retry:
Retry 2-4 (Start and end times differ, but same error):
Status Code: 502
Key Value
Pragma | no-cache |
x-ms-request-id | 331802e6-ec27-4875-94cc-3e9bd72e825d |
Timing-Allow-Origin | * |
Cache-Control | no-cache |
Date | Tue, 16 Jan 2018 19:59:19 GMT |
Set-Cookie | ARRAffinity=622c74dd20820a29ad038bb6f18c30fe85f84009541dc1341e4efd23c045ffea;Path=/;HttpOnly;Domain=sharepointonlineconnectionprovider-westus.tip0-westus.p.azurewebsites.net |
X-AspNet-Version | 4.0.30319 |
X-Powered-By | ASP.NET |
Content-Length | 373 |
Content-Type | application/json; charset=utf-8 |
Expires | -1 |
Body:
{ "message": "The current state of the item is Denied and the following action Reject cannot be implemented\"\r\nclientRequestId: 331802e6-ec27-4875-94cc-3e9bd72e825d", "status": 502, "source": "https://[domain].sharepoint.com/teams/pm/_api/SP.APIHubConnector.SetApprovalStatus", "errors": [ "-1", "Microsoft.SharePoint.SPConnectorException" ] }
Anyone know why this is happening?
Were you able to resolve this issue? I have the exact same issue and was wondering if it was something with SharePoint Content Approval and Flow or if my Flow is done properly configured... Thanks!
Hey @sebastienlevert,
No resolution yet but I am working with Microsoft on it. Strangely, when I went to get the screenshots for my Flow errors, one of them had magically 'completed' successfully. I have yet to further test this, but I suspect MS might have done some fixing in the background, though I'm not sure what.
I'll update with more info once I've had a chance to test.
Did you get much further with MS on this?
I am encountering this issue as well. I'd be interested to hear if there is any news around how this action should work.
Thank you,
Sean
I have an approval list for creation of new O365 groups.
I wanted to approve the list items directly from the email using flow.
I tried out myself but for some reason it did not work but using the method described below, I was able to do it. Thank you to the author!
Found this solution: https://www.techmikael.com/2018/05/use-microsoft-flow-to-implement.html#comment-form
I tried it out, I also works for me for approval of Sharepoint list items. Really helpful since microsoft has not implemented list items in "set content approval status".
Note: the approval process can take some time, for test purpose, wait multiple hours, first time took time for some reason, now it works fine.
Note: In "set content approval status", in Library name use List name but not the one from the URL
eg. https://...sites/teamsites/team-orders and the list name is Team orders, use Team orders as library name and not team-orders.
I though of using PATCH function to update the "approval status" field instead of "Set content approval status" but I lack the developers knowledge to write the command
Flow below:
1
2
3
4
5
6
7
8
Don't know if all these steps are needed but it works for me.
Hope this helps!
Hi, @McThrustin
I had similar issue here: https://techcommunity.microsoft.com/t5/PowerApps-Flow/Warning-message-quot-BadGateway-quot-and-quot-...
And simply check if eventually you used receive any solution from Microsoft Flow team, thank you.
Hello,
Maybe you can try this (message 6/6) :
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
28 | |
11 | |
11 | |
7 | |
5 |
User | Count |
---|---|
45 | |
22 | |
14 | |
13 | |
10 |