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
@Chirag101
Maybe you can try the "Blick Until Done" tool to output you date into one Single Excel File.