Answered

How do you add a row into a table in Power Automate when there more than one Tabs

(0) Share

Report

Posted on by Dschroeder-ATN

I've got a flow that is creating a new worksheet on an existing Excel file on OneDrive, then I'm inserting a table into that new worksheet. When I try to insert data into that new table, I'm getting that the table is not found "No table was found with the name 'ServerList'." I've tried using the 'hard coded' name from the "Create Table" step, I've also tried passing in the name (table name) or title (table title) from the Create Table step.

I'm guessing it can't find it because the second tab is not the active sheet.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Sort by

rzaneti 4,476 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Dschroeder-ATN ,

Excel connector can access tables from non active worksheets. Are you creating the file and the table inside your flow? If yes, could you please share an image of your current flow design in edit mode? (make sure to remove any sensitive content before sharing)

Was this reply helpful? Yes No
Dschroeder-ATN 11 on at

Like (0)

Report
Copy link

Link copied!

Thanks for looking at this. Here's the way I left it this morning after I just used the table name as the Custom Value. I checked the last failed run when I passed in the variable of the Table Name from the Create Table step. The variable passes the correct ID.
The table does get created in the proper step.

Was this reply helpful? Yes No
Verified answer

rzaneti 4,476 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Dschroeder-ATN ,

Thank you for sharing the image! Apparently you are using different files in the 2 actions ('Create table' and 'Add rows into a table').

You are creating the table in a file which name is a concatenation of 'ContractorDire...' and 'ContractorList':

While you are adding a new record in a table located in a file called 'ContractorList' only:

When testing it, I recommend you use the 'name' property from the 'Create table' as input to the 'Add row into a table' instead of manually type 'ServerList'.

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.
http://digitalmill.net/

Was this reply helpful? Yes No