cancel
Showing results for 
Search instead for 
Did you mean: 

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

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.

Status: Completed

Hi all,

 

Checking back on this - As explained in my previous post, SharePoint connector has an action called ‘Set content approval status’ action that allows you use set the content approval status on a item or a file. There is no need to use ‘Update list item’ action to update the ‘Approval Status’ column. 

 

Thanks,

Chaks

Comments
Advocate IV

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.

Regular Visitor

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

New Member

Agree

New Member
Much needed
Frequent Visitor
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.
New Member

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.


 

Frequent Visitor

Agree! 100%

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

 

-GR

Advocate IV

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

Frequent Visitor

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.

Advocate II

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