Forum Discussion
Using Power Automate for document publishing approval
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.