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

List rows present in a table locks Excel file after flow completes

I have a flow that reads rows in an Excel file stored in SharePoint and updates SharePoint items based on the Excel data found. It doesn't update the Excel file at any point.

 

I use the "List rows present in a table locks Excel" Excel Online (Business) action.

 

I want to be able to delete the Excel file soon after the Flow has completed, but currently in the SharePoint UI I get a message that "The file is currently checked out or locked for editing by another user.". This prevents me from deleting the file, even if I am the person listed as the user that has the file checked out.

 

Is there an easy way (not powershell) for the end user to unlock the file?

2 REPLIES 2
Highlighted
Community Support Team
Community Support Team

Re: List rows present in a table locks Excel file after flow completes

Hi @DavidG,

 

I have made a test on my side and the issue is confirmed on my side.

I would post this issue to my product team, if the issue is solved, I will reply here.

 

Best regards,

Alice

 

Community Support Team
Community Support Team

Re: List rows present in a table locks Excel file after flow completes

Hi @DavidG,

 

I get the feedback that it is an known limitations for Excel Online (Business) and Excel Online (Onedrive) connector that an Excel file may be locked for an update or delete up to 1 hour since the last use of the connector.

 

Please refer to link below:

https://docs.microsoft.com/en-us/connectors/excelonlinebusiness/

 

Please mark your post as solved if your question is answered.

 

 

Best regards,

Alice

 

Helpful resources

Announcements
firstImage

Microsoft Flow Online Conference

Join us for a FULL day of FREE Microsoft Flow Sessions from some of the best minds in the industry!

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!

thirdImage

New Flow Community Board!

Check out the new Microsoft Flow Community Blog Topic Suggestion board!

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!

Users Online
Currently online: 51 members 4,288 guests
Please welcome our newest community members: