Web Scraping Made EASY With Power Automate Desktop

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

Рет қаралды 1,306,824

Күн бұрын

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Unlock the potential of Power Automate Desktop and say goodbye to tedious manual tasks! Power Automate Desktop is a Windows desktop tool that allows the designing, creation, and running of automated processes. Accessible for free to anybody. It has recording abilities like a macro recorder - you can just record your steps and run it. With Robotic Process Automation (RPA) you can build bots and automate repetitive tasks in a user-friendly drag and drop environment without coding knowledge.
This comprehensive guide dives deep into the world of web scraping using Power Automate Desktop, a powerful tool for automating repetitive tasks across web and desktop applications. Whether you're a professional looking to streamline your workflow or a curious learner exploring automation, this video is your gateway to efficiency.
🖥️ What You'll Learn:
▪️ Introduction to Power Automate for Desktop: Get a grasp of this dynamic tool and its capabilities in automating complex tasks.
▪️ Setting Up Power Automate Desktop: Learn how to set up and navigate through Power Automate, whether on Windows 11 or through your Office 365 account.
▪️ Web Scraping Made Easy: Discover how to efficiently extract data from web pages without any coding required, saving you time and effort.
00:00 How to Use Power Automate Desktop
02:28 Create a Flow
04:22 Browser Automation
06:50 Use Recorder to Create Flow Actions
09:20 Store Extracted Data in Excel Spreadsheet
10:42 Run Flow for Web Scraping
12:28 Wrap Up
🎬 LINKS to more Power Automate videos: • Power Automate | Flow ...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#powerautomate #powerautomatedesktop

Пікірлер: 967

@LeilaGharani 9 ай бұрын

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

@Mekinhumbel 2 жыл бұрын

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.

@AntedianDignitary Жыл бұрын

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 2 жыл бұрын

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!

@hansklein3649 2 жыл бұрын

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!

@kelvinteoh9058 2 жыл бұрын

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.

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

@jackcurl2005 2 жыл бұрын

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

@abdikhaliqmohamoud3373 2 жыл бұрын

Simplifying everything, is what Leila does for us.

@ferrbarrios95 2 жыл бұрын

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)

@quadcorevs Жыл бұрын

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

@alexkim7270 2 жыл бұрын

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

@kanidarck 2 жыл бұрын

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

@MogulGroup1985 2 жыл бұрын

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

@orlandoneto7432 Жыл бұрын

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

@tomr9969 Жыл бұрын

Love this demo! I really enjoy learning from you!

@joefromdc 2 жыл бұрын

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 2 жыл бұрын

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.

@yamilandres Жыл бұрын

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

@Ticky66MN 2 жыл бұрын

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.

@thislingolingo Жыл бұрын

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

@gleysonoliveira802 2 жыл бұрын

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

@LeilaGharani 2 жыл бұрын

You're so welcome!

@omnipop4936 2 жыл бұрын

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

@computerservicesaa 2 жыл бұрын

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

@kentcartridge8709 Жыл бұрын

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

@mariaalcala5159 2 жыл бұрын

Amazing!!! Great video Leila! Thanks a lot for sharing your knowledge!

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

@josephsmith7428 2 жыл бұрын

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

@LeilaGharani 2 жыл бұрын

I appreciate that, Joseph!

@alainportant6412 Жыл бұрын

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

@petermyran4986 2 жыл бұрын

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

@artiflix112 10 ай бұрын

It looks pretty useful! Thanks for the tip!

@cdjdejesus7046 2 жыл бұрын

Wow! I am totally impressed!

@spencerosoroh8882 2 жыл бұрын

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?

@ahmedtareq5342 2 жыл бұрын

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 2 жыл бұрын

Thanks, will do!

@DeepakHarish48 2 жыл бұрын

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.

@EnjoySharePoint Жыл бұрын

Explained really well! Thanks for the video!

@shirshN 2 жыл бұрын

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

@collieclone 2 жыл бұрын

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

@Autoscraping 4 ай бұрын

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

@MarceloMedeirosInfo 2 жыл бұрын

Great video Leila, thank you!

@mattschoular8844 2 жыл бұрын

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 2 жыл бұрын

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

@andrewcharlesmoss 2 жыл бұрын

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 2 жыл бұрын

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 2 жыл бұрын

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

@mr.c6674 2 жыл бұрын

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

@sabreaion6074 2 жыл бұрын

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 kzfaq.info/get/bejne/jNF0o9qErL20nZ8.html, is only 8 minutes long, is just a different option

@andrewcharlesmoss 2 жыл бұрын

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

@nonoobott8602 2 жыл бұрын

