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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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

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

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @minyoungchoe ,

You just need to repeat the above steps.

Best Regards,

Bof

Was this reply helpful? Yes No