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

  Рет қаралды 2,788

DamoBird365

DamoBird365

Күн бұрын

Пікірлер: 17
@DamoBird365
@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
@Krieg33333 2 ай бұрын
Thanks Damo for this, looking forward to more office script videos!
@DamoBird365
@DamoBird365 2 ай бұрын
Let me know what you are thinking of, would love to build something meaningful.
@temidayolonge4566
@temidayolonge4566 2 ай бұрын
Well Done Damian.
@DamoBird365
@DamoBird365 2 ай бұрын
@@temidayolonge4566 cheers 😍
@duds_sn
@duds_sn 2 ай бұрын
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
@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
@McIlravyInc 2 ай бұрын
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
@DamoBird365 2 ай бұрын
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
@McIlravyInc 2 ай бұрын
@@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
@DamoBird365 2 ай бұрын
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
@McIlravyInc 2 ай бұрын
@@DamoBird365 always! Inspiration at the least. And the comments are generally gold too!
@Tiago22049316
@Tiago22049316 2 ай бұрын
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
@DamoBird365 2 ай бұрын
Thank you Tiago 😍
@rustymorning431
@rustymorning431 2 ай бұрын
My only problem is that it does not work on the excel app.
@DamoBird365
@DamoBird365 2 ай бұрын
What doesn’t work? Can you tell me more? Do you get an error? Is this a product limitation you’re referring to?
Create Excel File in SharePoint via Power Automate Cloud Flow
19:17
How to automate Excel with reusable Office Scripts | Excel Off The Grid
13:54
Чистка воды совком от денег
00:32
FD Vasya
Рет қаралды 6 МЛН
小丑教训坏蛋 #小丑 #天使 #shorts
00:49
好人小丑
Рет қаралды 33 МЛН
How to treat Acne💉
00:31
ISSEI / いっせい
Рет қаралды 16 МЛН
Use This Trick to Automate Any Excel Task (Better Than Macros)
10:53
Kenji Explains
Рет қаралды 104 М.
How to Move Data Automatically Between Excel Files
11:37
Kenji Explains
Рет қаралды 222 М.
Extract Power BI data & measures with Power Automate
17:15
Access Analytic
Рет қаралды 8 М.
Using Excel Scripts with Power Automate to convert CSV
18:07
Shane Young
Рет қаралды 2,7 М.
Introducing the "VitaWear SmartBand,"😳 a next-gen wearable gadget🎉
0:26
Shreya fun shorts
Рет қаралды 2,5 МЛН
WOW 😱 How to Make AirPods from Regular Headphones
0:47
ALABAYCHIC
Рет қаралды 18 МЛН