Web Scraping Made EASY With Power Automate Desktop - For FREE & ZERO Coding

[@LeilaGharani]

Stay up to date with the latest by signing up to my FREE XelPlus Weekly newsletter: www.xelplus.com/newsletter/

[@Mekinhumbel]

Leila, Microsoft should be paying you millions of dollars. You are always so on top of this stuff, and the way you present it, it's just instantly useful. You've single-handedly saved hundreds of hours of tedium in my office just because of one class of yours I took on Udemy.

[@onepalproductions]

Sweet Jesus. You think she doesn't get paid by Microsoft for peddling their virus "operating system"? Wakey, wakey.

[@diegolombardo4815]

Couldn’t agree more.

[@ChipsChallenge95]

They make millions selling their own training products unfortunately

[@alainportant6412]

It's not worth anything if I have to master-bait every time she shows a little bit of skin ! Which she does less than other female people ,granted. But still,

[@wicleansoon3530]

microsoft is probably paying her for the professional featured videos

[@rluzius]

Are you kidding me?? I just find out about this after I retired 6 months ago!! This would have made my data analysis job so much easier.. Thank you Leila

[@alangrant5684]

Happy retirement! Looking forward to it myself.

[@ZarakhCreations]

This video is a LIFE SAVER. I've been trying to extract data manually from one of our internal systems where it is not stored nicely on the backend either. This just saved me HOURS of work. And that's just for this one task. Phenomenal!

[@MariaLilavera-nv8xe]

I truly hope you will consider creating a Power Automate structured course. You are definitely my favorite teacher. Thank you, Leila!

[@vantrillo6360]

I usually spend half an hour coding webscrapers using python's bs4, but work policies restricted download of extraneous programs. I came here looking for a tool to make quick webscrapers to extract data, but left with ideas to automate my daily mundane routines. Thank you for making this tutorial.

[@abdikhaliqmohamoud3373]

Simplifying everything, is what Leila does for us.

[@kelvinteoh9058]

Thank you Leila. You're truly a Godsent. I actually attended a class on RPA to learn this but those tools cost quite a pretty penny and most require some form of subscription. With power automate, it'll just be a one time investment of a sufficiently powerful computer. Based on what I've seen you do, it seems almost similar though this seems more intuitive. I was actually talking to my boss a couple of days ago about web scraping and how we could possibly use power query to do it but you just brought this up to the next level! Thanks again for this video.

[@joefromdc]

1. Key points in using the record, make sure to pause and wait for the red box to go around the item you wish to select. 2. Make sure to add 'Wait' time to your process if you are opening and running an application.

[@hu04119]

for point 2: waiting for application to load is the default option in PDA

[@karunsgr]

i am unable to save the file on drive (desktop) please help me out

[@SamiJumppanen]

@@karunsgr Are you trying on your own computer or educational / work installation? There could be restrictions on saving to desktop by the company policy. Have you tried to save to other folders?

[@karunsgr]

@@SamiJumppanen own laptop and tried to save to other folder but unable to save file

[@SamiJumppanen]

@@karunsgr by any chance, does the filename have characters that are not allowed in file names? Really difficult to guess what is the problem.

[@hansklein3649]

Really impressive toolkit! After the possibility of catching any video or audio if you watch or hear it, and macros in the internet browsers, which do the same, but only for html, finally comes the next level of automatisation. Interactive and efficient!

[@alexkim7270]

Wow Leila. This is brilliant! Please share more as you learn. You're the MVP!!!!

[@ferrbarrios95]

I've been using it for a few months now but never put the record feature to good use, I thought it just wasn't that reliable. Learning something new from you as always! (Awesome context by the way)

[@kanidarck]

I love it. Thank you Leila, you are carrying my professional skills once again

[@jackcurl2005]

As always, a clear explanation with enough demonstration of what you're doing. This is a very powerful tool! Thank you.

[@tomibuildsai]

I'm so filled with joy haven found this tutorial!.

[@spencerosoroh8882]

