Excel Online Table Name Changing After Run

[SChorkawy]

Hello, 

I'm trying to import data from an excel sheet into a SharePoint list. 

My flow is triggered by "When a file is created or modified (properties only)" trigger for SharePoint. 

I then use the "List rows present in a table" action for Excel Online (Business).  

My flow works as expected during the first run.  On the second run I receive the following error message. 

No table was found with the name '{E5853258-8B64-4462-AB0C-A3E20225A269}'.
clientRequestId: 138b4399-c238-45e4-ad81-392966f40e92
serviceRequestId: 41586a4c-0adc-4e59-b650-60373138f895

It appears that the table name is changing from Table1 to a different value. 

[v-litu-msft · Accepted solution]

Hi @SChorkawy,

In case after rename table name Flow couldn't find the table, you could use the Get tables action to list all tables, then append the Table ID as dynamic content into Table field:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SChorkawy]

Hello @v-litu-msft, 

I tried using Get tables, but it results in another error. 

{
  "status": 404,
  "message": "The resource could not be found.\r\nclientRequestId: a6f1acb2-c6d4-417b-9b77-eee3dcf6eae0\r\nserviceRequestId: 525d83f3-b158-4910-bab1-50187b2b66ea",
  "error": {
    "message": "The resource could not be found."
  },
  "source": "excelonline-ce.azconn-ce.p.azurewebsites.net"
}

I tried selecting the file through the File Browser as you did in your example.  In the screen shot below you can see I'm using the file ID from the flows trigger.  Both cases result in the same error message. 

Any suggestions would be appreciated. 

[Anonymous]

In these flow actions the Excel file "name" and the table "name" are recorded by their GUID-type IDs.

If you carry out certain operations on the file, such as a move or a replace with a new files "of the same name" it will result in a different ID which does not match the one stored in your flow.

To get around this you can do as suggested and *each time the flow executes* determine the ID of the file from filename, then determine the ID of the table in the file, and use these dynamically.

I'm not saying this IS your issue, but it certainly could be!

[v-litu-msft · Accepted solution]

Hi @SChorkawy,

Please use the Identifier instead of ID:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SChorkawy · Accepted solution]

Hi @v-litu-msft thank you for getting back to me! 

Using Identifier fixed both of my problems!

[joshua-wolff]

I'm still getting an error when running the flow. The table 'id' field is being modified each time I modify the file. I'm addressing that using 'get tables' with no issue.

The flow fails at Apply to each -> List rows present in a table - 'NotFound' error. I've used 'id' dynamic content and I've also tried 'name' since it provided the actually table name string. 

For context, I'm using a personnel roster that is regularly updated and changed, hence my need to modify the file. It is a sharepoint file and my flow is triggered by file created/modified (properties only). Help!

[joshua-wolff]

Solved my own problem with a bit more digging. I'm bulk uploading files and the table IDs match the generic 'table1.' I ended up editing my file created/modified (properties only) trigger to output an array (JSON). Then I just parse the JSON and enable the {Identifier} value in dynamic content. I can feed the {Identifier} into get tables: file field and use Excel ID no problem. Thank you for the post!