Excel "No table was found with the name" even when getting table by ID or Name

[stefan_kudev_kb]

I've created the following structure for my automation: 

This was the suggested way of ensuring I get the correct table(s) from the file.

Unfortunately, I am running into this error:

Even if I modify the "Table" field to use Name, instead of Id, I receive the same error.

Any suggestions?

[fchopo]

Hi @stefan_kudev_kb 

Hi did a test on my side and its' working fine:

Could you check that the values entered in the "Row" field are formatted accordingly?

Hope it helps!

Ferran

[stefan_kudev_kb]

Hi Ferran,

Sadly even with just a sample JSON input matching one of the column names, I get the same error:

and I'm certain this is a valid column within the only table that exists in that file:

Is there perhaps another way I could approach this?

My current flow is:

1) OneDrive copies an empty template file into a file called "Latest Risk Register Export.xlsx", overriding the previous one.

2) Excel runs "Get table" for the new file to get the Unique ID of the empty table.

3) SharePoint gets all rows from the identically named SharePoint list.

4) For each row in SharePoint, I run:

4.1) Compose is used to typecast the data into a suitable format:

4.2) Then excel runs "Add row into table" for each table found (there is only one)

6) OneDrive copies the "Latest Risk Register Export.xlsx" file, renaming it to "yyyy-mm-dd Risk Register.xlsx"

Is there perhaps a more elegant solution which could prevent the issue? 

Thanks in advance.

[fchopo]

Hi @stefan_kudev_kb 

I think that the problem is that every time you run the flow, a new Excel file is created (Latest Risk Register Export.xlsx) overriding the previous one. So probably, the action "get tables" is referencing a different file (although it has the same file name).

Could you check that? (display table IDs every time you run the flow)

Regards,

Ferran

[stefan_kudev_kb · Accepted solution]

Hi Ferran,

Unfortunately that wasn't the solution either, but I did find a workaround to all these issues by using variables and exporting my array of results to a CSV. This worked perfectly for what I was trying to achieve.

Here is a screenshot of the full flow for anyone else that might be having a similar problem:

BR,

Stefan

[smurfpow]

Hello,

I have the same issue and found a solution.

Basically you just have to choose "custom value" instead of a variable and type your table name (e.g. table1)

So whenever the file is being replaced it will just look for "table1" instead. 

Hope this works. 🙂