Leila, you are a rare gem. Thank you for enlightening Spreadsheet enthusiasts like me. Please, how may I have a one on one chat with you?

[@quadcorevs]

this was actually where I was hoping for years. I believe this makes a world of difference

[@gleysonoliveira802]

Leila, I cannot thank you enough for this video! My daily work just became a lot easier. 😀👍

[@LeilaGharani]

You're so welcome!

[@omnipop4936]

It's going to make my daily work easier too... (as soon as I find someone to hire me for daily work).😀

[@computerservicesaa]

@@LeilaGharani Leila you are THE BEST tutorials maker in KZbin by far! Thank you for always sharing and caring about your viewers

[@MarceloSantosSCS]

Leila, sensational video. As already said here, Microsoft should collaborate with you financially, I don't know how. This simple and didactic explanation saved me dozens of hours of processing that I was going to do manually. Thank you very much!

[@MogulGroup1985]

Thank you for the content. I’ve been also down the python road and I absolutely love how simple you put this information out. I think this really helps so much with simple task. Thank you

[@bdcash]

Same as you, I've been doing this with Python. I've enjoyed learning it, but PA looks very interesting.

[@alainportant6412]

@@bdcash I don't have excel, what do

[@raquelocasio8588]

Thanks to you I just built my first successful webscraper! I followed your instructions exactly and it worked perfectly. Thank you for this tutorial!

[@kentcartridge8709]

The most brilliant demonstration since the invention of sliced bread ! Thank You !!! 🙏🙏🙏 This is way faster than Scrapy, Beautifulsoup and/or Selenium

[@hugo_alves]

Really good tutorial! Exactly what i was looking for as the first step on my Power Automate learning The next step i would like to do is Automating a "Learning Plan by User" which is: - a Complete List of Videos (This Web Scraping step) - Trigger Video List update (eventually new videos might come up) - What is the last video i watched - What is the next video to watch

[@josephsmith7428]

You always make the topics interesting and I always learn a lot from your videos. Great job once again.

[@LeilaGharani]

I appreciate that, Joseph!

[@alainportant6412]

@@LeilaGharani Hey yo, how long did it take to grab those 284 rows ? thanks m'am

[@nipunkavinda8254]

Wow. This method is very useful for freelance web scrappers. Thanks a lot.

[@collieclone]

This is so powerful, I am in awe of it! Thank you so much for making this video and making me aware of Power Automate. I hate to be picky, but there is a difference between scrapping and scraping. Scrapping would mean throwing away, throwing on the scrap heap. Scraping (with an a pronounced like the a in making) is what we are talking about here.

[@111princeps111]

You clearly don't hate to be picky. If you would hate it, you wouldn't have said anything :D

[@Ticky66MN]

Wow...this blows me away with the possibilities this offers. Thank you for introducing me to this and I look forward to more on this tool.

[@mattschoular8844]

Thanks Leila, From this video, i liken Power Automate to Power Query in that I had no idea of the potential of PQ until I started using it. I imagine once I start tinkering with PA, it will become a "go to" solution to many tasks. I am certain your audience would value more PA videos as you develop you knowledge base. Thanks for sharing...

[@LeilaGharani]

My pleasure, Matt! We're just at the beginning of this journey 😊

[@karunsgr]

@@LeilaGharani i am unable to save the file on drive (desktop) please help me out

[@CozmoNz]

I've done alot of automation in Python and honestly - this is so much easier, Python will do exactly what you say but there is a barrier of entry for a lot of people - Hopefully this can help a lot of our workforce!

[@HippieP629]

I started learning python a couple yrs ago to do things like this but fizzled out after a week. I think I'd rather do things this way

[@xXx-lfg]

Yup, so you want to stay stupid in other words?

[@xXx-lfg]

@@HippieP629 That's why you'll never amount to anything.

[@andrewcharlesmoss]

That’s really interesting. Only a few months ago did I need to scrape content from multiple web pages, but I soon realised that Power Query’s limitations were an obstacle. That led me to go down the Python route, but Power Automate looks like another option. Thanks!

