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.
If this fixes the issue, please mark as resolved to help others with find it.
Happy to help
Robu 1
6
Share
Report
All responses (
Answers (
