Using Power Automate for document publishing approval

John_Ravas_Schdy 

Hi, I do this in my Content Approval flow, but it's set up a different way from yours.  I don't use any variables and my flow never gets cancelled because of an update.  I also have multiple approvals.

My first approval is for QC and puts the document into Pending status in SharePoint.

My second approval is for actual approval and puts the document into Approved status in SharePoint.

Here is how I handle the comments:

Approval action

Condition if approval = Approved

YES

If Content Approval Status = Pending

check out file

check in file to draft

Get file metadata

Set content approval to pending, and I enter here the comments I want to be placed automatically into the version history.  You can include fixed text but also include the field to enter the comments that the approver types into the power automate flow when they hit the approve button.

Set content approval to Approved, and here I enter the comments I want to show up in the metadata column.

How the set content approval action works is that when you set it to draft or pending it puts the comments into the version history.  When you set it to approve or reject it puts the comments into the column metadata of the library.

By checking out the file and checking it back in as draft, then re-setting the published action, you can put it to pending yourself and control the comments.  

Hi John_Ravas_Schdy 

Can you please show us what your flow looks like (perhaps from the point where the issue begins to occur though if you can show all that would help)? A visual may help us to pinpoint the issue.

Cheers

Damien