Power Automate can't find table in excel: No table was found with the name 'SNOW'

1.8k Views Asked by At

I am creating a Power Automate flow, which triggers when a file is dropped into a SharePoint folder.

It triggers fine - and I'm locating the file from the dropdowns in the "List Rows Present in a Table" action.

When it triggers, it errors and says:

No table was found with the name 'SNOW'.

As below:

Power Automate Error

The table is named in the Excel file (Table Design tab):

Excel Named Table

Can you see anything wrong with what I've done? Have I named the table in the wrong place?

1

There are 1 best solutions below

1
Expiscornovus On BEST ANSWER

You can check the tables on a file with the Get Tables action. I would suggest to use a Get Tables first before the list rows action. That might help troubleshooting the issue of not being able to find your SNOW table.

enter image description here

Btw, how did you enter the SNOW table name? Did you select it from the dropdown as well or did you enter it as a custom value?

enter image description here