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 for Beginners: • Power Automate Desktop...
🔹 Save Web Data to Excel - Power Automate Desktop Advanced: • Save Web Data to Excel...
POWER AUTOMATE DESKTOP GROUPS:
👨‍👩‍👧‍👦 Discord: / discord
- 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: / 12566435
👨🏻‍💻 Facebook: / 754059285247921
FOLLOW ME:
💼 LinkedIn: / andersjensenorg
📸 Instagram: / andersjensenorg
👨 Facebook: / andersjensenorg
🐦 Twitter: / andersjensenorg
💌 Email Newsletter: andersjensen.org/email-newsle...
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

[@andersjensenorg]

Thanks for all your support 🙌😍
Watch this video next: ruclips.net/video/POfK2A8iWAs/видео.html

[@dustyroads7067]

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.

[@andersjensenorg]

Hey Dusty - I'm so glad you liked the video and for all your support ❤

[@EdTignor]

Great information. Thanks for making these videos!

[@andersjensenorg]

Thank you so much for all your support, Ed 🙌😎 Kind regards, Anders

[@007lbp]

Great explanation, REGEX and Automation made easily.

[@andersjensenorg]

Thanks a ton, Leandro 😍

[@ALVINMAN452]

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

[@andersjensenorg]

I'm so happy for all your support 😍 Kind regards, Anders

[@bochristensen9582]

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

[@andersjensenorg]

My pleasure, Bo - glad you liked it. Yeah, RegEx is powerful - I would "just" spend 1-2 hours on a good RegEx guide here on YT, e.g. this ruclips.net/video/sa-TUpSx1JA/видео.html See you 🙂

[@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 😊

[@PS-ej7ru]

Thank You Sir for sharing. 😇

[@andersjensenorg]

You're very welcome, PS 😍

[@oricchannel2811]

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

[@andersjensenorg]

I'm so happy that you took your time to comment - thanks a lot 🙌🙂

[@GuppyTrader1968]

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

[@andersjensenorg]

A pleasure, and thanks a lot for that - I'll remember it for the next 😀

[@HammamDisini]

Thanks Anders for sharing this

[@andersjensenorg]

Thanks a ton, Hammam Disini - Excel 🤩 Have a great day. Kind regards, Anders

[@happy9955]

you are the best

[@andersjensenorg]

Thanks a lot, happy 🙋‍♂️😍

[@alexgreen8231]

Great video, thanks 👍

[@andersjensenorg]

My pleasure, Alex 🙌😊

[@suraj_singh321]

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

[@andersjensenorg]

Hey suraj singh Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: ruclips.net/video/C6xmGfEL07I/видео.html Have a great day. Kind regards, Anders

[@MsRiko99]

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.

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 7000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders

[@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?

[@andersjensenorg]

Hey Nandan. Thanks a lot for your suggestion. Sure, we can often do things differently. To answer your question: Simplify things and make them easier and customizable. I do it directly in this video: ruclips.net/video/WXK0u2yXLrU/видео.html (at 45:43). Kind regards, Anders

[@jj_bellajonefriendsfireysa3126]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 4500+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders

[@alexlijesen6197]

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

[@andersjensenorg]

Hey alex. For sure, how about this: regex101.com/r/dRP3N0/1 Kind regards, Anders

[@alexlijesen6197]

@@andersjensenorg hello Anders thanks for your response unfortunately I get an error message when I use this pattern in parse text powerautomate desk Main this is the message : Specified regular expression is invalid : "^(?:[A-Za-z]+ ){2 }\K[A-Za-z]+" - Unrecognized escape string \K. parse.

[@perfectvideomixing_pvm]

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

[@andersjensenorg]

I'm sorry, but yeah not the most basic video 😬