Showing results for 
Search instead for 
Did you mean: 
New Member

Create a Simple Database

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. 

New Member

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?


@batman12 If you share your 2 scripts in this post, perhaps I can help troubleshoot.

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (2,709)