cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
samrutur Advocate IV
Advocate IV

SharePoint - Set content Approval status

Using the SharePoint connector - Set Content Approval Status action. The Submit action works but when the action is set to Approve or Reject, the Flow runs without any errors but the Approval Status doesn't change to the Approved. The same thing for Reject action and doesn't work.

Capture.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: SharePoint - Set content Approval status

Hello Guys,

 

i recently came accross the same issue. I managed to solve the issue eventually. Follow the steps below for succes:

 

  1. Action to receive Item Information (ID)
  2. Action to Receive Metadate for Item based on (ID)
  3. Expand the Action to Update Content Approval to Advanced and Reference the E-Tag as shown here:ETag.png

 

Best Regards,

Robert from implexis GmbH

View solution in original post

14 REPLIES 14
Community Support
Community Support

Re: SharePoint - Set content Approval status

Hi @samrutur,

 

Have you enabled content approval for your SharePoint library?


The following doc could be a reference for you:
https://support.office.com/en-us/article/Require-approval-of-items-in-a-site-list-or-library-cd0761c...


After you enabled require content approval for submitted items, there would be a column named as “Approval Status” automatically created in your library.


To test this issue, I created a flow likes below to test this issue.


It works fine when the file is uploaded to the library, and the status of column Approval status would be changed from Pending to Approve.

3.PNG

 

Please try again with it and feel free reply if you need more help.

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
samrutur Advocate IV
Advocate IV

Re: SharePoint - Set content Approval status

Hi @v-yamao-msft,

 

The library I am working with has major, minor versioning and content approval enabled. The trigger I am using in the Flow is schedule recurrence and tried it with item create trigger as well but doesn't work. 

bvol
Frequent Visitor

Re: SharePoint - Set content Approval status

I am seeing the same behavior as samrutur, and I have enabled the versioning as suggested.

bvol
Frequent Visitor

Re: SharePoint - Set content Approval status

Have you had any success in getting this work? If so, please let me know what was the issue, I am still having trouble.

bvol
Frequent Visitor

Re: SharePoint - Set content Approval status

I have figured out my issue. I misspelled the name of the Library Name. When using a Custom entry with a misspelled name, you will still get "Success" as the status, but nothing actually happens.

Highlighted
samrutur Advocate IV
Advocate IV

Re: SharePoint - Set content Approval status

@v-yamao-msft,

 

I tried it on a different tenant and the same issue. The error message from the action when the Flow runs is: Message":"The ETag of this item does not match the one used for setting content approval status. The contents of the item may have changed before the action was completed."

Anonymous
Not applicable

Re: SharePoint - Set content Approval status

Hello Guys,

 

i recently came accross the same issue. I managed to solve the issue eventually. Follow the steps below for succes:

 

  1. Action to receive Item Information (ID)
  2. Action to Receive Metadate for Item based on (ID)
  3. Expand the Action to Update Content Approval to Advanced and Reference the E-Tag as shown here:ETag.png

 

Best Regards,

Robert from implexis GmbH

View solution in original post

Anonymous
Not applicable

Re: SharePoint - Set content Approval status

Hello,

 

I am having a problem with the set content approval status. The error message says that "The current state of the item is Draft and the following action Approve cannot be implemented", however, the state in sharepoint is pending.

 

Does anyone who how to fix this?

 

Thanks,

 

Justi

 

 

Approval.PNG

 

vwyankee Helper III
Helper III

Re: SharePoint - Set content Approval status

In my tests it doesn't seem you can do this with Draft states - when you have major and minor versioning enabled - as there's no option to "approve" the status until the version has been published. Once it's been published the state changes from Draft to Pending and Flow can update the approval status. 

 

In my case I reverted to just major versions with only authors and approvers having visibility to versions that haven't been approved. See this thread around using content approval and flow for more info.

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Users online (6,529)