web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Multi layered approval...
Power Automate
Answered

Multi layered approval flow

(0) ShareShare
ReportReport
Posted on by 10

Hi

I created a three level sequential document approval flow that also updates the document library to show the status of the approval

The approval starts once a new document is added to the sharepoint library.

The flow send an email to the approvers with a link to the document so they can review and decide on approve or reject

Once they take an action, the relevant document library is updated with the following information:

approver decision

approver comments

date and time stamp

This is to help us track where the document is and its status

That process works fine until one of the approvers keeps the document open on their browser. In this case, the library doesn't update because the item is locked by a user

I thought of creating a parallel flow to update a share point list to avoid all together the document locking issue

So I can create a library list item that adds a record when a new document is added to the library, but I cannot pick that record to update the other fields as the approval flow progresses

karimibrahim_1-1593715539365.png

 

When I use update item after the approval block, I don't know how to select the proper ID/Title to update. So the end result is that the list doesn't get updated

karimibrahim_0-1593715433741.png

karimibrahim_2-1593715605142.png

any idea how I can do this?

thanks

 

Categories:
I have the same question (0)
  • Verified answer
    ScottShearer Profile Picture
    25,290 Most Valuable Professional on at

    @karimibrahim 

    Why not avoid the issue entirely by attaching a copy of the document to the approval.

    Details on how to do so can be found here.

     

     

  • karimibrahim Profile Picture
    10 on at

    Hi Scott,

    This almost worked!

    the files I am approving (purchase requisitions) have an internal attachment to a sharepoint library (quotes)

    When I had them as a link before your proposal, I was able to open the file and the link inside the file from my phone (because the phone would open excel online)

    When I did the attachment, I cannot open the link from my phone because the viewer is not excel.

    On the desktop, it is the same, if I use the email viewer, the link doesn't work. I have to open excel for it to work

    So good solution but new problem

    thanks

    Karim

  • ScottShearer Profile Picture
    25,290 Most Valuable Professional on at

    @karimibrahim 

    Will it work for you if you install the mobile Office apps on your Phone?

     

  • Verified answer
    v-alzhan-msft Profile Picture
    Microsoft Employee on at

    Hi @karimibrahim ,

     

    You could create the flow as below:

    1.png

     

    Best Regards,

    Alice

     

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • RSharma03 Profile Picture
    2 on at

    @karimibrahim , I am facing the same issue too. Not sure if you are able to fix it yet. If so, help me to advise - the flow that I set up is works fine fine until one of the Approvers keeps the document open on their browser or edited and shared back. In this case, the flow is not running ahead and updating the item/approval status in the library.

  • karimibrahim Profile Picture
    10 on at

    Both solutions worked

    If you can live with only one document for approval without the need to open a link in it, then Scott's suggestion is the simplest

    In my case, I had to open a second document from the first one, so I created the list

    Alice's suggestion worked and I can update the list to track progress

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 796

#2
Valantis Profile Picture

Valantis 568

#3
Haque Profile Picture

Haque 538

Last 30 days Overall leaderboard