cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Davinci
Frequent Visitor

No table was found with the name

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


setup1.jpg

setup3.jpgsetup2.jpg

 

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

 

6 REPLIES 6
CheckMate
Resolver I
Resolver I

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
Solution Sage
Solution Sage

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.

 

ericcheng_0-1627359199346.png

 

--------------------------------------------------------------------------
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

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

 

setup5.jpg

 

setup6.jpg

eric-cheng
Solution Sage
Solution Sage

 Hi @Davinci ,

 

Can you delete and readd the action.

 

1) Add the List rows in a table action

2) Click on Enter custom value

ericcheng_0-1627455316886.png

3) You should now be able to select Table Name

 

ericcheng_1-1627455393919.png

 

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

 

ericcheng_2-1627455424081.png

 

--------------------------------------------------------------------------
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

 

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?


setup7.jpg

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (3,151)