Web Scraping with RegEx in Power Automate Desktop - Advanced Use Case

Video Description

This video shows how to do advanced web scraping in Microsoft Power Automate Desktop. In the use case, you will also learn how to create and use Regular Expressions, RegEx, in your Power Automate Desktop flows. VIDEOS FOR YOU: 🔹 Power Automate Desktop for Beginners: https://youtube.com/playlist?list=PLXXz88_TPiHpY_5bfeV8RAOHnBKgc-rtw 🔹 Save Web Data to Excel - Power Automate Desktop Advanced: https://youtu.be/7R5EjshDoQU POWER AUTOMATE DESKTOP GROUPS: 👨‍👩‍👧‍👦 Discord: https://discord.gg/iloveautomation - Join my network with 4000+ Automation/RPA developers, where we solve Automation/RPA problems, network, and help each other upgrade our careers. It's free! 👩🏻‍🎓 LinkedIn: https://www.linkedin.com/groups/12566435 👨🏻‍💻 Facebook: https://www.facebook.com/groups/754059285247921 FOLLOW ME: 💼 LinkedIn: https://www.linkedin.com/in/andersjensenorg 📸 Instagram: https://www.instagram.com/andersjensenorg 👨 Facebook: https://www.facebook.com/andersjensenorg 🐦 Twitter: https://twitter.com/andersjensenorg 💌 Email Newsletter: https://andersjensen.org/email-newsletter 00:00 Intro We want to do advanced web scraping in Microsoft Power Automate Desktop with the help of Regular Expressions, RegEx. RegEx is a series of characters that defines a search pattern. 00:52 Creating a Regex Pattern The best online RegEx tester is regex101, which we use to create a RegEx. RegEx is excellent for structured data, where we can make an exact rule or at least a few rules. 06:04 Dynamic URL - URL with a variable Scraping web data in Power Automate Desktop is easy, but we can prepare the data to scrape to make it easier. One is to use a direct URL instead of having our RPA click UI buttons. We'll also see how to create a dynamic URL based on today's date, using a variable in a URL. 13:12 Advanced CSS work To extract the URL of the web page element, we need to know a little CSS. Open the Developer Tools in Chrome to inspect our element, and then in Advanced Settings, in the Extract data from web page action, create your CSS selector. 16:14 Create and use a DataTable We can create DataTable in several ways. I prefer a Set variable over the native Power Automate Desktop activities because it's easily customizable. Iterate through a DataTable with a For each. Updating a DataTable is easy with a Set variable, where we can add an entire DataRow. For reference, a DataTable is a collection of DataRows. 21:08 Save to Excel We save our DataTable to Excel. 25:34 Use RegEx in Power Automate Desktop The Parse text action allows us to use Regular Expressions in Power Automate Desktop. #powerautomate #powerplatform #office365