Scraping from web (with interaction) in Microsoft Power Automate for Desktop
Previously, we've talked about how you can use Microsoft Power Automate for Desktop web automation to scrape data from the web.
But other than passively scraping information that's already there on the web, we can also use web automation to interact with the website—for example performing a query—and then scrape the results.
This is what we're going to go through in today's video.
In today's video, we'll automate going to a website, pressing a button to generate the results, then scraping the results — repeating this process multiple times and populating each result in Excel.
Watch the video and learn to do it for yourself!
00:00 Introduction
00:14 The scenario
00:27 The website we're scraping from
01:09 Start building the flow to scrape data from the website
01:56 Loop to generate and scrape results multiple times
02:34 How to select the UI elements on the web page
03:23 How to extract/scrape the results from the web page
04:02 How to write the scraped results to Excel
07:20 Running the flow again appends new results to end of Excel file
Related videos:
Basics of web automation and scraping data from web: • Scraping data from the web in Microso...
Loop action: • How to use loops in Microsoft Power A...
Excel automation (including write to Excel, get first free row): • Power Automate Desktop Excel Automati...
Interacting with windows & applications (basics on UI Elements, including renaming UI elements, are covered here): • How to Interact with Windows and Appl...
Смотрите видео Scraping from web (with interaction) in Microsoft Power Automate for Desktop онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь MS Power Automate 22 Октябрь 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 8,762 раз и оно понравилось 127 людям.