Hello all,
I am just starting with the topic RPA and Power Automate and I am still quite inexperienced. I have a problem. I am trying to automate a process for work. I have attached example photos.
Excel file 1 = Only the table with all the information
Excel file 2 = A prefabricated layout (table entry starts from A14).
I would like to insert every single column from Excel file 1 into Excel file 2. In reality, it will have much more data, so I would insert each column separately.
My problem is that I can't make it so that every single column is automatically read and it does it automatically until the table is completely read.
Thanks a lot ! 🙂
Hi @Melone
The example photos did not get attached to the post, So I couldn't get clarity on your requirement.
To know the last column with data, you can get it from the below action.
Hello,
enclosed is the sample photo.
I have tried it with the activity first Column. But it only manages to transfer the column that I have defined before. It does not read the other columns automatically. I think I started my flow completely wrong.
Before I started automating. I thought it would be easy because it was logical. Now I doubt my abilities 😄
- Open Excel File 1. Lets call this as ExcelInstanceFile1
- Find the last row using "Get first free column/row from Excel worksheet". Lets call this variable as LastRow
- Copy cells from Excel worksheet from A1 to LastRow - 1 of A column
Then in Excel File 2 with ExcelInstanceFile2
- Paste cells to Excel worksheet into C14
Do the same for other columns.
If you want to do it a bit more dynamic then in File1 Search for the text "Name" to get the Name column (using Find and replace cells in Excel worksheet)