Combine CSV files in Sharepoint folder to create one CSV file

Like (0) Share

Report

Posted on 10 Aug 2023 20:50:41 by vr_2020

Hi,

I have 4 files with following naming convention in a Sharepoint folder, would want to combine/append these 4 files to one master file with name as 'abc_mmddyyyy_hhmmss.csv' with one Header row and then upload it back to same Sharepoint folder through Power Automate.

abc_mmddyyyy_hhmmss_South.csv

abc_mmddyyyy_hhmmss_Central.csv

abc_mmddyyyy_hhmmss_West.csv

abc_mmddyyyy_hhmmss_North.csv

Where mmddyyyy_hhmmss will be dynamic based on Daily runs

For example:

abc_08012023_111500_South.csv

abc_08012023_112000_Central.csv

abc_08012023_112500_West.csv

abc_08012023_113000_North.csv

abc_08022023_111500_South.csv

abc_08022023_112000_Central.csv

abc_08022023_112500_West.csv

abc_08022023_113000_North.csv

Any help is appreciated.

All responses (1)

Answers (0)

Pstork1 66,089 Most Valuable Professional on 10 Aug 2023 at 21:26:03

Like (0)

Report

Re: Combine CSV files in Sharepoint folder to create one CSV file

If they all have the same columns you should be able to read all four files in and then do a union() on 2 arrays each time to combine them.