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?
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.
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:
Please mark your post as solved if your question is answered.