Forum Discussion
John_Ravas_Schdy
Mar 03, 2020Copper Contributor
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, w...
Damien_Rosario
Mar 05, 2020Silver Contributor
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
- John_Ravas_SchdyMar 06, 2020Copper Contributor
Hi Damien_Rosario Thank you for the reply. Attached are 2 parts of my flow.
Part 1 is the where the flow picks up right after the second person approves. First it publishes the document by setting the approval status to approve.
Part 2 continues the flow by taking the approval comments that I have queued up in a variable and updates the document metadata. Our team wants those comments saved for the auditors. When that step completes, it updates the version to x.1 and sets the approval status back to draft. This is confusing to our users because they just submitted the document for approval.
In the final flow action, I attempt to set the publish approval status back to approve. However, it bombs because we are trying to take the approval status from draft directly to approve without first going to pending.
I hope that makes sense.
JR