How to Merge Excel Files Automatically with Power Automate & Office Scripts

[@DamoBird365]

I’ve got a favour to ask! If you enjoy this, please double check that you’ve liked the video and subscribed to the channel! Thats a small way you can help me carry on doing this ❤🙏🏾 really appreciate you! 🩷 Subscribe: kzbin.info ☕ BuyMeACoffee: buymeacoffee.com/DamoBird365 🔗 LinkedIn: linkedin.com/in/DamoBird365 🐦 X (Twitter): x.com/DamoBird365 📱 TikTok: tiktok.com/@DamoBird365 🙋‍♂ Feedback: forms.office.com/r/4EqE7VHVfH

[@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.

[@temidayolonge4566]

Well Done Damian.

[@DamoBird365]

@@temidayolonge4566 cheers 😍

[@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!

[@michelhegeraat5430]

Nice work Damien, it seems if you pass an array, it must all be text. Clearly office script and JSON aren't the best friends. Need to pass all data as a string, not JSON array. I had to do this trick to convert the string I pass, back into an array: let OrdersData: (string | number | boolean | null)[][] = JSON.parse(ordersDataJSON);

[@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?