Skip to main content

Notifications

Community site session details

Community site session details

Session Id : Q0ZyrOKGvGGL1L1QYRpW5S
Power Automate - Building Flows
Answered

Please help me how to combine csv files without premium connector

Like (0) ShareShare
ReportReport
Posted on 9 Nov 2023 17:56:17 by 112

Since I am not familiar with Power automate, I need the concept or idea!!

 

The monthly snapshots will taken automatically by Power automate flow that I create last week.


Once it's done, the csv file will be saved to SharePoint folder.

 

And now I want to create the appending(merge or combine) flow.
This flow will append the separate snapshots into a separate single file which will be automatically appended very month.

How should I handle this?


@grantjenkins @Matthy79 

 

minyoungchoe_0-1699389795532.png

 

 

  • v-bofeng-msft Profile Picture
    on 15 Nov 2023 at 01:37:30
    Re: Please help me how to combine csv files without premium connector

     Hi @minyoungchoe ,

     

    You just need to repeat the above steps.

     

    Best Regards,

    Bof

  • minyoungchoe Profile Picture
    112 on 14 Nov 2023 at 14:07:13
    Re: Please help me how to combine csv files without premium connector

    There are more than two csv files How can I handle multiple files using "Get file content"?

  • v-bofeng-msft Profile Picture
    on 13 Nov 2023 at 01:05:49
    Re: Please help me how to combine csv files without premium connector

    Hi @minyoungchoe ,

     

    Just use 'Get file content(SharePoint)' instead.

     

    Best Regards,

    Bof

  • minyoungchoe Profile Picture
    112 on 10 Nov 2023 at 14:08:09
    Re: Please help me how to combine csv files without premium connector

    Thanks for reply but my csv files are in share point folder

  • Verified answer
    v-bofeng-msft Profile Picture
    on 10 Nov 2023 at 02:19:11
    Re: Please help me how to combine csv files without premium connector

    Hi @minyoungchoe ,

     

    I've made a test for your reference:

    1\My CSV files

    vbofengmsft_0-1699582318153.png

    2\My flow

    vbofengmsft_2-1699582728318.png

    concat(outputs('Get_file_content_2')?['body'],decodeUriComponent('%0A'),join(skip(split(outputs('Get_file_content')?['body'],decodeUriComponent('%0A')),1),decodeUriComponent('%0A')))

    3\Result

    vbofengmsft_1-1699582697410.png

     

    Best Regards,

    Bof

     

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 292 Super User 2025 Season 1

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 263 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 218

Overall leaderboard
Loading started