Combine CSV files into multiple tabs in a single xlsx file

[Chirag101]

This flow reads multiple files from SharePoint and outputs after validation. In addition to the existing output, I want to combine all the CSV files(original data) that are input from SharePoint connector into a single xlsx file on multiple tabs. Ideally, the tab names will be the same as the file name, which I will add to the final email that's sent out. How can I achieve this?

I only need to combine the data from the first four SP input connectors. The data doesn't need to be transformed and can be attached as is.

Thanks

[Qiu]

@Chirag101 
Maybe you can try the "Blick Until Done" tool to output you date into one Single Excel File.