[@jmc3179]

Honestly, for scrapping I would stick to Python. However, I will be using this at work since I'm the only person that uses Python in my division. Power Automate is a new one for me, and it seems it can be used by anyone.

[@michelleamidon2083]

I went the same route as you. This will definitely be something I can use!!!

[@mr.c6674]

Power Automate = Everyday user Python = those interested and already know some form of coding, and have time for it No comparison.

[@sabreaion6074]

You can try doing it with Power Bi Desktop, there you will make a Query than can scrap multiple pages, I will leave you the link from a video that I found kzbin.info/www/bejne/jJynoaqJfLyDo80, is only 8 minutes long, is just a different option

[@andrewcharlesmoss]

@@sabreaion6074 Thanks, Esteban. I’ll have a look at that.

[@hooplernono7033]

Thanks!

[@LeilaGharani]

Thank you!

[@hooplernono7033]

@@LeilaGharani You are very talented 👏 and pretty!

[@ahmedtareq5342]

Fantastic, I have been waiting for you to explain power Automate in your amazing, simplified way. Please upload more tricks and tips for this amazing software

[@LeilaGharani]

Thanks, will do!

[@guadalupeaguilera7818]

A GREAT teacher for a great application.Fantastic tool

[@oddgeirvestad]

Amazing, how many hours I spent in c# to this. Thank you for sharing.

[@prembeejan4815]

It's wonderful. I thought Excel has changed to PQ and no page content can be extracted now. But I did not know that PAD ever existed. Thanks Leila

[@yamilandres]

Absolute beauty of a tool! Thank you dear Leila for yet another super valuable video Friendly greetings from Amsterdam ;-)

[@subhrajyotisaha4u]

Leila - You are a Super Woman!!! Thanks I just created my first flow and I am blown away

[@TaraCotz]

I am using this but it's very specific and sensitive. When you use Web scraping on BeX Windows the steps are not always easy to work with. The slight shift in the layout of the webpage the whole automation get thrown off

[@Bigsupreme2000]

I do web scraping as job. I know why exactly these tools still dont work best for everyone 1. Gets Harder the complicated the website structure gets 2. Requires above average technical knowledge, not for everyone 3. Requires constant investigation. Even if you get it working a few times in some examples, it fails at others 4. Will not tackle website blockage, anti blocking mechanism, captcha solving etc. 5. No data validation So, This stuff is still extremely hard .. but useful for very simple automations This thing is, like saying that apple is trying to replicate DSLR features and power in its iphone, but sure it will let everyone scrape simple data now, it will increase burden on web traffic and websites though

[@z.c.e.l.s.6189]

Thanks

[@LeilaGharani]

Thank you!

[@shirsN]

This was an awesome video . Amazing demonstration with real life example. Hoping to see more content on power automate

[@orlandoneto7432]

This tutorial is easy to follow, informative, and direct. Thanks a lot for this!

[@Gloubi06]

