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.