Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 1FXq5RYTa47K3X6zQCo6Ht
Power Automate - Building Flows
Unanswered

Combine CSV files in Sharepoint folder to create one CSV file

Like (0) ShareShare
ReportReport
Posted on 10 Aug 2023 20:50:41 by 2

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.

 

  • Pstork1 Profile Picture
    66,342 Most Valuable Professional on 10 Aug 2023 at 21:26:03
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Building Flows

#1
David_MA Profile Picture

David_MA 212 Super User 2025 Season 1

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 208 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 182

Overall leaderboard
Loading started