You’re offline. This is a read only version of the page.
60
Hi
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 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.
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
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
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! 😉
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
Share
Report
All responses (
Answers (
