Approval Status Column not available for setting a condition

[AlanPilz]

Hi

I am trying to create a very simple flow to notify specific groups of people when a document has been approved. The approval process is being handled using the standard OOTB SharePoint 2010 Approval Workflow. The document library shows the Approval Status column that reflects the Workflow status, and is working well.

I was hoping that Flow could be used to extend the OOTB workflow behaviour in such a way that when this status changed to Approved it would triggger an email?

However, when I set up a flow using "When an tem in a SharePoint list is modofied send an email" template and try and add a conditional, the dynamic content does not display the column Approval Status?

As a test I added a new column "Status" and that appears and works well, but it has no association to the approval workflow status.

I feel this should be a very common use case and I'm sure either I am going about tackling the problem in the wrong way or I'm going crazy!

Help wanted from any flow guru!

[v-xida-msft]

Hi @AlanPilz,

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

Further, do you enable Content Approval within "Library settings-> Versioning Settings" of your SharePoint library?

I suppose that you have enabled Content Approval within your SharePoint library, the "Approval Status" column is created in your SharePoint library automatically.

Using or updating the Approval Status column is not supported in Microsoft Flow currently, if you would like this feature to be added in Microsoft Flow, please vote the following idea:

https://powerusers.microsoft.com/t5/Flow-Ideas/Allow-MS-Flow-to-update-the-SharePoint-list-Content-A...

Best regards,

Kris

[DavidMDrever]

I am just posting a reply here because this post came up during my own search for a solution and I would like to provide the solution I came up with even though this is an old post.

I came up with a way to do this using an HTTP call into the SharePoint list\library.  This likely isn't anything new, but I wasn't able to find a post that highlighted the steps I came up with.  To determine the approval status of a document\list item you simply have to access it using the following REST call: _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...