Allow MS Flow to update the SharePoint list Content Approval "Approval Status" field.

[LEEBE]

Flow provides a feature to perform content approval via Mobile App or Email, however, it cannot update the "Approval status" field back to the list.  This is great if we could have this feature because it will virtually lock the item from updating again, or it will require to be re-approved.

[BridgetZ]

Yes! I even tried to set a condition that if the Response to the Approval is Approve to change the "Apporval Status" column like you can in SharePoint Designer. But that column is not an option even when I use the new "Get Files (Properties only)" action and you have Approvals turned on in the Library settings.

[JesperWest]

Cannot believe this is not supported yet.... needed this in year 1999

[AndersFagerberg]

Agree

[Ruteclrp]

Much needed

[RyanMesser]

Required to be able to go to Flow fully from SPD workflows.

You could potentially trick it using the task outcomes and a SPD workflow that reads the task outcomes but in my experience it's easier to use SPD workflows. As soon as you can update Approval Status in flow we can fully migrate from SPD.

[Eddery]

agree

---

@LEEBE wrote:

Flow provides a feature to perform content approval via Mobile App or Email, however, it cannot update the "Approval status" field back to the list.  This is great if we could have this feature because it will virtually lock the item from updating again, or it will require to be re-approved.

---

[grice]

Agree! 100%

In the meantime, however, what are some of you doing to rectify the problem currently?

-GR

[BridgetZ]

@grice

I have setup the flow to copy the file to another library or folder based off the approvers repsonse. There is no MOVE action so I do a Create File and then a Delete file so it looks like it moves. Of course then we lose the created by information but that is the best I could come up with. I would love to hear other suggestions.

[RyanMesser]

I did try updating Content Approval Status by using tasks and a counter variable but I couldn't get it to work fully and meant I had to run both workflows (to see the task status) and flow together.

I reverted back to 2010/2013 SP workflows but if Flow is meant to be its replacement then its got a long way to go and Approval Status is the big one I think.

[CoupalM]

Need to read and upate "_ModerationStatus". This is a must to get rid of SharePoint Workflow.