Sharepoint - Get content approval status

[PetersonBriones]

When a set content approval status to Pending by using the submit action, I get this error when the file is already in pending status.

"message": "The current state of the item is Pending and the following action Submit cannot be implemented

I could avoid this by checking if the document is already in pending status before doing this action however there is no action to get the Approval Status of a document.

[MV14]

The possibility get content appproval status would be a big step forward for the approval workflows in Microsoft flow. Now it's hard to check if a document is already approved or not which can cause problems like:Multiple people approving the same document -> flow runs multiple times, difficult to send a daily overview of documents that need approval.

[JoeWilko97]

We need a way to check what the status of an approval is

Currently have a flow which checks for modifications to a folder, once there is a modification a approval request is triggered

However... when this document gets appended to be approved or rejected, it updates the file again, causing another approval trigger

I just need to add in a condition to check the current approval status. However there is no way to do this

[Anonymous]

I am looking for something similar... I am in need of a flow that allows multiple people to be notified of a document update.. 

(Example)

User A adds a item to a spread sheet.

The flow then sends and approval to User B.

User B adds spec info to item User A added to the spread sheet

The flow then sends aditional approval to User C who finalizes the the item setup and then notifies User B it is complete..

[Anonymous]

need to send email notification after the doucment is manually aproved. since Approval Status field cannot be pulled, cannot use MS Flow

---

---

[jvdlinden]

I am looking for this in Logic Apps as well.

The action Set Approval Content Status is available, but the Get ... action isn't...

Very critical

[automaton]

This issue is also affecting me. I want to filter a sharepoint document library and send a notification out for all documents that are still pending approval. But the Approval_x0200_Status column cannot be seen by flow. Very frustrating for something that should be simple.

[DavidMDrever]

Hi everyone,

I agree that this is something that would be a big help for approval flows, however until they get around to it I do have a solution that is pretty easy to implement that should help.  You simply need to parse through a http call to: api/web/lists/GetByTitle(‘<Title>’)/items(<ID>)?$select=OData__ModerationStatus

More information and some step-by-step procedures can be found here: http://prairiedeveloper.com/2018/12/microsoft-flow-determine-the-approval-status-of-a-sharepoint-lis...

[SchneidAIR]

Also consider a Start Condition for your Trigger, for example SharePoint Create/Modify Item:

@equals(triggerBody()['{ModerationStatus}'],'Pending')

Would only start, when the Content Approval is on Pending Status (ModerationStatus)

https://docs.microsoft.com/en-us/openspecs/sharepoint_protocols/ms-wssfo3/4342322d-6fab-4dc5-8ccd-b8...

https://www.techmikael.com/2019/08/update-to-using-microsoft-flow-for.html?m=1