Populate Excel Template using Power Automate and Office Script

During this video, we will learn, how we can Populate Excel Template using Power Automate and Office Script. Most of the time, we have a requirement where we need to populate our data in our Excel Template and generate a new Excel file which is sent in Email. During this video, we will use one Excel Template and create one Office Script which dynamically populate the values in Excel spreadsheet using Power Automate Flow. Microsoft Power Automate flow provide an action to Run Excel Script. We can pass parameter from Power Automate to Excel Online Office Script and populate the values! Stay tuned for full video!
Key takeaways!
1. Excel Template Populate using Power Automate
2. Populate Excel Template using Power Automate
3. Office Script + Excel Template + Power Automate
4. Run Office Script from Power Automate
5. Populate Excel Template Dynamically using Office Scripts and Power Automate
Chapters:
00:00 Start
00:11 Excel Template to Populate Data using Power Automate
01:42 Upload Excel Template
02:00 Create Office Script to Excel
02:39 Excel Script
03:30 Create Script using Record Action
05:53 Set Value of Excel Cell using Office Script
06:50 Set Value for Mergers Cells using Excel Script
07:42 Define Parameters to Excel Script
08:00 Define Input Variables in Excel Script
09:00 Set Variable inside SetValue
10:14 Save Script
10:44 Clean Template Values
11:30 Create Power Automate Flow
12:46 Create File
14:56 Run Excel Script using Power Automate
15:09 Set Values
16:00 Send Attachment in Email
17:23 Test Flow
18:00 Flow Run
18:45 Subscribe!!
Dhruvin's Social Media:
Follow my other channel for short content: ‪@DigitalDhruvin‬
Follow me on Instagram:
/ powerplatformguy
Looking for Consultancy? Connect Here!
powerplatformtrainings.com/co...
Follow me on all social Media Handles:
linktr.ee/dhruvin.shah
#PowerAutomate #OfficeScript #PowerPlatform #SharePoint #PowerAddicts #ExcelScript #ExcelTemplate #DigitalDhruvin #DhruvinShah

[@waqarmehdi4394]

This channel is a gold mine for power platform developers. Love your videos. The contents that you provide is no where to be found on KZbin. Thanks Dhruvin for the amazing content.

[@gatafish]

Dhruvin, you are the only person that I could find that could offer a viable solution and demonstrate it perfectly. THANK YOU!!!

[@arulvivek1975]

Excellent, Thanks bro.

[@thiagomagero2012]

Thanks. You just made me come out of despair on a delivery. I needed to produce hundreds of sheets with information from a huge excel. I thought it would take 3 days to make. With your teaching I only needed 3 hours. And it's done! Thank you very much! Ps: The calm and direct way you conduct the session helps a lot. Congratulations.

[@daniellepadgett293]

Thank-you, Thank-you, Thank-you! I have been trying to figure this out for so long. Great step by step demo for someone who doesn't know how to write scripts and only has a basic understanding of Power Automate!

[@KristineKolodziejski]

Awesome session Dhruvin! On a separate note, I love your new recording setup!

[@iamdhruvinshah]

Thanks a lot!!

[@ViswanathVRao]

Excellent & simple. It worked for me. Thank you bro. God bless.

[@sudarsana1234]

It's very good solutions for a supervisor while doing one on one discussion and documentation. This is really a problem solving solution for me.👍

[@paulcroke3544]

Thanks Dhruvin, this was an excellent video.

[@laurentmenard4679]

Thank you. Very good tutorial, very clear 😀👏

[@alzaimoor79]

Thanks, very useful, can we insert picture from attachment?

[@mangeshmalvankar5957]

Thanks Dhruvin for the session! It's amazing

[@iamdhruvinshah]

Thanks!! Glad it is useful

[@elephant_3341]

Thank you this was super helpful for the project I'm working on

[@tomr9969]

Very helpful! I am putting this into production today. ⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐

[@mauriciorenderos3302]

Thanks a lot sir!! Excellet job teaching to all of us!!!

[@ankurtopiwala8701]

Awesome session, thank you Dhruvin 👏🏻

[@iamdhruvinshah]

Thanks

[@junmelendez7651]

Thank you. Awesome job Dhruvin ⭐⭐⭐⭐⭐

[@iamdhruvinshah]

