Unable to add data of rows from another table

[Anonymous]

I was wanting to make a flow where it gets Excel file properties and then gets the tables and rows from those Excel files and stacks all of the rows into an Excel file created from a Copy File action earlier. (Basically creating a merged file of rows from multiple Excel files). Is this possible or am I on the right track to accomplish this? Here are screenshots of my flow:

 

Let me know if there are any questions about the flow as well. Getting an error only on the final Add a row into a table action that says: 

[Agnius]

Well, it seems like you are passing an incorrect table name there. Are you sure you are using the correct variable there? What value does it store? Can you show the raw inputs of the failed action?

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution.
If you like my response, please give it a Thumbs Up.

If you are interested in Power Automate, you might want to follow me on LinkedIn at https://www.linkedin.com/in/agnius-bartninkas/

[Anonymous]

I'm not sure if this would be the correct variable, the variable in the select an output from previous steps is the value information from 'List rows present in a table 2', and the table variable is the table name from the 'get tables 2' action.

These are the raw inputs for the failed action here: 

Also here is what the inputs looked like: 

[Anonymous]

UPDATE: I have gotten the flow to run, but now it is inputting the rows really far down at row 51: 

[Agnius · Accepted solution]

That is either because it also inserted some empty rows, or because your table already had empty rows. You need to delete any empty rows from the table manually and then run your flow.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution.
If you like my response, please give it a Thumbs Up.

If you are interested in Power Automate, you might want to follow me on LinkedIn at https://www.linkedin.com/in/agnius-bartninkas/

[Anonymous]

Thank you so much! This worked 🙂