cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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!

 
2 REPLIES 2
Highlighted
Community Support
Community Support

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.

Hi, @v-xida-msft 

I have similar issue with my approval flow. How can I rerun "Update the file properties" action after the file has been closed?

Thanks,

Satenik

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (8,542)