Please help me how to combine csv files without premium connector

(0) Share

Report

Posted on 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

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report
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

Was this reply helpful? Yes No
minyoungchoe 112 on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @minyoungchoe ,

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

Best Regards,

Bof

Was this reply helpful? Yes No
minyoungchoe 112 on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @minyoungchoe ,

You just need to repeat the above steps.

Best Regards,

Bof

Was this reply helpful? Yes No