cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Azaerol
Level: Powered On

Action 'Update file properties' failed because document is checked out by approver

Hi,

 

I am running into some problems when creating an approval flow. My setup is pretty basic: For a selected item in a SharePoint library I manually trigger my approval flow. When the person to whom the approval is assigned to has reacted (either Approved or Rejected the document) two things happen:

  1. An email is send to the person initiating the flow saying that the document has been either approved or rejected
  2. The file properties in the SharePoint library are being updated with the Comments and Approver name (I've added a column for both values).

The approval flow itself runs without problems. The only problem I am facing is the fact that sometimes the Flow fails because the approver has checked out the document. This results in a failed flow. The failure summary states that the "Action 'Update file properties' failed", with error details: the file (file location) is locked for shared use by (the approvers email address).

 

How can I avoid this? I want to make sure that the fields in my SharePoint library always get updated with the Approvers name and their Comments, even when the document is (involuntarily) checked out by the approver.

 

Thanks in advance!

 
1 REPLY 1
Community Support Team
Community Support Team

Re: Action 'Update file properties' failed because document is checked out by approver

Hi @Azaerol,

 

Could you please share a screenshot iof your flow's configuration?

Could you please show more details about your SharePoint library?

 

The error message is told that the specific file is loacked for the approver. In other words, the approver is viewing or editing your file and your file is in open status.

 

If you want the fields in my SharePoint library always get updated with the Approvers name and their Comments, even when the document is (involuntarily) checked out by the approver, I afraid that there is no way to achieve your needs in Microsoft Flow currently. 

 

If the file is opened by another shared user, you could only read this file on your side and could not update this file. Currently, I have no idea to how to avoid this issue except sending an email to approver to close the opening file if the file is locked for shared user by approver (the "Update file properties" action failed).

 

You could consider take a try to configure a fun after action under the "Update file properties" action, if the "Update file properties" action failed, send an email to the approver to close the opening file. I have made a test on my side and please take a try with the following workaround:16.JPG

 

17.JPG

More details about adding a configure run after action, please check the following article:

https://flow.microsoft.com/en-us/blog/error-handling/

 

Please check and see if the following article would help in your scenario:

https://support.microsoft.com/en-sg/help/313472/the-document-is-locked-for-editing-by-another-user-e...

 

 

Best regards,

Kris

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

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 127 members 4,363 guests
Please welcome our newest community members: