Add an Initialize variable action before the flow (of Type 'Integer') and an Increment variable action between the two Run script actions. This will avoid identical shortened names being passed to the script. First, you must create a variable in the flow to track the workbook count. Workbook.getWorksheets().forEach((sheet) => `) Īdditionally, if the workbook names are longer than 30 characters, you'll need to shorten them in the flow. Get the data from every worksheet, one at a time. Let worksheetInformation: WorksheetData = Create an object to return the data from each worksheet. * This script returns the values from the used ranges on each worksheet.įunction main(workbook: ExcelScript.Workbook): WorksheetData Use the Add worksheets script to create a new worksheet in the 'Combination.xlsx' workbook for every worksheet in all the other files.Use the Return worksheet data script to get the data from every worksheet in each of the workbooks.List all the files the 'output' folder.

Build a flow (as described in the Power Automate flow section of this article) to perform these steps:.The folder name 'output' is used in this sample. Create a folder in your OneDrive and add one or more workbooks with data to it.Create and save the two scripts from this sample.The file name 'Combination.xlsx' is used in this sample. Create a new Excel file in your OneDrive.It does not preserve formatting, charts, tables, or other objects. This sample only copies the values from the other workbooks.

Combine excel files