This is so amazing and very useful. I really hope you'll make more videos on Power Automate. You're simply phenomenal Leila

@guadalupeaguilera7818 2 жыл бұрын

A GREAT teacher for a great application.Fantastic tool

@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

@saitamassj2475 Жыл бұрын

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

@saitamassj2475 Жыл бұрын

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

@Gloubi06 2 жыл бұрын

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 ?

@Testarix 5 ай бұрын

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

@IlaPatel811 2 жыл бұрын

Love it and excited to explore, I will be using it for Excel files mostly!

@screechowl-hoote4239 2 жыл бұрын

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

@infusionchurchmd 27 күн бұрын

You are incredible! Thank You So Much!

@prasannavenkatesh6612 8 ай бұрын

Thanks a Ton Mam!! It worked perfectly

@TaraCotz 2 жыл бұрын

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

@oddgeirvestad Жыл бұрын

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

@jmmatthews3115 Жыл бұрын

Your first issue is using c#.

@stevensun1945 Жыл бұрын

you made it look so simple! Thank you!

@YouExcelTutorials 2 жыл бұрын

Thanks Leila! Very well explained, and easy to understand.

@SuperP220310 2 жыл бұрын

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 2 жыл бұрын

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.

@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

@rauliato Жыл бұрын

Brilliant. Very well explained and really useful. Thanks for sharing!

@bryancarrera2704 Жыл бұрын

beautiful, finally the tool is here thanks.

@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

@BekBrace Жыл бұрын

Hey Leila, great tutorial as always. This will help me in my work extensively, so thank you so much for that.

@Abdul_Rehman6162 11 ай бұрын

Thanks Leila you are authentic and always helpful.

@MrSantoshKm 2 жыл бұрын

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

@siven3445 Жыл бұрын

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

@jesusaltamiranoagente3131 Жыл бұрын

WONDERFUL VIDEO, it solved a big programming problem for me

@nipunkavinda8254 2 жыл бұрын

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

@hadjamorsofiene1148 Жыл бұрын

It's MAGIC 😍😍😍😍 ! Many Thanks

@ravvenhawk1110 2 жыл бұрын

Thank you very much for your efforts Leila.

@sparkerkingap 7 ай бұрын

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

@TenantRepGuru 2 жыл бұрын

Another terrific video. Thank you!

@huqsami 2 жыл бұрын

So powerful! Amazing 🤩

@hichamjawhari9012 Жыл бұрын

This is amazing. Thank you very much.

@pilotgundul Жыл бұрын

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

@yousefhassan7365 Жыл бұрын

Brilliant Leila, Thanks!

@prembeejan4815 2 жыл бұрын

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

@beaucottrell5470 2 жыл бұрын

Wow!! Just Wow!! Excellent teacher!

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

@CloudContext 2 жыл бұрын

Really powerful tool. Thanks Leila

@diegolozano2397 Жыл бұрын

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

@padynz9869 Жыл бұрын

A great, very lucid video which truly enables you to create Power Automate flows hands on. The clarity is indeed commendable. Thank you very much.👏👌🙏

@tosmanhype9419 Жыл бұрын

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

2 жыл бұрын

Powerful !!. I’ll try, thanks

@MarceloSantosSCS 11 ай бұрын

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!

@saisatik Жыл бұрын

Very good tutorial. Thank you,

@techno_andy Жыл бұрын

It is so helpful for me. Thank you

@Nas_Vinspired Жыл бұрын

Amazing! Thank you!

@bbgapp8589 3 ай бұрын

Was great thank you for this very nice tutorial

@allabouthinn Жыл бұрын

this is super helpful! Thanks a lot

@eli.jiah.meowmeow 2 жыл бұрын

Thank you! Nice video.

@TiM2US Жыл бұрын

Thank you so much Leila!

@Jerrel.A Жыл бұрын

Supercool presentation and likewise advice.

@FarhanMerchant 2 жыл бұрын

Excellent insights!

@Eireman1965 7 ай бұрын

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

@andypuempel2570 2 жыл бұрын

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

@scottx1415 Жыл бұрын

Well done, thank you!

@dynaxzhang2539 7 ай бұрын

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!

@AdorianGP 2 жыл бұрын

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 2 жыл бұрын

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

@pleabargain Жыл бұрын

Very useful. Thank you.

@EricaDyson 2 жыл бұрын

Magic indeed and magically explained.

@nicolacuomo8914 Жыл бұрын

You're so good at that! OMG!

@akshayp3879 Жыл бұрын

You're a great teacher 😊

@wizeman8532 Жыл бұрын

Thank you so much! You're the best.

@turangenc7057 2 жыл бұрын

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