I did not realise how macros could be integrated with power animate. I’ve been “stuck” in my personal exploration of power animate and watching you set up the script really helped a few things click. This knowledge makes me hopeful. Thank you!
Wow! I've been out of the Excel/Office loop for a couple of years and what a great surprise - a lot of really neat features have been added! Thanks for a wonderful tutorial!
For me ... a lot to unpack here. But a flawless delivery (once again) ... and Leila's encouragement makes me curious. But I still have a long road to travel before I get "there". As always ... thank you ... thank you ... thank you.
This is the power automate flow I have been looking for! Thank you Leila! If anyone is like me and not a guru on these things, I just want to explain how I overcome an issue with this flow as it didn’t work for me initially when I was testing it. This flow only sends 20 files/emails at a time (I haven’t figured out how to disable the limit) and therefore if you have more than 20 files, and your flow fails, you maybe wondering why. I was testing it with a couple of lines from my spreadsheet (which had 100s of lines and therefore 100s of files in the folder). The two lines I was testing were not in the first 20 files that the flow was searching and that’s why my flow was failing. I removed all of the files and left the two files that I was testing and the flow worked! Just be aware of this as I was going mental 😅 trying to figure it out!! Hope this is helpful!
Hmmm, nice video as usual, but need to spend some more time in understanding Office Script and Power Automate before applying them practically. Thanks Leila! 👍
Takeaways: Record Actions: allows to write code based on actions that were done inside a sheet, and collections would be a group a sheets that would be modified (there are basic scripts in the MS documentation to make the code). Flow: are actions that could be scheduled or triggered. Example would be to execute a script to format different excel files that are inside a folder or send personalized emails to each person (based on records in an excel file).
I'm going to apply this to my daily/weekly/monthly work routine. Hope this will simplify my work which currently I think taking too much of my precious time.
Very interesting. I don't often use Excel online however these are certainly some time saving methods that I can incorporate into my work flows. Thanks Leila.
Hi Leila. I have a report that I build every Monday that starts with data in a CSV file. I import and transform the data using Power Query and then build a pivot table and another table with summary data. I do all of this manually. This video gives me the idea to automate all of that. Thanks for the overview of this!
Thank you Leila for yet another brilliant video. As a newbie to the data world i am wondering when i would use Office Script vs when to use Power Query? Any direction you ( or anyone else reading this) could offer would be gratefully received. Thank you
Can u do a video on PowerPoint? I would really appreciate it. Example; changing the headings and text formatting to a specified design thats been prepared ahead of time
Is there a way to incorporate SAP to Excel using power automate? I use SAP BI links to extract data sets in tabular view and then copy paste these to excel, refresh and update files each month. Is this something that can be automated?
I recently started using office 365 at work. In some desktop files that I have which utilize macros, I have event codes in some of them. One such code is dealing with data validation menus. When someone clicks in any cell that has a dropdown menu, the workbook will automatically zoom in to make the choices appear larger for better readability. Is it at all possible to have something like this with Office Scripts?
Hi Leila. Could you do more videos on OfficeScripts?! I noticed that the Automate ribbon is available on Excel desktop now. Curious if people will start using this instead of VBA.
Hello Ms. Leila, Thank you for another great tutorial. I'm wondering if you can make a video on how to make a simple CRUD using Microsoft Forms or if its not possible maybe you can give some advice on how to make a formatted and ready to print webpage generated from an excel table that was populated from MS forms... Sorry for my bad English, hope you understand what I meant and want to achieve. thanks again...
Hello, thanks for all the very helpful videos. I was wondering if you also have some tutorials about Visio? Every time you come up with a new video I learn so much exciting stuff.
for using the onedrive for power automate, do we need to pay Microsoft? could you please give some excel files to follow the steps of above video? Thanks.
Hello, I wanted to ask if it is possible to check a certain line in an Excel spreadsheet and if it should be empty, to send an automatic email to the respective editor of the line. Thank you very much
Thanks Leila, my productivity increased since I found your channel. I have a question, is it possible to fill down in excel on the web or using script. I want to fill down blanks until next value and fill down that as well. Similar to the go to special in excell desktop app. Will really appreciate
Hi Leila, love your videos, how can i process a .csv file with office script? Your video shows an xls file but if file is .csv? I can't get it to work.
Hi Leila, thanks for this video. Do you know if the automation will work with opening the excel and run run a VBA scrip that connects and log on in SAP for extracting files ? Thank you in advance ,
Thank you for sharing this tutorial. Can we use these scripts to do the following senareo: students answer a quiz in MS forms and then the responses are grades and the mark is sent in a pdf report via outlook? Second: can we use power automate to import questions into a form from an excel file. Thanks
Unfortunately the “Record Actions” button is no longer there, except for the online version of Excel, which has very limited functionality compared to doing it on the Excel app itself.
hi madam, all your videos are always motivating and inspiring to learn excel and its commands. Can you please let me know if there is a way to automate google sheets data without any 3rd party ai tool?
Great vedio, I have the files in sharepoint server instead of onedrive. Is it possible to run office scripts for files which is present in sharepoint server using power automate flow? When I tried for the files present in onedrive it worked but not for files present in sharepoint. It would be better if I got calrity on this. Thanks in advance!
Stay Ahead with Our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
I love your honesty, even with the awkward comments and questions. Thank you for the content, it has taught me a lot!
I did not realise how macros could be integrated with power animate.
I’ve been “stuck” in my personal exploration of power animate and watching you set up the script really helped a few things click.
This knowledge makes me hopeful. Thank you!
I’m glad this helped. It takes time to get used to PA but once we have some patterns we’ll be able to reuse them easily.
Fantastic video, I learned so much. Beautifully presented and you have such a nice voice to listen to! Very pleasing to the ear.
Wow!!! You changed your workplace! And as you said in your Q and A you made a video on this
great! your teaching makes this concept easy to learn. Thanks Leila
Thanks!
Thank you, Kara!
Thanks
Thank you, Jagadeesh!
Hi Leila. Office Scripts and Power Automate together looks very powerful! Thanks for sharing this example. Thumbs up!!
Congratulations Leila for Your 1 Million Subscribers Milestone. Keep Going
Why we love Leila gharani channel.....easy asian accent English and ability to articulate so well.
Wow! I've been out of the Excel/Office loop for a couple of years and what a great surprise - a lot of really neat features have been added! Thanks for a wonderful tutorial!
You're very welcome, Robert!
The excel videos are really great and easy to follow. I wish you did videos on access. Everyone else is so dry or hard to understand.
For me ... a lot to unpack here. But a flawless delivery (once again) ... and Leila's encouragement makes me curious. But I still have a long road to travel before I get "there".
As always ... thank you ... thank you ... thank you.
Hi Leila, I just want to say that your videos are so enjoyable! 😄🤗
Oh thank you!
You have some of the best productivity content. Thanks so much
As usual.... Always delivering the best tutorial. Thanks for this. Forever grateful
My pleasure!
i wish i found your videos like 10 years ago. this was an awesome tutorial.
Glad you like them!
I learnt something new today, thanks a lot! I use Power Automate quite a lot but never used it with Excel scripts. Good to know!
Wow. So much power in the palm of your hands. Thank you
👍
Thanks Leila! I'm just getting into Power Automate and your videos are really helpful
Subscribed to your channel is one of the best things I did in my life 😁
This is the power automate flow I have been looking for! Thank you Leila!
If anyone is like me and not a guru on these things, I just want to explain how I overcome an issue with this flow as it didn’t work for me initially when I was testing it.
This flow only sends 20 files/emails at a time (I haven’t figured out how to disable the limit) and therefore if you have more than 20 files, and your flow fails, you maybe wondering why.
I was testing it with a couple of lines from my spreadsheet (which had 100s of lines and therefore 100s of files in the folder). The two lines I was testing were not in the first 20 files that the flow was searching and that’s why my flow was failing.
I removed all of the files and left the two files that I was testing and the flow worked! Just be aware of this as I was going mental 😅 trying to figure it out!!
Hope this is helpful!
Thanks for sharing your experience!
I love your voice, and your knowledge
Wow! This is such a valuable video!
Thank you Leila for another amazing video!🥰
You are so welcome!
Hmmm, nice video as usual, but need to spend some more time in understanding Office Script and Power Automate before applying them practically. Thanks Leila! 👍
Thanks, Vijay. Yes, I'll also have to learn much more about these tools. But they are exciting :)
@@LeilaGharani Marc
Wow you have so much information. Now to put it in practice :-) thanks
Just learning of Power Automate. Have downloaded and am ready to add it to my skills.
This video was great
i have a question
I can read excel with extension XSLB, with power automaet?
that s even possible?
Thanks a good example of how to combine Power Automate and Office scripts
Clear and nicely explained Leila!
Thank you.
You're very welcome!
what a wonderful effort !!
Takeaways:
Record Actions: allows to write code based on actions that were done inside a sheet, and collections would be a group a sheets that would be modified (there are basic scripts in the MS documentation to make the code).
Flow: are actions that could be scheduled or triggered. Example would be to execute a script to format different excel files that are inside a folder or send personalized emails to each person (based on records in an excel file).
Another great video! Thanks for sharing!!
Tremendous video!! Thank you Leila! Superb!!!
Great video, I learnt so much, thanks Leila! I love how you explain things in your videos!
Does flow update the modify date/time on the file? Who is listed as the modifier?
Brilliant. Your explanations are so easy 😎. Super cool 👍
I'm going to apply this to my daily/weekly/monthly work routine. Hope this will simplify my work which currently I think taking too much of my precious time.
My 14 year old boy brain giggled every time you emphasized "sheet". :) Great introduction to this pairing.
😁
Thank you Leila. This video is vey helpful for me.
i am brazilian.
excellent content 👏👏👏
Leila, thank you for yet another really helpful video.
I note that there is also one dislike - just guessing, but probably from a LOTUS-123 user.
😂
Very interesting. I don't often use Excel online however these are certainly some time saving methods that I can incorporate into my work flows. Thanks Leila.
Glad it was helpful!
Great Tutorial...
This is awesome, can you do a course on PowerAPP (PowerAutomate).
That’s awesome Leila ! Nice tutorial
Glad you like it.
Thanks for this video…this is what im looking to help my monthly reporting
Hay can we run office script through power automate for desktop
Please post more videos with excel, automate and office scripts!!!
hi Leila, you have nicely explained, thank you for video .can u tell me can we use function in Automate.
Hi Leila. I have a report that I build every Monday that starts with data in a CSV file. I import and transform the data using Power Query and then build a pivot table and another table with summary data. I do all of this manually. This video gives me the idea to automate all of that. Thanks for the overview of this!
Couldn’t you potentially do all this with either macros in excel or power bi reports
Hii Leila! Glad to see you! How are you?
Wonderful teacher, wonderful tutorial.
Thank you! 😃
You need to do a course on Power Automate
Yes
I was going to say the same
Agree
Agreed
Agree!
Very excited. Thank you for sharing.
Amazing channel 👏
Thank you 🙌
Very Nice And Very Informative.
Can you use it to refresh reports/queries once you enter a different file into the folder
Thank you Leila for yet another brilliant video. As a newbie to the data world i am wondering when i would use Office Script vs when to use Power Query? Any direction you ( or anyone else reading this) could offer would be gratefully received. Thank you
Thabk you for another informative video.
Great!! Thanks for video on innovative idea…
Hello Leila, is it possible to start an office script by button?
Can u do a video on PowerPoint? I would really appreciate it.
Example; changing the headings and text formatting to a specified design thats been prepared ahead of time
Is there a way to incorporate SAP to Excel using power automate? I use SAP BI links to extract data sets in tabular view and then copy paste these to excel, refresh and update files each month. Is this something that can be automated?
great Stuff
Wonder if we can run a script on "workbook open" or "Workbook Close" similar to VBA functions
I recently started using office 365 at work. In some desktop files that I have which utilize macros, I have event codes in some of them. One such code is dealing with data validation menus. When someone clicks in any cell that has a dropdown menu, the workbook will automatically zoom in to make the choices appear larger for better readability. Is it at all possible to have something like this with Office Scripts?
Always amazing you go girl
Super cool, thanks Leila!
Glad you like it!
👍👍👍 Awesome - thank you
Tks Leila. Very helpful. That's give a lot of idea. After formatting, send à email, do the same but on the power automate desktop
Hi Leila. Could you do more videos on OfficeScripts?! I noticed that the Automate ribbon is available on Excel desktop now. Curious if people will start using this instead of VBA.
Hello Ms. Leila, Thank you for another great tutorial. I'm wondering if you can make a video on how to make a simple CRUD using Microsoft Forms or if its not possible maybe you can give some advice on how to make a formatted and ready to print webpage generated from an excel table that was populated from MS forms... Sorry for my bad English, hope you understand what I meant and want to achieve. thanks again...
Great work. Very clear. Please which software do you use to record your screen?
Love your t-shirt quote👌
Thanks!
Hello, thanks for all the very helpful videos. I was wondering if you also have some tutorials about Visio? Every time you come up with a new video I learn so much exciting stuff.
for using the onedrive for power automate, do we need to pay Microsoft?
could you please give some excel files to follow the steps of above video? Thanks.
خیلی. جالب و کاربردی
Merci.
Hello, I wanted to ask if it is possible to check a certain line in an Excel spreadsheet and if it should be empty, to send an automatic email to the respective editor of the line. Thank you very much
Thanks Leila, my productivity increased since I found your channel. I have a question, is it possible to fill down in excel on the web or using script. I want to fill down blanks until next value and fill down that as well. Similar to the go to special in excell desktop app.
Will really appreciate
Hi Leila, love your videos, how can i process a .csv file with office script? Your video shows an xls file but if file is .csv? I can't get it to work.
Really interesting, I'm wondering if I can apply this to get standard report format in word 🤔 great idea 😃
Hi Leila, thanks for this video. Do you know if the automation will work with opening the excel and run run a VBA scrip that connects and log on in SAP for extracting files ?
Thank you in advance ,
Thanks for the video 🙏🙏🙏
Holy sheet this is amazing, thank you
Thank you for sharing this tutorial. Can we use these scripts to do the following senareo: students answer a quiz in MS forms and then the responses are grades and the mark is sent in a pdf report via outlook?
Second: can we use power automate to import questions into a form from an excel file. Thanks
I was thinking about Power Automate, Leila Uploaded the Video.
At your service 😎
Hi Leila can we refresh a power query using power automate and scripts ?
Unfortunately the “Record Actions” button is no longer there, except for the online version of Excel, which has very limited functionality compared to doing it on the Excel app itself.
hi madam, all your videos are always motivating and inspiring to learn excel and its commands. Can you please let me know if there is a way to automate google sheets data without any 3rd party ai tool?
Great vedio, I have the files in sharepoint server instead of onedrive. Is it possible to run office scripts for files which is present in sharepoint server using power automate flow? When I tried for the files present in onedrive it worked but not for files present in sharepoint. It would be better if I got calrity on this. Thanks in advance!
Can this be used to generate participation certificate and email them to the participants?
Please so more on power automate!
Hi Leila. How can i get the ‘automate’ button on the excel ribbon?
Can we use Excel to schedule teams meeting?🤔🤔🤔🤔
Probably if you can find a way to call Microsoft Graph's API from a script. Ask GPT 4o
Lila, awesome video!
Any idea when or if refresh connections will be available in Office Scripts?
how do i make an office script that runs whenever a workbook is opened?
Thank you
Good steps Leila thanks
I love it how helpful for the workflow this is. But I am on Gsuite. Should I turn to Ms?..