Answered

Copying rows from newly created Excel File to Master File

Like (0) Share

Report

Posted on 19 Mar 2021 14:47:21 by Bigshow

Im trying to find a way to take the rows created in a new excel file and copy them across to a master excel file. Files can be stored in Sharepoint or one drive.

If i name the source file the this works. But the source files will have dynamic name and obviously dont exist yet, so i cant add the column names to the flow.

Any ideas how to achieve this?

Phil

I have the same question (0)

All responses (15)

Answers (2)

tomier1991 4 on 24 Jul 2023 at 03:37:25

Like (0)

Report

Re: Copying rows from newly created Excel File to Master File

I now tried to remove the reg expressions for the individual columns - now I get an error with the array function which I am unable to resolve.

save_error_power_...

Was this reply helpful? Yes No
tomier1991 4 on 24 Jul 2023 at 03:21:10

Like (0)

Report

Re: Copying rows from newly created Excel File to Master File

Hi guys,

I am trying to rebuild your flow but I am keep getting a error at the last step:

"Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The repetition action(s) 'Apply_to_each' referenced by 'inputs' in action 'Add_a_row_into_a_table_2' are not defined in the template.'.'."

See attached the screen - does somebody have any idea what I did wrong?

Best
Tomier

save_error_power_...

Was this reply helpful? Yes No
chrissahagun 197 on 20 Mar 2021 at 17:06:17

Like (1)

Report

Re: Copying rows from newly created Excel File to Master File

Nice. Didn’t know we could do that. Now I do. Thanks!

Was this reply helpful? Yes No
Bigshow 60 on 20 Mar 2021 at 16:46:50

Like (0)

Report

Re: Copying rows from newly created Excel File to Master File

Rather than a delay step I changed the settings of the copy step. I put in a retry count of 5 with a 5 minute interval. This seems to work ok

Was this reply helpful? Yes No
chrissahagun 197 on 20 Mar 2021 at 15:28:00

Like (0)

Report

Re: Copying rows from newly created Excel File to Master File

There’s a Delay step... you can have the flow wait for a few seconds before proceeding to the next step

Was this reply helpful? Yes No
Bigshow 60 on 20 Mar 2021 at 13:54:30

Like (0)

Report

Re: Copying rows from newly created Excel File to Master File

I have this working using your “staging file” idea. One thing I had to do is point the “listing rows” step to the staging file, then this would allow me to add the columns in the “add row” step. Once that’s done I went back to the list rows step and replaced the file name with the “file locator” dynamic

This works fine now, apart from if flow is run again to quickly, it errors out with a file lock

Was this reply helpful? Yes No
chrissahagun 197 on 19 Mar 2021 at 17:15:05

Like (0)

Report

Re: Copying rows from newly created Excel File to Master File

i havent tried renaming files yet. But if that error is on the step itself on the flow IDE, maybe be sure to choose “enter custom value” first? Or if it errors on runtime, maybe the file path format is incorrect. Check the run logs for the input and output values. Also it might be better to COPY over the staging file, not rename. This is so that you can still preserve your source file.

Was this reply helpful? Yes No
Bigshow 60 on 19 Mar 2021 at 16:54:53

Like (0)

Report

Re: Copying rows from newly created Excel File to Master File

Just a quick question. How do i rename the file? in the desitnation file path i put the dynamic filepath/stagingfile.xlsx but it errors out with the path\orginalfile.xlsx/stagingfile.xlsx

Was this reply helpful? Yes No
chrissahagun 197 on 19 Mar 2021 at 16:36:34

Like (0)

Report

Re: Copying rows from newly created Excel File to Master File

Am glad you're happy! I'd be too if you mark my response! 😉

As for your trigger question, yes i think it's pretty much straightforward. but if you are doing the "staging file" alternative, you should add a condition right after the trigger. so that if the detected "file created" is just the overwritten "staging file", the flow must Terminate (this is a step) - to avoid infinite loops due to this flow triggered by a file create, but it also creates a file. 😄

P.S. I too am still learning Flow. I was just told that one way of learning would be participating in communities like this and trying to solve other people's problems. That way, I get exposed to real scenarios. Maybe this works for you too! 😉

Was this reply helpful? Yes No
Bigshow 60 on 19 Mar 2021 at 16:30:47

Like (0)

Report

Re: Copying rows from newly created Excel File to Master File

Brillant! Thank you!

Was this reply helpful? Yes No

Community site session details

Copying rows from newly created Excel File to Master File

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Telen Wang – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Copying rows from newly created Excel File to Master File

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Telen Wang – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates