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

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

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 Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,266)