Unanswered

Copying from one excel to another

(0) Share

Report

Posted on by polywantacracke

Hi,

I'm new to power automate, and trying to create a simple flow which copies the content of one table to another, both in excel.

I want the Key value to be taken from the 1st table (that I'm copying from), but cannot seem to make this work. Is this possible?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

beerad on at

Like (0)

Report
Yes. It is possible. A couple of things I noticed that might be causing an issue:

It seems the "Create a Table" step is unnecessary as you already have the destination table correct?
If you are copying the final step should be "Add a Row" since the row wouldn't already exist to update correct?

Was this reply helpful? Yes No
polywantacracke 24 on at

Like (0)

Report

Hi Brad,

Thanks for your reply.
I added the "create table" step since I thought it was needed before the "list rows", which requires a table as an input. When I use the "Add rows" function, it simply adds blank rows, see below:

Thanks!

Was this reply helpful? Yes No
beerad on at

Like (0)

Report

Did you add what column information from the originating list goes in what columns for the destination list? Below is an example and this worked for me.

Was this reply helpful? Yes No
polywantacracke 24 on at

Like (0)

Report

Thanks again Brad. This is my problem - it does not offer me the rows from the first table. Any idea why?

Was this reply helpful? Yes No
beerad on at

Like (0)

Report

Is the originating table formatted as a table with column headers?

Was this reply helpful? Yes No
v-JessicaG-msft on at

Like (0)

Report

Hi @polywantacracke ,

Do you want to copy the contents of table1 in the same excel to table2?

You could format the two tables as a table with column headers, and use the created table as input in the "List Row". I have a test for your reference, you could refer to the screenshot below:

Best Regards,

Jessica Gu

Was this reply helpful? Yes No