Web Scraping Made EASY With Power Automate Desktop - For FREE & ZERO Coding
ฝัง
- เผยแพร่เมื่อ 19 มิ.ย. 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!
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!
I truly hope you will consider creating a Power Automate structured course. You are definitely my favorite teacher. Thank you, Leila!
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.
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)
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.
Thanks to you I just built my first successful webscraper! I followed your instructions exactly and it worked perfectly. Thank you for this tutorial!
As always, a clear explanation with enough demonstration of what you're doing. This is a very powerful tool! Thank you.
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.
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.
Wow Leila. This is brilliant! Please share more as you learn. You're the MVP!!!!
I love it. Thank you Leila, you are carrying my professional skills once again
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.
this was actually where I was hoping for years. I believe this makes a world of difference
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
Absolute beauty of a tool!
Thank you dear Leila for yet another super valuable video
Friendly greetings from Amsterdam ;-)
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!
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
Simplifying everything, is what Leila does for us.
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 !!!
This tutorial is easy to follow, informative, and direct. Thanks a lot for this!
Love this demo! I really enjoy learning from you!
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 TH-cam by far! Thank you for always sharing and caring about your viewers
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?
Amazing!!! Great video Leila! Thanks a lot for sharing your knowledge!
Wow. This method is very useful for freelance web scrappers. Thanks a lot.
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!
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
I'm so filled with joy haven found this tutorial!.
A GREAT teacher for a great application.Fantastic tool
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 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 ?
Love it and excited to explore, I will be using it for Excel files mostly!
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
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 th-cam.com/video/VkDpwSGWPmk/w-d-xo.html, is only 8 minutes long, is just a different option
@@sabreaion6074 Thanks, Esteban. I’ll have a look at that.
This was an awesome video . Amazing demonstration with real life example. Hoping to see more content on power automate
Thank you so much for this video! It's really very helpful.
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....
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
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
This is so amazing and very useful. I really hope you'll make more videos on Power Automate. You're simply phenomenal Leila
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.👏👌🙏
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.
for point 2: waiting for application to load is the default option in PDA
i am unable to save the file on drive (desktop) please help me out
@@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?
@@SamiJumppanen own laptop and tried to save to other folder but unable to save file
@@karunsgr by any chance, does the filename have characters that are not allowed in file names? Really difficult to guess what is the problem.
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.
A wonderful video that we've used as a reference for our recent additions. Your sharing is highly appreciated!
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.
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.
Amazing, how many hours I spent in c# to this. Thank you for sharing.
Your first issue is using c#.
Very good introduction and great presentation. Good teachers make the complicated simple! Thanks for sharing.
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 TH-cam 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!
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
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
Brilliant. Very well explained and really useful. Thanks for sharing!
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!
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
You have helped me so many times with the tools I need. Thank you. Truly appreciate the service you provide
Hey Leila, great tutorial as always. This will help me in my work extensively, so thank you so much for that.
Thanks Leila! Very well explained, and easy to understand.
Mind-blowing!! Thanks for the video so much potential here. Would be good to hear ideas from others though as to how it can be used 👍
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!
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!
you made it look so simple! Thank you!
So powerful! Amazing 🤩
Don't currently need this but I'm sure it will serve me well in the future. Thank you!
This is sooo amazing. Thank you so much for this tutorial
Awesome. Better than any other tutorial. Thank you so much
This is insane thank you!
beautiful, finally the tool is here thanks.
Very great tutorial. Very much in favor of seeing more ways to use this tool.
Thanks Leila you are authentic and always helpful.
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!
Thank you so much for this. I've been looking for a way to do this for months.
Thanks very much for your easy to follow demo, this is exactly the tool that I need right now.
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.
👍
Thank you very much for your efforts Leila.
Wow! I am totally impressed!
Explained really well! Thanks for the video!
Another terrific video. Thank you!
Thanks in a million Leila . Great content. Awesome. Grade: A++💥
Wow!! Just Wow!! Excellent teacher!
Terrific. A lot like Selenium but without all the back end fuss.
Love your tutes.
WONDERFUL VIDEO, it solved a big programming problem for me
Powerful !!. I’ll try, thanks
This is really interesting and thank you so much for cristal clear explanation
Can't wait to give this a try!
Wow. Impressed with both Leila and Power Automate
Thank you so much Leila !!! We should learn this in school !
Thank you Leila for this amazing video. You are awesome.
Wow - thank you for this video - i didnt know we could do that . Its a game changer for our business .
It looks pretty useful! Thanks for the tip!
Thanks For more details on this tutorial.
Power Automate is really game changer
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!
This is really interesting.thanks a lot for the video!
😃 really interesting tutorial. You're always the best Leila 😎
This is so cool, super happy I found this, I hope i get to use it in the near future.
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!
Glad I could help, David!
Really powerful tool. Thanks Leila