web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - Building Flows Combine CSV files in S...

Power Automate - Building Flows

Unanswered

Combine CSV files in Sharepoint folder to create one CSV file

Like (0) Share

Report

Report

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

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.

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Pstork1 68,271 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.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 666 Super User 2025 Season 2

#2

Tomac 382 Moderator

#3

developerAJ 254

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans