Power Platform Community Forum Thread Details

Good afternoon, everyone well?

I have 200 excel files in csv and I need to put them all together, that is, create a flow, where the robot searches my file folder, copies the excel cells and pastes them into a new excel file (xlsx) and does this to all 200 files.

Can anyone help me?

Categories:

Building flows

Hi FB-25101909-0,

Thank you for choosing Microsoft Community.

You can use Power Automate to create a flow that will combine all your CSV files into a single Excel file. Here's a step-by-step guide to get you started:

Create a new flow: Open Power Automate and create a new flow.

Trigger: Use the "Recurrence" trigger to run the flow at a specific interval or use the "When a file is created or modified" trigger if you want the flow to run whenever a new file is added to the folder.

List files in folder: Use the "List files in folder" action to get all the CSV files in your folder.

Apply to each: Add an "Apply to each" action to loop through each file.

Get file content: Inside the loop, use the "Get file content" action to read the content of each CSV file.

Create table: Use the "Create table" action to convert the CSV content into a table.

Append to Excel: Use the "Append to Excel" action to add the table to your new Excel file.

This should give you a good starting point. If you need more detailed instructions, you can find them below.

How to Combine Multiple Excel Files with Power Automate

Process CSV files easily with Power Automate and Dataflows - YouTube

If this fixes the issue, please mark as resolved to help others with find it.

Happy to help

Robu 1