MERGE Excel Files Like a PRO with Power Automate Cloud Flows!

In this video, I’ll walk you through how to use a powerful Office Script to append or overwrite data in an existing Excel workbook. This Office Script comes with a range of dynamic parameters that let you set the sheet name, table name, table formatting, and choose whether to clear or append data-all based on your needs.
I'll show you how to trigger this script from a basic cloud flow in Power Automate. Then, I’ll take it a step further by demonstrating how to trigger the flow when an email arrives with an Excel attachment, automatically appending that data to a master workbook. Lastly, I’ll modify the flow to trigger when a file is uploaded to SharePoint, and append that data as well.
By the end of this video, you'll have a clear understanding of how to use Office Scripts to streamline your Excel workflows in Power Automate.
Bulk load data to Excel Office Scripts or Graph API kzbin.info/www/bejne/naXPnJ-wnpuAesk
Variables in Power Automate and Power Apps: kzbin.info/www/bejne/lYrMfHaNocSenJI
17+ Office Script Demo Videos kzbin.info/aero/PLzq6d1ITy6c2_qM_ocYDtEaENrqi92YmM
Here’s what we’ll cover:
00:00 Intro
00:18 What is an Office Script
02:26 Trigger an Office Script from Power Automate
08:17 Append Excel data from Email Attachment
16:01 Append Excel data from File Upload in SharePoint
19:07 Want a custom Office Script?
Want to download the script damobird365.gumroad.com/l/BulkLoadDataExcelOfficeScript
Check out the links in the description for more details on Office Scripts and Power Automate. If you find this video helpful, don’t forget to like and subscribe!
Got a video request? Let me know here: forms.office.com/r/4EqE7VHVfH
If you’d like to support me, you can buy me a coffee: www.buymeacoffee.com/DamoBird365 ☕

[@Krieg33333]

Thanks Damo for this, looking forward to more office script videos!

[@DamoBird365]

Let me know what you are thinking of, would love to build something meaningful.

[@duds_sn]

I've built something similar, to get data treated in a PBI Semantic Model and insert into an Excel file to use as a "View" for some internal customer. Great work!

[@temidayolonge4566]

Well Done Damian.

[@DamoBird365]

@@temidayolonge4566 cheers 😍

[@McIlravyInc]

Do you need the get file content action? Isn't the info in the trigger? (Going from memory so I can be way off!)

[@DamoBird365]

I agree that you can get the content from the trigger but there are limitations in the docs which can cause the files to be incomplete and appear corrupt. An interesting topic. Here’s the piece: Setting Include Attachments to Yes causes the connector to wait for all attachments to be downloaded. When many emails with attachments arrive around the same time, the connector can timeout while downloading these attachments. learn.microsoft.com/en-us/connectors/office365/#common-errors

[@McIlravyInc]

@@DamoBird365 good to know! I recall reading something about using first() to remove the apply to each loop. My email based flows are triggered on customized emails from the source system that will only have one attachment. Perhaps in this scenario I'm okay to use fewer actions? (Trying to use Roche's maxim in my automations in that I control/reduce variability at the source as much as possible in my situation.)

[@DamoBird365]

I love it. I am definitely all for simplifying. I have a video demo'ing apply to each and using first. kzbin.info/www/bejne/mmqcg6Vrmc-Wg6c It's just sometimes hard to pack all of the details into a single video but hopefully you still found something useful in this.

[@McIlravyInc]

@@DamoBird365 always! Inspiration at the least. And the comments are generally gold too!

[@Tiago22049316]

Thanks for sharing your ideas, Damien! I love your videos, and I always try to apply the knowledge in my daily life I hope you keep making videos; they are very inspiring.

[@DamoBird365]

Thank you Tiago 😍

[@rustymorning431]

My only problem is that it does not work on the excel app.

[@DamoBird365]

What doesn’t work? Can you tell me more? Do you get an error? Is this a product limitation you’re referring to?