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:

Using flows

I have the same question (0)

All responses (8)

Answers (0)

ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
tesla3driver 50 on at

Like (0)

Report

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? 😞

Was this reply helpful? Yes No
v-yuazh-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
tesla3driver 50 on at

Like (1)

Report

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

Was this reply helpful? Yes No
v-yuazh-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
GabrielStJohn on at

Like (0)

Report

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

Was this reply helpful? Yes No
DavidMDrever 10 on at

Like (0)

Report

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/

Was this reply helpful? Yes No
icimasa 64 on at

Like (0)

Report

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

Was this reply helpful? Yes No