Combine CSV files into one

(0) Share

Report

Posted on by Sajarac

3,295

Hi there,

Is this possible? I have a couple of CSV files and I would like to combine all of them into a single CSV file. All of them have the same structure, columns, headers etc they are previously formatted as tables.

I can do it using the command line for a specific folder like this:

copy *.csv newfile.csv

But I would like to have the files in my one drive folder the manually trigger the flow.

Thanks in advance for any advice.

Regards,

Categories:

General topics

All responses (3)

Answers (0)

Sort by

manuelstgomes 6,643 on at

Like
a
(1)

Report
Copy link

Link copied!

HI

Yeah, it's possible, but not as easy as with a command, unfortunately :(.

I've built a template that parses CSV files. You can use it to fetch the information and then create a new file by appending the data from all the runs of that template. You can find it:

https://manueltgomes.com/microsoft/powerautomate/how-to-parse-csv-file/

Does it make sense? If you need more help, please let me know, and we'll try to figure this out.

Cheers

Manuel

-------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up.
Sajarac 3,295 on at

Like
a
(0)

Report
Copy link

Link copied!

Wow, @manuelstgomes , I saw the flow. and you are absolutely right! Is not easy.
Huge flow. I thought it was simple like my command line. I did it but then I have to manually remove the headers for the second, third, fourth file etc. then I have do manually remove a "?" character placed at the end of the file.

Thanks again for sharing your flow. Not easy for a beginner but I will give a try.
manuelstgomes 6,643 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @sajarac

Indeed, but I would suggest you try it anyway as a "black box". Call the Flow with the parameters and get a JSON on the other side. Then you can do a simple "Apply To Each" and get the values and save them to your file.

I published today a new template and new instructions. It's more complex, but don't worry too much.

https://manueltgomes.com/microsoft/powerautomate/parse-a-csv-new-template/

I'm sure you can do it! :). Please let me know if you have questions and we'll figure this out!

Cheers
Manuel

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.