Forum Discussion

John_Ravas_Schdy's avatar
John_Ravas_Schdy
Copper Contributor
Mar 03, 2020

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...
File Approvals
Damien_Rosario's avatar
Damien_Rosario
Silver Contributor
Mar 05, 2020

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

  • John_Ravas_Schdy's avatar
    John_Ravas_Schdy
    Copper Contributor
    Mar 06, 2020

    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 

Resources