Copying a specific row of an excel file into a larger spreadsheet

[aa26]

My flow is running into an issue when I am trying to copy one row from an excel spreadsheet into a master spreadsheet. I tried using "Get Row", but when I then tried to use "Add a new row", I could not use the data from "Get Row" as a dynamic value to fill all of the columns. Instead, power automate shows all ~100 rows and wants them to be manually populated. I know that "Get Row" is working because when I run the flow, I can see that the output is the row that I want. How can I use this value to auto-populate a new row in a different file?

Thanks

[Sundeep_Malik]

Hey @aa26 

I would suggest you to use action 

List rows present in a table,

If possible.

If not try using the below expression in add a new row action.

outputs('Get_a_row_2')?['body/ColumnName']

Or

outputs('Get_a_row')?['body/ColumnName']

If nothing works, can you put screenshot of the flow because I am not able to find any add a new row action. I hope you have not used any other connector there. 

Better try using action

add a row in a table.

  

[aa26]

Thank you @Sundeep_Malik,

The suggestions for Get_a_row worked well, but now I am trying to use "List rows present in a table" to do the same thing with several rows. The output of "List rows present in a table" is a list of values, and I am trying to use "Apply to each" to take the specific value in the first table into a new table. The overall structure looks like this:

My problem is how to access just the unique Column in each row to populate the new table. I tried outputs('List_rows_present_in_a_table')?['value/ColumnName'], but I think that this doesn't work because I'm not specifying which item in the list of values to retrieve ColumnName from. Is there a way to access a specific item in the list of values and draw out a column from that value?

Thanks

[aa26]

I guess the better way to phrase the question would be this:

How do I index the list of values in my output function? I would imagine if I wanted to access Column1 in the third value in the list, I would use outputs('List_rows_present_in_a_table')?['body/value(3)/Column1'] , but this is not working for me.