Web Scraping Made EASY With Power Automate Desktop - For FREE & ZERO Coding
Vložit
- čas přidán 13. 06. 2024
- 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
Stay up to date with the latest by signing up to my FREE XelPlus Weekly newsletter: www.xelplus.com/newsletter/
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.
Sweet Jesus. You think she doesn't get paid by Microsoft for peddling their virus "operating system"? Wakey, wakey.
Couldn’t agree more.
They make millions selling their own training products unfortunately
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,
microsoft is probably paying her for the professional featured videos
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!
I truly hope you will consider creating a Power Automate structured course. You are definitely my favorite teacher. Thank you, Leila!
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
Happy retirement! Looking forward to it myself.
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!
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.
Simplifying everything, is what Leila does for us.
As always, a clear explanation with enough demonstration of what you're doing. This is a very powerful tool! Thank you.
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.
This tutorial is easy to follow, informative, and direct. Thanks a lot for this!
Wow Leila. This is brilliant! Please share more as you learn. You're the MVP!!!!
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
Same as you, I've been doing this with Python. I've enjoyed learning it, but PA looks very interesting.
@@bdcash I don't have excel, what do
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)
this was actually where I was hoping for years. I believe this makes a world of difference
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.
I love it. Thank you Leila, you are carrying my professional skills once again
Leila, I cannot thank you enough for this video! My daily work just became a lot easier. 😀👍
You're so welcome!
It's going to make my daily work easier too... (as soon as I find someone to hire me for daily work).😀
@@LeilaGharani Leila you are THE BEST tutorials maker in CZcams by far! Thank you for always sharing and caring about your viewers
Love this demo! I really enjoy learning from you!
Thanks to you I just built my first successful webscraper! I followed your instructions exactly and it worked perfectly. Thank you for this tutorial!
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.
You always make the topics interesting and I always learn a lot from your videos. Great job once again.
I appreciate that, Joseph!
@@LeilaGharani Hey yo, how long did it take to grab those 284 rows ? thanks m'am
Amazing!!! Great video Leila! Thanks a lot for sharing your knowledge!
I'm so filled with joy haven found this tutorial!.
Absolute beauty of a tool!
Thank you dear Leila for yet another super valuable video
Friendly greetings from Amsterdam ;-)
The most brilliant demonstration since the invention of sliced bread ! Thank You !!! 🙏🙏🙏
This is way faster than Scrapy, Beautifulsoup and/or Selenium
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.
It looks pretty useful! Thanks for the tip!
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?
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 !!!
Hey Leila, great tutorial as always. This will help me in my work extensively, so thank you so much for that.
A GREAT teacher for a great application.Fantastic tool
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
Thanks, will do!
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!
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.
I went the same route as you. This will definitely be something I can use!!!
Power Automate = Everyday user
Python = those interested and already know some form of coding, and have time for it
No comparison.
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 czcams.com/video/VkDpwSGWPmk/video.html, is only 8 minutes long, is just a different option
@@sabreaion6074 Thanks, Esteban. I’ll have a look at that.
Wow! I am totally impressed!
Very good introduction and great presentation. Good teachers make the complicated simple! Thanks for sharing.
This was an awesome video . Amazing demonstration with real life example. Hoping to see more content on power automate
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.
You clearly don't hate to be picky. If you would hate it, you wouldn't have said anything :D
Wow. This method is very useful for freelance web scrappers. Thanks a lot.
you made it look so simple! Thank you!
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 ?
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...
My pleasure, Matt! We're just at the beginning of this journey 😊
@@LeilaGharani i am unable to save the file on drive (desktop) please help me out
Thank you so much for this video! It's really very helpful.
This is so amazing and very useful. I really hope you'll make more videos on Power Automate. You're simply phenomenal Leila
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
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
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
beautiful, finally the tool is here thanks.
Love it and excited to explore, I will be using it for Excel files mostly!
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.
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.
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!
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
Yup, so you want to stay stupid in other words?
@@HippieP629 That's why you'll never amount to anything.
Thanks Leila! Very well explained, and easy to understand.
A wonderful video that we've used as a reference for our recent additions. Your sharing is highly appreciated!
Amazing, how many hours I spent in c# to this. Thank you for sharing.
Your first issue is using c#.
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.
same
This is amazing. Thank you very much.
Brilliant Leila, Thanks!
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.
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
Explained really well! Thanks for the video!
Very good tutorial. Thank you,
Thank you! Nice video.
Amazing! Thank you!
Well done, thank you!
Thank you so much Leila!
Thanks a Ton Mam!! It worked perfectly
It's MAGIC 😍😍😍😍 ! Many Thanks
It is so helpful for me. Thank you
Supercool presentation and likewise advice.
You are incredible! Thank You So Much!
You're a great teacher 😊
Thank you so much Leila !!! We should learn this in school !
You have helped me so many times with the tools I need. Thank you. Truly appreciate the service you provide
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!
Awesome. Better than any other tutorial. Thank you so much
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.
Happy to have you as part of our community, Adrián!
Thanks Leila you are authentic and always helpful.
Thank you so much! You're the best.
Brilliant. Very well explained and really useful. Thanks for sharing!
Awesome
Thanks for this great video 👍👍
this is super helpful! Thanks a lot
This is insane thank you!
You're so good at that! OMG!
Thanks For more details on this tutorial.
Power Automate is really game changer
Thank you so much, Leila.
Thanks for the tip!
Another terrific video. Thank you!
Excellent insights!
This is sooo amazing. Thank you so much for this tutorial
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
So powerful! Amazing 🤩
wow Leila this is absolutely magnificent! its very easy to follow and i learn a lot. and i want to actually incorporate this to my work!
Thank you very much for your efforts Leila.
Very great tutorial. Very much in favor of seeing more ways to use this tool.
Was great thank you for this very nice tutorial
Thank you so much for this. I've been looking for a way to do this for months.
Powerful !!. I’ll try, thanks
Thank you so much!! 🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻
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.👏👌🙏
Unbelievable Power!!!!
omg this is exactly what i am looking for. thanks
Wowza! Thank you!