Thank you for this clear and well documented presentation! Can you drill down each of the links on the page (the ones you've collected in XLS) and collect information on the linked page (author of the training video, date, ...) and recursively do this for all 285 ish pages ?

[@tomr9969]

Love this demo! I really enjoy learning from you!

[@petermyran4986]

Thanks so much for making me aware of this very promising tool!! I would love to see more use case type videos using Power Automate from you. I would like to see you do more complex web scraping where website navigation and search inputs are required to get desired results. And then there all the other non-web automation possibilities - love to see exploration videos on these. Thanks Leila - I have learned so much from you and I am very grateful !!!

[@screechowl-hoote4239]

Great video, Leila! A suggested video I'd like to see is the possibility of using a list of data in excel to file out a form per entry from excel. Is this possible with power automate? Thanks

[@AdorianGP]

Mind-blown, amazing tips and the potential of this automation tool for my workflow is tremendous. Thank you Leila, your channel is such a life-saver, I owe so much over these years I can only be grateful.

[@LeilaGharani]

Happy to have you as part of our community, Adrián!

[@SuperP220310]

So cool! Thank you, Leila! It worked perfectly. The only issue I encountered - after having made some adaptations and running the flow - was that the web page did not respond any more. Is it possible that some sites block attempts of being scraped? I tried it before with PowerBI Desktop and wanted to add table columns with examples - but I could not see the preview of the web site at all.

[@markusher1621]

I've also had this problem with a few websites using not just Power Automate but any macro or webscraping tool. I run into the problem mostly with websites that allow you to download a very large number of records but with the constraint you can only download them in chunks of records at a time. For example, 250,000 record in chunks of 250 records a time. After you've downloaded each chunk of 250 records, you have to reenter initial criteria to get the next 250. So you'd need to do this 1,000 times to get all the data. I can usually webscrape the first 250 ok with a tool like Power Automate (which helps somewhat), but whichever app or macro I use, it freezes after the first loop and cannot do the 2nd or subsequent scrape of the next 250. It may very well be, as you suggest, some type of block.

[@DeepakHarish48]

Your videos help people alot. Even I power automate earlier and it's simple amazing. Better than many paid version RPA tools in the market. I simply love it.

[@hussainmashraki2512]

I am not able to do the "Set Element as Pager". Only the first page is scraped rest are not scraped in the Excel File. Please Help.

[@vincentlartigue157]

same

[@turangenc7057]

As to be honest you are the best teacher about what you are teaching. It could be excel, outlook etc..So I was looking for web scraping tools and tried a few of them. But it is kind of complicated for me ı was looking smt simple. I didn't know that you have education tutorial on web scraping. but what I dıd: I searched on youtube as "web scraping Leila":) then came across your "power automation" tool. The recording option is great smiliar to excel vba. by this way you don't have to memorize lots of actions regarding what you are doing. You are great!! I love the way you are teaching. Thanks Leila....

[@TauvicRitter]

Great explanation. However this is the happy path. Not every website works with this webscraping tool and when it doesnt work your left in the dark why it doesnt work.

[@Bigsupreme2000]

Ofcourse, thats why there are pro webscraping tools n companies out there But this could be a life saver for those who wanted to get basic info for some pages instead of hunting and chasing complicated freelance scraping services

[@dynaxzhang2539]

Leila,thank you so much!Your video is very useful to me,help me to save time in scraping data from some website.I have tried many tools but failed,until I found your video!

[@Bluessoulphoenix]

Literally thanks to all the tips on this channel I've pretty much gotten 70% of my work automated! Hopefully this can do the other 20% that can be automated

[@LeilaGharani]

That's great to hear!

[@RaxLakhani]

I'm keen to hear from people who are using Leila's Web scraping example in new and creative ways - both from a business perspective and for personal projects. Leila's example was really helpful to watch but I'd love to see instances where this could be used to scrape Google searches or data from Twitter without having API access.

[@julescaruso4398]

Very great tutorial. Very much in favor of seeing more ways to use this tool.

[@Autoscraping]

A wonderful video that we've used as a reference for our recent additions. Your sharing is highly appreciated!

[@gintomino4136]

She's my best teacher. A lot of things I've learned from her made me for where I am now in my career. Thank you!

[@atifmir7409]

Really useful and clearly explained thanks. Microsoft has really improved Power Automate desktop since the last time i used it. It looks really user friendly.

[@Testarix]

Awesome. Better than any other tutorial. Thank you so much

[@billwebb8561]

Apparently, PAD is available to anyone with a Microsoft account. I have Windows 10 Pro and an older version of family 365. I was able to log in to my MS account and download and run the PAD App. Can't wait to try it using it to harvest and create a catalog or library of KZbin URLs of "How To Vids or Tutorials" into an Excel SS. I am going to try and capture the view count and date and video length so I will be able to sort the most viewed videos by topic so I can reduce the time finding the best (or most viewed ) to view. Thank you Leila for all your time and hard work and well-presented Videos. You present, clearly, concisely and produce what I think are The Best and most useful vids for my technical areas of interest. Your work is much appreciated!

[@veelastname]

This would prove immensely useful if I could figure out how to apply automation to so many repetitive and multistep tasks I do every day at work!

[@tosmanhype9419]

Thank you so much Leila !!! We should learn this in school !

[@diegolozano2397]

Thanks, a big hug from Colombia 🇨🇴🇨🇴🇨🇴

[@veriteprogramming5369]

Great help.. Happy learning.. Greetings from Auroville Tamil nadu India 😀

[@andy.puempel]

Very good introduction and great presentation. Good teachers make the complicated simple! Thanks for sharing.

[@MrSantoshKm]

Thank you so much for this video! It's really very helpful.

[@yuisko]

This just changed my life, ty.

[@aatariq186]

I really want more videos on Power Automate on your channel.

[@3dtechnik]

Thank you! The tool is really powerful and your video gives a great simple-to-use example to dig into RPA "Windows Style". Now I am eager to play around. This could also be used to migrate all blog posts in case of incompatible blog systems.

[@LeilaGharani]

👍

[@jesusaltamiranoagente3131]

WONDERFUL VIDEO, it solved a big programming problem for me

[@kcharles8857]

I had no idea that tool even existed. Many thanks.

[@sparkerkingap]

Thank you so much for this. I've been looking for a way to do this for months.

[@Javatician]

8:30 . This is the magic moment. Picked up a pattern .

[@pvsraaaa865]

Wow. Impressed with both Leila and Power Automate

[@Eireman1965]

Thanks very much for your easy to follow demo, this is exactly the tool that I need right now.

[@lochadi]

My favorite teacher 👩‍🏫 ❤

[@michelleamidon2083]

Work has just said we will be learning power automate....thanks for this!!!

[@mowtown75]

Terrific. A lot like Selenium but without all the back end fuss. Love your tutes.

[@siven3445]

You have helped me so many times with the tools I need. Thank you. Truly appreciate the service you provide

[@selcukkara1037]

as a woman instructor, your narrative is great , smooth, and simple and heart touching and very good of understanding and teaching, i have watched other vids about this topic , so far the best

[@rettsu7]

Today my boss gives me a task: I need to scrape all notebooks from different sites with specific processor series (inc. Brand name, processor and the link). I done this manually in two hours (total close to 900 rows), but I think with that I can do this task much faster. Also love your channel, I found here a lot of useful information about Excel.

[@kunalpunjabi6362]

You're a god sent !!!

[@pilotgundul]

Thanks For more details on this tutorial. Power Automate is really game changer

[@theterminaldave]

This is so cool, super happy I found this, I hope i get to use it in the near future.

[@mafhper]

Thanks for encouraging me to create some automations in my service.

[@lukespooner7796]

This is insane thank you!

[@bryancarrera2704]

beautiful, finally the tool is here thanks.

[@techtimes1985]

Wow wow, extremely grateful for this tutorial

[@Abdul_Rehman6162]

Thanks Leila you are authentic and always helpful.

[@jeetugurgao]

Thank you Madam ji I will implement this today to open few web sites and what you have shown

[@wittbike6743]

Greatful automation possibilties. Thank's for your statement.

[@cdjdejesus7046]

Wow! I am totally impressed!

[@jakeliujakeliu]

This is great stuff👍 , please create a course on this software. Look so much easier than Selenium.

[@nicolacuomo8914]

You're so good at that! OMG!

[@babyblue7798]

this teacher is amazing!

[@EricaDyson]

Magic indeed and magically explained.

[@wethepeoplesm]

Please make more of these video tutorials for PowerAutomate, very informative.

[@dudemannxs]

Holy moly! I was trying to do this in Python when I ran into not being able to extract from javascript objects. I came across your video, and problem solved in minutes! Awesomenes!

[@LeilaGharani]

Glad I could help, David!

[@Diamond0dust]

You're a great teacher 😊

[@ricardoluizmarcello]

Wow that’s such a wonderful tool

[@jgs_inspirational_videos]

This tool is a serious game changer!!! Great video by the way. Thank you.

[@LeilaGharani]

Thank you!