Create Table Action

[Mark_Ball]

Good day,

I am having an issue with the Create Table action. High level, my flow design is:

Smartsheet emails me an excel file > Power Automate watches for email > Grabs file and places into my SharePoint site, documents folder (using the Sharepoint Create File action)

The steps I've built above work and are repeatable during my testing. Happy with that, I add my next step. I need the Excel worksheet in a table format in order to pull the data from it and populate my SharePoint List.

Next, I add the "Excel Online Create Table" action (tried both inside the Apply to Each as well as added outside of it). Now the very first time I ran my test, it worked! Great. But to ensure everything works in my flow to this point, I want to run it again before adding more steps. 

I ran the whole test flow again, emailed the file to myself and this is where the error happens. At the SharePoint Create File action, the step immediately errors saying locked by a user (me). I confirmed I wasn't in it. I tried waiting 5, 10, 15, & 30  minutes then rerunning the flow. I still get that same error. My assumption is the Create Table action is somehow keeping me locked in the document. I've read blogs, watched YouTube vid's trying some ideas from those, even prayed to the IT gods and still no luck in overcoming this error. Is there a step I can add after the Create Table step to kick me out of the document?

Here is my flow so far: