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?

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

 

>