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.
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.
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...