Unanswered

check if approval status is "Pending"

(0) Share

Report

Posted on by tesla3driver

Hi,

I'm creating a simple flow that trigger on item update or change and i want to have a condition to check if the Approval Status of the item is "Pending".. But I don't find the Approval Status column amonge the options in the conditional branch..

any ideas

regards

Martin

Categories:

General Discussion

All responses (8)

Answers (0)

icimasa 64 on at

Like (0)

Report

Re: check if approval status is "Pending"

Hi, great post. I will definitely have a look at your solution. Cause today we use the old approval workflow and it is really not stable and outdated so I really want to be able to do the same but with Flow instead. 🙂 regards Martin
DavidMDrever 10 on at

Like (0)

Report

Re: check if approval status is "Pending"

Hi everyone, I realize this is an older post but I found it while looking for a solution. However, I came up with my own solution that works within a standard Flow and just requires an HTTP call into SharePoint to get the status. If you would like to see a step-by-step process of determining the approval status you simply need to hit the endpoint: _api//web/lists/GetByTitle(‘<Title>’)/items(<ID>)?$select=OData__ModerationStatus

For more information please see my post here: http://prairiedeveloper.com/2018/12/microsoft-flow-determine-the-approval-status-of-a-sharepoint-list-or-library-item/
GabrielStJohn on at

Like (0)

Report

Re: check if approval status is "Pending"

Hello, @icimasa!

Have you had an opportunity to apply @v-yuazh-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify! Thank you for being an active member of the Flow Community!

-Gabriel

Flow Community Manager
v-yuazh-msft on at

Like (0)

Report

Re: check if approval status is "Pending"

Hi @icimasa,

The Approval Status field is not integrated in microsoft flow currently,and the Approval Status field is not available in Flow selection,

If you would like the Approval Status field to be available in Flow selection,you could submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Best regards,

Alice
tesla3driver 50 on at

Like (1)

Report

Re: check if approval status is "Pending"

Hi @v-yuazh-msft

Well I had that thought however a document is in draft until it becomes pending so I would have somehow to copy the approval status column to the new custom column! My question more is why is the Approval Status filed now available in Flow selection??

Regards
Martin
v-yuazh-msft on at

Like (0)

Report

Re: check if approval status is "Pending"

Hi @icimasa,

As an alternative way,you could take a try to add a choice type "approval status" column in the list or library manually,and set the defaults value of the "approval status" column to "Pending".

Best regards,

Alice
tesla3driver 50 on at

Like (0)

Report

Re: check if approval status is "Pending"

Hi,
Thx for the reply and yes that is what I mean and that is a real shame cause I try to auto start and approval flow based on check in major version and it seems that I will not be able to do that with flow? 😞
ScottShearer 25,208 Most Valuable Professional on at

Like (0)

Report

Re: check if approval status is "Pending"

If you are using a SharePoint list or library and are referring to the Approval Status column that is added when you check the "require content approval" box, unfortunately that column is not exposed in Flow at this time. I wish it was....

Scott