My flow is kicking back and error that says it can't find the table called for.
Though, clearly, the flow created the table, using the script that is in the workbook, as shown below.
What am I missing?
My flow is kicking back and error that says it can't find the table called for.
Though, clearly, the flow created the table, using the script that is in the workbook, as shown below.
What am I missing?
Thank you for the suggestion.
If I may, how is this any different than calling for the specific table in a 'Compose' action (as I am doing) and using that output in the 'List rows present in a table' action?
Hi @Phineas
Pls check the below sample flow for dynamically get the table name & fetching records from the it.
Before "List rows present in a table", add "Get tables" action to get all the tables of the excel file:
Now, add filter array action to filter the table array based on its name. Here, I have hard coded the table name "Table2", but you can pass the variable as per your need:
Finally, set the table name from the output body of filter array action in "List rows present in a table":
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
Thanks
So, where is my corrective action?
Do I update my Compose to 'Continuous_Table'?
It's not really using the Name of the table as it appears. It is using the guid of the table.
Manually select an Excel file and table. Then in the ... Settings of the "List Rows Present in a Table" select the Peek Code.
You can see what the action is using for values.
Location = source:
Document Library = drive:
File = file:
Table = table:
Michael E. Gernaey
566
Super User 2025 Season 1
David_MA
516
Super User 2025 Season 1
stampcoin
492