We have several use cases where a document needs to go through several approvers in a sequential path. Each approver may need to update the document. The problem is that if the document is open still after approver 1 has completed the approval action, the flow fails instead of moving forward to the next approver.
Then your only choice is to redesign the flow into multiple flows and make sure that people close the document between each flow. There is no way to force approval to work with an open document.
Unfortunately this is not the case. I have tested using Word Online and get the same failure in flow
Unfortunately this is not the case. I have tested using Word Online and get the same failure in flow
Then Option 2 is your only choice. If they make the changes using Word Online it shouldn't prevent the approval from proceeding.
Unfortunately the users have to update the document and should be closing before approving but in too many cases they are opening
There are two options to prevent this.
1) Have the flow check the document out when the approval process starts. At that point users will only be able to open read only copies which won't lock the document.
2) Teach users to use Office Online to view the document. Office Online allows for co-authoring which should keep the document from being locked when the flow tries to approve it.
@Karen_H you can implement logic to retry process after failure to handle this situation. Reference: https://sharepains.com/2019/09/27/retry-after-failures-power-automate/
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional