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

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

FOLLOW ME:

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

[dustyroads]

How one would get this information and technique other than Anders’ videos . . . Thank you for quick and clear instruction on web scraping. You’re the best.

[lbp]

Great explanation, REGEX and Automation made easily.

[bochristensen]

Great video. Thank you very much for solving my problem! I need to learn more regex!

[ALVINMAN]

One more excellent video. Many Thanks. I´m waiting for your RegexVideo.

[andersjensenorg]

Thanks for all your support and help 🙌🔥
Place your Power Automate Desktop problem/use case here in the comments, and I might solve yours in next week's video 😊

[GuppyTrader]

Thanks for sharing. PS. In case you didn't get it the '-' is called hyphen in English

[oricchannel]

Ctrl-C Ctrl-V: Another great video where a I learned a lot and where a could review RegEx concepts. Thank you for sharing !!!

[EdTignor]

Great information. Thanks for making these videos!

[suraj_singh]

Hii Anders Jensen sir make a video on Orchestrator API using Postman and Orchestrator HTTP Activity uipath as soon as possible appreciate your Hardwork

[jj_bellajonefriendsfireysa]

can I use power automate as test automation tool (like selenium) for browser base application, if yes, which particular category i need to focus on and also much better if you include testing automation with your course

[nandansubramanya]

why did you not put the regex in 15:24, you could have a duplicate CSS selector with different regex? In that way the for loop is not required?

[MsRiko]

Hi anders, I got Results from webscraping contains many line breakup when writed to excel. Excel feature seems such as text to column doesnt work in this case because so much data maybe.

[perfectvideomixing_pvm]

"I don't want to complicate tNice tutorials video" I was out from the first second

[alexlijesen]

157 / 5.000
Vertaalresultaten
Can you use the groups in Regex/automate desktop. I would like to select the 3rd word and the 5th word from a string and copy them via a variable