Please help me how to combine csv files without premium connector

Like (0) Share

Report

Posted on 9 Nov 2023 17:56:17 by minyoungchoe

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

All responses (5)

Answers (1)

v-bofeng-msft on 15 Nov 2023 at 01:37:30

Like (0)

Report

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 112 on 14 Nov 2023 at 14:07:13

Like (0)

Report

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 on 13 Nov 2023 at 01:05:49

Like (0)

Report

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 112 on 10 Nov 2023 at 14:08:09

Like (0)

Report

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 on 10 Nov 2023 at 02:19:11

Like (0)

Report
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

2\My flow

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

3\Result

Best Regards,

Bof