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.

[Chakkaradeep]

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

[bpmpower]

Hi @Chakkaradeep 

Yes, ‘Set content approval status’ action allows you use set the content approval status on a item or a file.  It worked.  In my case, it works for Document Sets. 

Questions:

1.  But, it did not work for the documents inside the Document Sets.  When 'Approval Status' for a document set was 'Approved' but the documents inside it remain as 'Pending'

2. After 'Set content approval status to approve' , I have a 'Copy folder' step which copies the Approved Document Set from library1 to library2.  It copied.  But,  since I used Filter Query (Publish eq 'yes') in Get files (properties only) action in the first action, for subsequent document sets, it copies all document sets again because I cannot filter by 'Approval Status' - this column seems to be hidden.  I have read some posts which mention using 'Send an HTTP request to SharePoint'.  But, I still couldn't get it work. 

I have been trying for 3 weeks!!  Your help is appreciated.