Thanks for watching

[@tasungota]

Perfect, thank you

[@raduna8853]

Thank you very much! :O really great way how to automate lots of processes.

[@iamdhruvinshah]

Glad it was helpful!

[@floret1220]

Thank u so much !!

[@jaybuddhadev3543]

helpful, thanks

[@orbak01]

Hi Dhruvin. Thanks to take the time for explianing this. It was very helpful for me. I was also trying to convert the XLSX file to PDF but and then email it but it is not working for me. Is this possible?

[@latoyakilgour]

Hi Dhruvin how are you! I am new to power automate and have been loving your youtube tutorials. I have been able to successfully implement your 'Populate Excel Template using Power Automate and Office Script' except for one very strange thing. When I set my trigger and add a condition to only trigger automation when I column value changes to paid, it triggers the automation but always selects the row from the list that was last changed before the row I just changed. It is consistent every time. Even if I wait an hour and change the column of a different row again it always selects the information from the previous change. Any ideas why this would be happening? Why is it not selecting the row with the latest change?

[@srikandanarthanari5667]

Fantastic

[@lalatendutripathy]

Classic Example!!

[@MrAusiraj]

Hi Dhruvin, Thank you so much for thid video. can you create a vedio how to read data from excel and create a reprot for each user and send an email to each user

[@user-sl1mc6yh4e]

Hi I have a table whose entries are dynamic how can I populate data for that and also at the end of a table I need perform sum of one column values how can I achieve it

[@wcstroud]

So i seem to be getting an inconsistent run. I'm trying to do something similar by selecting rows in a spreadsheet table to use. When i do them 1 or 2 rows at a time it works, but if when doing larger groups (4+) it seems to skip running the script for some files. it creates the file from the template, but then doesn't populate it. However, its inconsistent - skipping row 2 sometimes and row 4 others. Any ideas?

[@dheaindah4855]

Thank you for your video, can we add picture to the script Dhruvin? can you make the tutorial video ?

[@muhammadghiffari9786]

thanks for great videos, i would to ask why there is error like this "We were unable to run the script. Please try again. The script couldn't create a connection with Excel. Please try again." thanks

[@audemasse3825]

Hi sir, first of all thank you for this video. I followed you step by step and everything seems to work but I have a problem. Even if the excel is populate, I can't opened it andI have this error: "Cannot open this workbook because the file format may not match the file extension." I do name my document with .xlsx I try by naming it .xls and it seems to work with this weird format, but I looked in every forum and video and can't found how to solve this error. Can you help me please. Thanks again !

[@user-vu2dj5uz8w]

👍

[@reevesjoe1]

Hi Dhruvin. Excellent video. Is there a way to take the file and attach it to the item in the list as an attachment instead of sending it as an email?

[@iamdhruvinshah]

Yes, you can

[@emmanuelwatson93]

How do i do this @@iamdhruvinshah

[@sarathbabu2616]

Great video sir .can we help with these question sir. 1.if max storage of a site in share point is 26.5 TB means whats is the size of sub site in share point online? and how many sub sites can we create in share point online?

[@iamdhruvinshah]

Thanks! I don't know the answer!! So sorry

[@nuhmanti9477]

I don't find 'automate' in my Excel online, please help me

[@zaldyconde4248]

Thank you Dhruvin, This is awesome now we can popoluate both now in word and excel. When I tried to run i have this error We were unable to run the script. Please try again. Workbook not found. Where did I go wrong.

[@iamdhruvinshah]

Try to run the script manually in excel first You can find errors easily

[@iamdhruvinshah]

My assumption is you did not get your sheet context

[@zaldyconde4248]

@@iamdhruvinshah no errors when I press run

[@mohanbaburamasamy]

I'm facing unexpected error while saving the records kindly help me thanks

[@DonaldRamogodi]

Very useful video, thank you🤩😘💯

[@nilesh2874]

It is really wonderful solution provided by you to generate the excel report. While running this solution in power automate, I am facing following issue in "Run Script" step We were unable to run the script. Please try again. The script couldn't create a connection with Excel. Please try again. clientRequestId: 73e35894-287d-4d73-9e12-c5cb40c4136c I also tried adding checkout/checkin step before and after "Run Script" step but no luck Please help. Thank you once again for useful video