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

Set Content Approval Action failing, even though it's working as expected.

 

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:
01.PNG02.PNG


Outputs Details

4 Retries - Details:

1st Retry:

Duration: 1s
Start time: 2018-01-16T19:57:54.0902707Z
End time: 2018-01-16T19:57:55.2933899Z
Status: InternalServerError
Client request ID: 4ab2d389-9889-453e-b8bb-df35a746f33b
Service request ID: 4ab2d389-9889-453e-b8bb-df35a746f33b


Retry 2-4 (Start and end times differ, but same error):

Duration: 1s
Start time: 2018-01-16T19:58:32.8113726Z
End time: 2018-01-16T19:58:33.4832728Z
Status: BadGateway
Client request ID: 1c144d55-a01a-47e6-ba12-c38d0279fac5
Service request ID: 1c144d55-a01a-47e6-ba12-c38d0279fac5


Status Code: 502

KeyValue
Pragmano-cache
x-ms-request-id331802e6-ec27-4875-94cc-3e9bd72e825d
Timing-Allow-Origin*
Cache-Controlno-cache
DateTue, 16 Jan 2018 19:59:19 GMT
Set-CookieARRAffinity=622c74dd20820a29ad038bb6f18c30fe85f84009541dc1341e4efd23c045ffea;Path=/;HttpOnly;Domain=sharepointonlineconnectionprovider-westus.tip0-westus.p.azurewebsites.net
X-AspNet-Version4.0.30319
X-Powered-ByASP.NET
Content-Length373
Content-Typeapplication/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?

6 REPLIES 6
Community Support Team
Community Support Team

Re: Set Content Approval Action failing, even though it's working as expected.

Hi @McThrustin,

 

Could you please share a full screenshot of your flow's configuration?

Could you please show a bit more about your SharePoint list?

Further, do you enable Content Approval in your SharePoint list?

 

Thanks for your feedback, the issue is confirmed on my side, I would post this issue to my product team. If the issue is solved, I would reply here.

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
McThrustin
Level: Powered On

Re: Set Content Approval Action failing, even though it's working as expected.

Hey @v-xida-msft,

Regarding your questions:

  • Could you please share a full screenshot of your Flow's Configuration?
    See images below:
    01.PNG02.PNG03.PNG04.PNG
  • Could you please show a bit more about your SharePoint List?
    What would you like to know about it? 
    It's a custom list in a Team Site in SharePoint Online, using a Site Content Type that I created.  
    It uses all out-of-the box features.  I have checked that the service account that is running my Flow has the correct permissions to update the Content Approval Status.
  • Is Content Approval Enabled on the List?
    Yes, Content Approval is enabled on the list, and the Flow appears to be updating it correctly (though it still reports errors).


Let me know if you need anything else.

McThrustin
Level: Powered On

Re: Set Content Approval Action failing, even though it's working as expected.

Hey @v-xida-msft,

 

Do you have any follow up on this issue? 

I have not heard back in almost a week since sending you the information you requested.

MitchC3
Level: Powered On

Re: Set Content Approval Action failing, even though it's working as expected.

Did you ever find a fix to this? I am having the same issue right now. User has contribute access to two lists being used, but approval status fails. When a SharePoint owner tries, works fine

McThrustin
Level: Powered On

Re: Set Content Approval Action failing, even though it's working as expected.

Hey Mitch,

After a few months of no response from Microsoft, I tested my flow on a whim and the error was gone. No update from Microsoft as to if they made any fixes.

As for your issue, is the flow running as the user account with contribute rights or as a site owner?

If the flow is running as the user with contribute rights, it is likely failing because you need approver rights to set content approval status, the minimum out-of-the-box permission level needed for this is Design. I would try adding those permissions to the user account that is failing and see if that helps.

See:

https://docs.microsoft.com/en-us/sharepoint/sites/user-permissions-and-permission-levels#default-per...

For more info.
MitchC3
Level: Powered On

Re: Set Content Approval Action failing, even though it's working as expected.

I am an owner and another owner co worker can run it fine. So, now I'm just trying to find out what is the minimum level of permissions for someone to approve. Might have to create some custom advanced settings instead of the presets.

 

Edit: Whoops just read your reply more carefully, thanks for the help!

Helpful resources

Announcements
firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

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!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (5,830)