cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Azaerol
Frequent Visitor

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
Community Support

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
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (6,813)