cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AlanPilz
Advocate I
Advocate I

Approval Status Column not available for setting a condition

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!

 

2 REPLIES 2
v-xida-msft
Community Support
Community Support

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

 

 

 

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.
DavidMDrever
Frequent Visitor

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,801)