When applying List rows present in a table, the table cannot be found

(0) Share

Report

Posted on by Cold_ZHu

应用表中存在的列表行时，找不到该表

Power BI.png

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Cold_ZHu

Have you created excel just before started to use this action? if yes , then close the flow after saving it and open it again, table name will appear 🙂

Was this reply helpful? Yes No
Cold_ZHu 23 on at

Like (0)

Report
Copy link

Link copied!

The previous process was tested before adding the "List rows present in a table" step,
And Excel is saved in the sharepoint path, and then add the step "List rows present in a table"
So Excel exists in sharepoin

Was this reply helpful? Yes No
Cold_ZHu 23 on at

Like (0)

Report
Copy link

Link copied!

The previous process was tested before adding the "List rows present in a table" step, And Excel is saved in the sharepoint path, and then add the step "List rows present in a table" So Excel exists in sharepoin And then there is an error message： Could not retrieve values. Error code: '404', Message: 'The resource could not be found. clientRequestId: 4DD77737-8726-4648-91F6-4FDF8AA5ACEE serviceRequestId: f67c5445-1adb-4adb-bf2f-4d0854f128a2'. More diagnostic information: x-ms-client-request-id is '4DD77737-8726-4648-91F6-4FDF8AA5ACEE'. Copy Error

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Cold_ZHu

Have you tried opening the excel?

Also if you know the table name , then place it as hardcoded value something like below

just click on enter custom value and then enter the Table name in the input field

Hope it helps 🙂

Was this reply helpful? Yes No
Cold_ZHu 23 on at

Like (0)

Report
Copy link

Link copied!

Excel can be opened normally, and I have tried to manually create Excel, but it is still the same cannot find "table" Customize the input value, and the rows in the table cannot be obtained I really don't understand what's going on ，why is this

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @Cold_ZHu

do one thing, delete the list rows in table action, then save flow and close it. Open excel and verify whether it has table in it. Then open flow again and and you can see table name there

Or another way would be using Get tables in excel action to list out all tables in excel file and then pass the table id to the table name of list rows action, refer the below flow

the highlighted ones are the output from Get tables action. Don't worry around the loop created for this as Get Tables returns array of table details from excel file even it is having one table.

Hope it helps !

Was this reply helpful? Yes No