Append CSV automatically

[L0boon]

Dear all,

here my ideal flow through Power Automate:

1 - I receive csv.part1 file via email

2 - I receive csv.part2 file via email

3 - I deliver these to a Sharepoint folder

4 - I append/merge the csv.part1 and csv.part2

5 - I deliver the master csv file to another Sharepoint folder (later referenceable)

Now I get stucked at point 4; I a cannot find the right way to get the content of the csv files and append these while creating a master csv file.

Do you have suggestions about how to solve this stuck point? Do you have suggestions about how to improve this process?

Kind Regards,

Andrea

[lbendlin]

How big are these files?  Power Automate has a 100 MB "message size" limit.

[L0boon]

Dear Ibendlin, I am managing multiple csv files with a size less than 3 MB each. the master file would be less than 100 MB.

[lbendlin]

Here's a fun video for you

Working with Files and File Contents in Power Automate (encodian.com)

[L0boon]

Thanks for the video! however I am not able yet to define a solution from that.