No table was found with the name

[Davinci]

I have a flow that takes an excel file from OneDrive and writes the data to SharePoint. The excel file is created dynamically everyday by a program. After I create the flow, it works. It is scheduled to run once daily. It works for 2 or 3 days then starts failing consistently with the error messages below. 

This is how it is setup

The only difference I see in the hex values is that the values in the setup are in lower case whereas the values in the error message are in upper case. I don't know if this makes a difference. I would appreciate any help

[CheckMate]

you might have to look at the excel file to make sure that it actually contains a "table" (format as table)

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution.
If you have found my response helpful, please give it a thumbs up.

[eric-cheng]

Hi @Davinci ,

First, please check the table exists.

Secondly, if your Excel file is uploaded regularly or you are needing to dynamically reference your Excel, you will need to use the Get Tables action and then passing the correct table name into List rows in table.  

Please see below as an example.  You can add a condition in the loop to find the correct table if you have multiple.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Thanks

[Davinci]

Hi @eric-cheng 

Thanks for your help.
I followed the same scheme as you described above but I am not getting the option to enter the table name. The only option available is Table 1 with a hex value of {00000000-000c-0000-ffff-ffff00000000}. So I choose it.
When I test it one time it works. When I test it the next day I get an error message stating that the flow is looking for Table1 {00000000-000C-0000-FFFF-FFFF00000000} (where the hex numbers are in upper case)

I am passing the correct table name but when the flow runs, it is looking for upper case hex numbers instead of lower case. See second image below

[eric-cheng]

 Hi @Davinci ,

Can you delete and readd the action.

1) Add the List rows in a table action

2) Click on Enter custom value

3) You should now be able to select Table Name

4) The flow should automatically move your action inside a loop

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

[Davinci]

Hi @eric-cheng 
I am not getting the option to choose the "File" variable as you did. Please see image below.
What am I missing?

[eric-cheng]

Hi @Davinci ,

For file, just specify the same filename in your Get Tables which you have statically set.  

For Table, specify the Name dynamic content value from your Get Tables.

Thanks 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

[Human16]

Hi I am also facing the same issue could you please suggest any resolution.

[Human16]

What is the root cause of this issue. Is there any permanent solution to fix this issue as i am getting this error at time span of 20 days for all the flows. 

[Martin1234]

It seems this solution only works when you first format xlsx sheet as a Table. But is there a solution in Power Automate that works with xlsx in default plain formatting without any formatted table inside. Just with the headers and data in cells.

[mheinst]

I had the same problem. I have the feeling it's because of Microsoft updates.

Just copy the File name, delete the file name and select the File again and all fields will be selected correctly.

[no2cl4]

Exactly the same;
I've a flow running from 1 years, without any trouble, adding row to table with table name.
Nothing changed, and suddently, the flow lost the table name and replace it by a (wrong ) id (always the same)
I edit the flow, add the table name manually and go, it works... until next time.....🙄

But each days it lost the table reference in my run and change the name by an unknow ID! Silly, stupid cow...
It seams to be a new bug in the component 'add row to a table' 😐

Please MSFT, correct it!

[dfk-consult]

In source and target excel doc no region in each tab is formatted/defined as "Table".
Open the source excel doc in Excel Online, select/mark the complete data region you want to use as "Table", then goto Menu Start, there to Submenu "Format ...", confirm the question.
In the target excel doc select 1 row and as much columns as in the source "Table". repeat the above steps.  

 

solution: https://learn.microsoft.com/en-us/troubleshoot/power-platform/power-automate/flow-creation/unable-to...