I have tried to create a flow that triggers when an email with an attachment is received. It then downloads the attachment to OneDrive to a file named Employees.xlsx. This portion of the flow works perfectly. I need to read the data within the Excel file to post it to an SP list. Since Get Rows is deprecated and my file does not have a table I need to use the Create Table with Excel Online Business. I have tried this within one flow with a delay of 5 minutes between the Create File and the Create Table actions and receive the following error from the Create Table action:
I have tried to set this up as two flows with the first getting the attachment from the email and saving and the second triggered by a new file creation. The second then tries the Create Table with a delay of 5 minutes before hand with the same issue. I have scoured the forums and the internet and this seems like a common problem along with file locking issues. Is MS Flow just not mature enough yet to handle an operation of this sort? I have seen one implementation that utilizes the Graph but if I have to go that route I would pursue other options and eliminated the reliability issues of Flow altogether. Any direction would be appreciated. Thanks.
Solved! Go to Solution.
I have a problem with the same scenario:
User clicks a button in PowerApp that calls a flow sending it data to add to excel.
Flow creates excel file in OneDrive for Business (copied from a blank template)
Excel for Business GetTables is called for the created file
Rows received from the power app are added to excel
It all works, except that when somebody else than me executes the power app, the excel file gets created, but I get a 404 error on the GetTables step, even though I'm using the Id property to identify the created file.