I have created a flow where I upload an excel file and it goes through a script. I combine these files every day. So how do I create this automated flow? I want to upload files to a certain folder where they will automatically get added to another excel sheet in SharePoint. How should I proceed with? I did the following and I'm lost after that. Each excel file contain around 5000 rows, but the columns are always the same with different data on different dates on row.
@batman12, Take a look at this sample --> Combine workbooks into a single workbook - Office Scripts | Microsoft Docs. If you follow this composition you will need to create two Office Scripts in Excel. The first will extract the values from the uploaded workbook. The second will write those values to your central workbook.
Thank you for your response. I think this copies the entire worksheet. What I wanted to do is copy data on one sheet. I did this through a power query, where we need to press the refresh button and it take some time. Was wondering if there's a way to put all data in one sheet. I did run what was on the link you mentioned. It didn't bring results but only the below screenshot.
Only the sheet name, no data in this.
Yeah, the sample describes copying all worksheets the data from their used ranges into an array that is passed from the script to the flow and then ingested into the new workbook. If your source workbook had 'blank sheets' the results will be blank. Also if there is some name mismatch in your code or in your flow dynamic values the resulting script will either error out or return blank. Can you debug your scripts with console.log() statements to see if the right content is being returned?
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us on June 28 for our monthly User Group leader call!
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!