cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 
LEEBE

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

Submitted by Advocate I on โ€Ž09-20-2017 02:58 AM

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

See more ideas labeled with:
32 Comments (32 New)
Comments
BridgetZ
Advocate IV
Advocate IV
โ€Ž09-28-2017 07:59 AM

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
Regular Visitor
โ€Ž10-06-2017 02:22 AM

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

AndersFagerberg
New Member
โ€Ž10-06-2017 03:46 AM

Agree

Ruteclrp
New Member
โ€Ž10-06-2017 09:00 AM
Much needed
RyanMesser
Frequent Visitor
โ€Ž10-07-2017 04:59 AM
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
New Member
โ€Ž10-08-2017 07:05 PM

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
Frequent Visitor
โ€Ž10-18-2017 05:45 AM

Agree! 100%

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

 

-GR

BridgetZ
Advocate IV
Advocate IV
โ€Ž10-18-2017 06:24 AM

@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
Frequent Visitor
โ€Ž10-18-2017 06:28 AM

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
Advocate II
Advocate II
โ€Ž11-03-2017 03:47 PM

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