Using Power Automate for document publishing approval
I have a unique use case for using Power Automate to publish a document in SharePoint. We have 2 levels of approval for each document: a document owner and a library approver. With each approval, we are capturing the approver comments. The business wants the comments to be included with the document approval in the metadata. I am using a multi-line text column where we are appending the history. One of the challenges that I ran into was that I could not write the comments to the metadata column during the approval process as it would cancel the approval flow - since the file was updated. To get around this restriction, I captured the comments in a variable, then I write the metadata AFTER the file has been published. The problem is that it takes my published file and changes it to draft as it has been updated. It was suggested that I try to re-publish the document after updating the metadata. However, I cannot publish the document from a draft status. It needs to be pending. I don't see a way to programatically set the approval status back to pending. Does anyone have any ideas on how I can keep the approval comments as part of the document and show the document as published?