Thanks a ton, เทพเอ็กเซล : Thep Excel 🤩 Have a great day. You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Deine ausführliche Beschreibung der einzelnen Schritte ist genau das richtige. Es ist ein unglaublicher Schub an Informationen, die in einem perfekten Kontext sehr gut aufgearbeitet sind und die beste Basis bieten für das nächste Level.
Hey Djoma1609. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 6000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Great tutorial Anders, I specifically like that you clearly label all your Elements and Variables. Thank you for the time and effort that you put into your videos.
Hey Paul. Thanks a ton! I do my best to always create the videos like it was a real life case. And only simplify the case itself and not the techniques/best practices. I'm glad you enjoyed and took the time to comment 😊 Kind regards, Anders
I must say its a wonderful playlist across youtube on Power Automate desktop. the style is so elegent and simple that a non-coder can understand this complex topic in a layman language. many 2 thanks for your efforts Anders Jensen
Thanks a ton, Le Thanh 🤩 Have a great day. You're more than welcome at my Discord, where we're 5800+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Excellent video! I am an idiot and thought, I don't need add excel header I can just do that manually. Then spent the whole night wondering and tweaking random things because it was creating new excel file everytime it was going next page. After trying to fix my self for almost 4 hours I decided to rewatch the whole video start to finish again! Turns out it was solved in add excel header section! The only 5 mins I skipped in the video the first time! 😂😂😂 Anyway, you cleared a lot of concepts for me! Learned a lot. Thanks, man. Good job.
Thanks a lot, Rashan Shahrian 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
man, great content, please do more videos about more advanced stuff. Power Automate is a great tool and you are an amazing example that not every single hero needs to wear a cape! Thank you
Hey Grzegorz - thanks a lot for the comment - appreciated 😊 I will do more and advanced lessons during the next months. Have a great day. Kind regards, Anders
Thanks a lot, naresh 90 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Thanks a bunch, @silentlove62 🤩 I've created a Discord. We're more than 8000+ RPA developers networking and solving problems here: ua-cam.com/video/xWFz-S96XGo/v-deo.html You're more than welcome. Kind regards, Anders
Such a great explanation. You have the heart of a teacher. I would love to meet you and thank you personally for all the knowledge I gained with your content. Thank so much Anders.
OH MY Goodness...I was dreaming of something like this in my head the last couple of days for a project at work. I'm vaguely familiar using Power Automate and have created a few minor flows in the past BUT THIS is exactly what I was thinking. Thank you!!
Thanks a lot, Carlos 😍 I've created this entire Power Automate Desktop course, if you want to learn more: ua-cam.com/play/PLXXz88_TPiHpY_5bfeV8RAOHnBKgc-rtw.html Have a great day. Kind regards, Anders
Thanks a lot, @AM-oe7ix 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 8000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Hey @user-ie5qn3jz2h. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 8000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Thanks a bunch, @scottmuldowney1106 🤩 I've created a Discord. We're more than 8000+ RPA developers networking and solving problems here: ua-cam.com/video/xWFz-S96XGo/v-deo.html You're more than welcome. Kind regards, Anders
This is so helpful to my personal project, I can't thank you enough!! I did have to change some things but your video helped me understand the basics to modify as needed. :) So excited to run my automation!😁
Thanks a lot, @ZeNex74 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 11,000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Wow, what an awesome tutorial. Definitely worth subscribing to your channel (and liking the video of course). I played around with web scraping with various tools but this one is really a superb tutorial as there are no black boxes. You explain everything very clearly. I guess the one thing that no web scraper will overcome - especially when scraping BigTech websites like Amazon, LinkedIn, Ebay etc - is that the sites and their underlying structure change all the time. So it's not a one off automation that will run forever. It definitely needs to be maintained. But if you learn from a grandmaster like in this video, you know what you're doing which makes understanding your automations of course way easier.
Amazing tutorial. Very easy to learn and I will surely try this out. It will be easy to extract meaningful data from the web to excel sheet. Thank you!
Very useful example for me. Great teaching how you iterated through from a simple to complex solution. Your English was very easily understood Anders. Bonus learning about regex101. Thank you so much! *Subscribed*
Thank you so much for your tutorials! I’ve never used power automate before but your videos are so clear and precise that I am confident I can learn. Implementing this is going to make a huge difference. Thank you!
You're very welcome, Karuth Sanker - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 6000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html
Thank you for the detail explain for the web scraping in power automate with proper step by step instead of record option. once again thank you so much...................😀
Hey vikiboon, thanks a lot for the nice comment 😊🙌 Sorry for the late reply, did you continue your Power Automate Desktop journey? Kind regards, Anders
You're very welcome, @user-so9br3bg7b - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 8000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html
Hey Jonathan. I'm so glad to hear. If you want to take step 2, then check this video (a full use case): ua-cam.com/video/7R5EjshDoQU/v-deo.html Thanks for the nice message. Kind regards, Anders
Hey LaNa - Highly appreciated. Thanks a lot and have you seen this: ua-cam.com/video/qfpHqfp2R3Y/v-deo.html You can start from 34:07 🙂 Kind regards, Anders
You're very welcome, @maheshwarhaldar2534 - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 8000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html
Thanks a lot, Hyder Mohammed 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 5800+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
@@andersjensenorg it's a pleasure and well deserved. I had an issue, at 40:20 on the video. You mentioned that 'if it works, do nothing but if it doesn't work well need to fix it..' I've tried it on another ecommerce site that has a 'load more' button and it's not working. Can you give guidance on how to troubleshoot the 'click link on web page' failing (it's just this action that fails with an error like this: Microsoft.Flow.RPA.Desktop.Modules.SDK.ActionException: Element with selector 'div[Class="search-listings-module_load-more-container_2sgBB"] > button[Class="button ghost search-listings-module_load-more_OwyvW"][Type="submit"]' not found. ---> Microsoft.Flow.RPA.Desktop.Modules.WebAutomation.Actions.Exceptions.ElementNotFoundException: Exception of type 'Microsoft.Flow.RPA.Desktop.Modules.WebAutomation.Actions.Exceptions.ElementNotFoundException' was thrown. at Microsoft.Flow.RPA.Desktop.Modules.WebAutomation.Actions.WebAutomationResultExtensions.ThrowIfError(WebAutomationResult result, String cssSelector, String option) at Microsoft.Flow.RPA.Desktop.Modules.WebAutomation.Actions.ClickBase.Execute(ActionContext context) --- End of inner exception stack trace --- at Microsoft.Flow.RPA.Desktop.Modules.WebAutomation.Actions.ClickBase.Execute(ActionContext context) at Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.ActionRunner.Run(IActionStatement statement, Dictionary`2 inputArguments, Dictionary`2 outputArguments)?) Thanks a lot!
Thanks a bunch, @AtoconMoses 🤩 I've created a Discord. We're more than 11,000+ RPA developers networking and solving problems here: ua-cam.com/video/xWFz-S96XGo/v-deo.html You're more than welcome. Kind regards, Anders
You're very welcome, Saptarshi Chakraborty - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 5300+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html
Sir, you really explained this so easily as if it's nothing. However when someone tries to do the same without watching your video it seems to be a nightmare.
Thanks for the kudos, UnBoreMaster, and yes it can be hard when alone. My best advice is to copy every step in the video to learn the most. Have you seen my community? It's 100% free, and we're 13,000+ members who help each other: discord.gg/iloveautomation Kind regards, Anders
Hey Ashwin Kumar. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 6000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Thanks a ton, Aayma Vlogs 🤩 Have a great day. You're more than welcome at my Discord, where we're 5800+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
@@andersjensenorg I´m having trouble on running the steps, though. I follow the steps : 1.Launching a new Chrome instance. 2.Utilizing the "Extract data from a tab on the web page" tool. 3.Right-clicking on the auxiliary AI element. 4.Selecting "Extract element value." 5.Clicking on "Text" to extract the desired information. But on the preview TAB, there seems to be no information extracted from the web. What do you suggest me doing? Thank you very much in advanced!
Hey Mike. Thanks a ton for your support 😊 We're about to come to an end in the Power Automate for Desktop series, but then I'll started the advanced one. Kind regards, Anders
Thanks a bunch, @Cmart6444 🤩 I've created a Discord. We're more than 11,000+ RPA developers networking and solving problems here: ua-cam.com/video/xWFz-S96XGo/v-deo.html You're more than welcome. Kind regards, Anders
Thanks a ton, Dhananjai class 🤩 Have a great day. You're more than welcome at my Discord, where we're 6000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Thanks a lot, @wmferreira 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 11,000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Great content Anders! Very well explained and love the organisation. Exactly what I was looking for for this particular project. Keep up the stellar work! Is it possible to add time delays before scaping the next page?
Hey Shashikkant Lohar. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Thanks a bunch, @sergiohilario426 🤩 I've created a Discord. We're more than 11,000+ RPA developers networking and solving problems here: ua-cam.com/video/xWFz-S96XGo/v-deo.html You're more than welcome. Kind regards, Anders
Thanks a lot, @ALVINMAN452 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 9000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Thank you, Anders - this tutorial has been extremely helpful for a project I am working on involving collecting and comparing product reviews across multiple shopping websites. Wonderful presentation and I appreciate the time you take to explain everything! 🙌🙌
Hey @dzeeman121. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 8000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Hi Anders, Really your video is very helpful. Thanks a lot! I have 10K web URL in Excel from the same manufacturer/Third party. I need to extract data from web page in a single active sheet. I tried for a single web URL, it is working good. Thanks.
Hi Andres, i stucked at one point. Can you please hep me out?. 1. I have bunch of website URL in one Excel. 2.i need to extract data from all website URL. 3. saved in single Excel. Here one thing, i couldn't know how paste the URLs in "Google URL Address Bar". 😇#Get the Website URL from Excel #Paste into "Google URL Address Bar" and give "Enter"😇 #Extract Data from each website # Save into Singe Excel
@@andersjensenorg I sent an email with image and link, but it would look like this: Thanks for responding so quickly. On the website it appears 10 items per page and just below it appears as pages: page [1] [2] [3] [4] [5] [...] [957] where I can browse to list, but there is no option for [Previous] or [next]
Hi Anderson, Thank you for your detailed video about it. Instead of adding a new worksheet for each topic, how can we append data into Excel, let's suppose, I have a part number and scraped their prices from the website but instead of writing it into one Excel sheet it's creating a separate multiple Excel sheet(not a tab) for each of the numbers. So how can we write into one excel? Thanks!
2 роки тому+1
This is great. Thanks for the nice overview on how to use Power Automate! By the way, usually the character "|" is called "pipe".
Thank you Anders for all these valuable tutorials that are helping me so much to start with Power Automate. I have been following this tutorial until the end of web scraping but I got this error on line 14 (Add new worksheet): "Excel instance i un-initialized. Please doublecheck that the correct Excel instance has been specified and that it's used after a Launch Excel/Attach to running Excel action and not after the Excel instance has been closed". I checked everything but I cannot find what I am doing wrong since I followed all your steps. Could you help me with that? many thanks in advance.
Hey Carlos. Thanks a ton 😍 PAD can sometimes lock Excel. Check the last part of this video on how to solve it: ua-cam.com/video/4Py-V85bPfo/v-deo.html Kind regards, Anders
Hey Anders, thanks for you video! I have a quick question-if I store the web scraping result in a variable instead of in excel, can I execute sql query to insert the variable into a table in sql server? I already connected power automate to sql server and wanted to insert the web scraping result into a table but I failed.
Hey Jiachen Christian Xu 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 Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html Have a great day. Kind regards, Anders
First of all, that's a very detailed and excellent walk through. Its very much appreciated. I am trying to follow on your instructions but I found myself facing an error when attempting to get the data from the 3 pages using the "Next" button (40:25 in your video). It actually works on the first query but then fails as it loops and have a different search field. Could you please help with getting this issue resolved. 🙏
Hey Artfool. Thanks a lot 😊 Sure, do you use the next function in Power Automate for Desktop or do you use "my" method for finding the next button? If the first, please change it to my method. If it's my method, can you please post the problem with a screenshot at my Discord (link is in the description)? It's free and then we'll fix it. Kind regards, Anders
Hello Jensen, Do you have a video that show how to click on links in a list on a webpage depending on a condition? I need to click on a link if that link contains MSA if not then iterate through the rest.
Love the video! Followed it step by step to learn about Power Automate. Question though: during testing, I kept on getting the error on open Excel. I had to kill it in Task Manager since it was running in the backend. Any comment to use to close it?
Thanks for all your likes and support 🙌😍
I've updated the video: ua-cam.com/video/POfK2A8iWAs/v-deo.html
This tutorial is the best power automate web scraping tutorial i've found in internet!!
Thanks a ton, เทพเอ็กเซล : Thep Excel 🤩 Have a great day. You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Deine ausführliche Beschreibung der einzelnen Schritte ist genau das richtige. Es ist ein unglaublicher Schub an Informationen, die in einem perfekten Kontext sehr gut aufgearbeitet sind und die beste Basis bieten für das nächste Level.
Hey Djoma1609. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 6000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Great tutorial Anders, I specifically like that you clearly label all your Elements and Variables. Thank you for the time and effort that you put into your videos.
Hey Paul. Thanks a ton! I do my best to always create the videos like it was a real life case. And only simplify the case itself and not the techniques/best practices. I'm glad you enjoyed and took the time to comment 😊 Kind regards, Anders
Hi, Anders ! A real master class, with RegEx bonus. Thank you for sharing !!! Won my like.
Hey ORIC Channel. Thanks a lot 😊 Have a great day. Kind regards, Anders
I must say its a wonderful playlist across youtube on Power Automate desktop. the style is so elegent and simple that a non-coder can understand this complex topic in a layman language. many 2 thanks for your efforts Anders Jensen
You're very welcome, aslam waris - your support helps me a lot 😍
Nicely and clearly explained. Thanks a lot.
You're very welcome, Yunus Yilmaz - your support helps me a lot 😍
Amazing, this should be how we work. You've helped me save a lot of my time doing repetitive boring tasks. Now I'm an irreplacable employee of my team
Thanks a ton, Le Thanh 🤩 Have a great day. You're more than welcome at my Discord, where we're 5800+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Excellent video! I am an idiot and thought, I don't need add excel header I can just do that manually. Then spent the whole night wondering and tweaking random things because it was creating new excel file everytime it was going next page.
After trying to fix my self for almost 4 hours I decided to rewatch the whole video start to finish again! Turns out it was solved in add excel header section! The only 5 mins I skipped in the video the first time! 😂😂😂
Anyway, you cleared a lot of concepts for me! Learned a lot. Thanks, man. Good job.
Thanks a lot, Rashan Shahrian 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
man, great content, please do more videos about more advanced stuff. Power Automate is a great tool and you are an amazing example that not every single hero needs to wear a cape! Thank you
Hey Grzegorz - thanks a lot for the comment - appreciated 😊 I will do more and advanced lessons during the next months. Have a great day. Kind regards, Anders
Mr.Jensen, this is the best intro of PAD with best example. TYVM
Thanks a lot, naresh 90 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
This is something special I found on UA-cam to learn Wen scrapping using Power Automate for Desktop.
Thanks a bunch, @silentlove62 🤩 I've created a Discord. We're more than 8000+ RPA developers networking and solving problems here: ua-cam.com/video/xWFz-S96XGo/v-deo.html You're more than welcome. Kind regards, Anders
Words cannot describe that video. You're truly amazing.
Hey Charis. Thanks a lot 😃
Your teaching style is just awesome and so simple.
I'm so glad to hear, thanks a lot 😎🙌 Kind regards, Anders
Crazy Stuff What a crazy perfection You have When you are teaching. Just Awwsome The perfect Teacher with full of knowledge.
Thanks a ton, HITESH. I've created a new version: ua-cam.com/video/POfK2A8iWAs/v-deo.html Have a great day. Kind regards, Anders
Great explanation sir
Thanks a lot, Yogiraj 🙋♂️🙂
Such a great explanation. You have the heart of a teacher. I would love to meet you and thank you personally for all the knowledge I gained with your content. Thank so much Anders.
Wauw, what a nice message, Otoniel - it's highly appreciated :) Have a great day. Kind regards, Anders
Love your delivery! It's a blast to learn from you
Thanks a lot, Jim 😊
Quality of this tutorial is amazing. Great work
Thank you so much 🙌😊 Kind regards, Anders
OH MY Goodness...I was dreaming of something like this in my head the last couple of days for a project at work. I'm vaguely familiar using Power Automate and have created a few minor flows in the past BUT THIS is exactly what I was thinking. Thank you!!
Learned a new word today: web scraping
Haha, I'm so happy to hear - thank you so much 😎🤩
I've have always wanted to learn easily the web-scraping, with this video you really help me
Thanks a lot, Carlos 😍 I've created this entire Power Automate Desktop course, if you want to learn more: ua-cam.com/play/PLXXz88_TPiHpY_5bfeV8RAOHnBKgc-rtw.html Have a great day. Kind regards, Anders
Great and easy to follow hands on project for some who is new to power automate. Thanks for sharing your knowledge
Thanks a lot, @AM-oe7ix 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 8000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Absolutely useful video, Excellent work Anderson
Thanks a lot, ferozejacob 🤗 Your feedback helps me immensely. Kind regards, Anders
Outstanding tutorial. Clear, methodical, concise, organised.
Hey @user-ie5qn3jz2h. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 8000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
By far the best tutorial video I have every watched. Thank you very much
Thanks a bunch, @scottmuldowney1106 🤩 I've created a Discord. We're more than 8000+ RPA developers networking and solving problems here: ua-cam.com/video/xWFz-S96XGo/v-deo.html You're more than welcome. Kind regards, Anders
This is so helpful to my personal project, I can't thank you enough!! I did have to change some things but your video helped me understand the basics to modify as needed. :) So excited to run my automation!😁
Hey Amelia - I'm so glad to hear 😃 And yeah, when you get your head around the basics, the rest will follow somewhat easy 😊 Kind regards, Anders
Wow, wasnt looking for. Popped up in UA-cam then watched nearly all in lunch and now late back... very good video.. so now I had better try it
Thanks a lot, @ZeNex74 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 11,000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Please like this video, if you want more advanced RPA content - thanks for all your support 🙌🔥
Instagram: @andersjensenorg
Hi Anders, I want the input text to populate in output template. How to do it?? Please help
Thanks for the video... It is life saver... So much effort has gone into the making of this video
I'm so glad to hear, thanks a lot 😊👍 Kind regards, Anders
Wow, what an awesome tutorial. Definitely worth subscribing to your channel (and liking the video of course). I played around with web scraping with various tools but this one is really a superb tutorial as there are no black boxes. You explain everything very clearly.
I guess the one thing that no web scraper will overcome - especially when scraping BigTech websites like Amazon, LinkedIn, Ebay etc - is that the sites and their underlying structure change all the time. So it's not a one off automation that will run forever. It definitely needs to be maintained.
But if you learn from a grandmaster like in this video, you know what you're doing which makes understanding your automations of course way easier.
Wow, thanks a lot for the very nice words, Phillipp 🤩🙌 Kind regards, Anders
Very Good! Subscribed to your automation journey.
Hey Manuel, thanks a lot 😊
Thank you for going above and beyond!
Thanks a ton, Ricardo Garcia 🤩 Have a great day. Kind regards, Anders
Amazing tutorial. Very easy to learn and I will surely try this out. It will be easy to extract meaningful data from the web to excel sheet. Thank you!
Thanks a lot, Kopil Kaiser 🤗 Your feedback helps me immensely. Kind regards, Anders
Great step by step, Anders!
Many thanks 🙌 Kind regards, Anders
Set drop down list value on web page... This nugget is awesome !!!!
I agree 😀🙏 Did you build anything cool? Kind regards, Anders
Very useful example for me. Great teaching how you iterated through from a simple to complex solution. Your English was very easily understood Anders. Bonus learning about regex101. Thank you so much! *Subscribed*
Hey intentionally blank, thank you so much - I'll updating the PAD content in September. Kind regards, Anders
Thank you so much for your tutorials! I’ve never used power automate before but your videos are so clear and precise that I am confident I can learn. Implementing this is going to make a huge difference. Thank you!
Hey Faith Ritter. Thanks a lot 😊 Have a great day. Kind regards, Anders
This is one of the best video in training series
You're very welcome, Karuth Sanker - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 6000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html
Thank you for the detail explain for the web scraping in power automate with proper step by step instead of record option. once again thank you so much...................😀
Hey vikiboon, thanks a lot for the nice comment 😊🙌 Sorry for the late reply, did you continue your Power Automate Desktop journey? Kind regards, Anders
Thank you. Great work. That striaght vertical "|" symbol name, I call it "pipe"👏
Thanks a ton, Miguel Medina 🤩 Have a great day. Kind regards, Anders
It's a wonderful and useful video! Please keep on going with other advanced tutorial
Hey Ale. Thanks a lot 😊 Have a great day. Kind regards, Anders
Was about to start learning web scraping with python, but this seems like a nicer introduction into the field. Great video, tnx :)
You're very welcome, @user-so9br3bg7b - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 8000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html
This does what I need it to, thank you for your tutorials.
Hey Jonathan. I'm so glad to hear. If you want to take step 2, then check this video (a full use case): ua-cam.com/video/7R5EjshDoQU/v-deo.html Thanks for the nice message. Kind regards, Anders
Quality is top class and thank you very much for the wonderful content
Hey LaNa - Highly appreciated. Thanks a lot and have you seen this: ua-cam.com/video/qfpHqfp2R3Y/v-deo.html You can start from 34:07 🙂 Kind regards, Anders
Thank you Anders for all your effort in putting this together. This tutorial was extremely helpful and to the point. Thanks a million :)
You're very welcome, @maheshwarhaldar2534 - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 8000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html
The way you guide is very good
Many thanks 😊🙌 Kind regards, Anders
This is an excellent tutorial! Thank you very much for putting it together!
Thanks a lot, Hyder Mohammed 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 5800+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Hi Anders, absolutely brilliant! This is magic and extremely powerful. Thank you for making this video and sharing your knowledge👍👍👍
Thanks a ton, Daniel Rumbak 🤩 Have a great day. Kind regards, Anders
@@andersjensenorg it's a pleasure and well deserved. I had an issue, at 40:20 on the video. You mentioned that 'if it works, do nothing but if it doesn't work well need to fix it..' I've tried it on another ecommerce site that has a 'load more' button and it's not working. Can you give guidance on how to troubleshoot the 'click link on web page' failing (it's just this action that fails with an error like this:
Microsoft.Flow.RPA.Desktop.Modules.SDK.ActionException: Element with selector 'div[Class="search-listings-module_load-more-container_2sgBB"] > button[Class="button ghost search-listings-module_load-more_OwyvW"][Type="submit"]' not found. ---> Microsoft.Flow.RPA.Desktop.Modules.WebAutomation.Actions.Exceptions.ElementNotFoundException: Exception of type 'Microsoft.Flow.RPA.Desktop.Modules.WebAutomation.Actions.Exceptions.ElementNotFoundException' was thrown.
at Microsoft.Flow.RPA.Desktop.Modules.WebAutomation.Actions.WebAutomationResultExtensions.ThrowIfError(WebAutomationResult result, String cssSelector, String option)
at Microsoft.Flow.RPA.Desktop.Modules.WebAutomation.Actions.ClickBase.Execute(ActionContext context)
--- End of inner exception stack trace ---
at Microsoft.Flow.RPA.Desktop.Modules.WebAutomation.Actions.ClickBase.Execute(ActionContext context)
at Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.ActionRunner.Run(IActionStatement statement, Dictionary`2 inputArguments, Dictionary`2 outputArguments)?)
Thanks a lot!
Thank you Anders!
I was hardly searching for a solution, since the IE integration in Excel-Makro dont work anymore!
Again, thank you.
I'm so glad to hear, thank you 😊 Kind regards, Anders
Extraordinary lessons Jensen!
Thanks a bunch, @AtoconMoses 🤩 I've created a Discord. We're more than 11,000+ RPA developers networking and solving problems here: ua-cam.com/video/xWFz-S96XGo/v-deo.html You're more than welcome. Kind regards, Anders
very detailed explanation, thank you sir.
Great tutorial. Very detailed.
Excellent Work, Thank You very much.
My plasure, Mohammed 🙌
Thanks Anders for the systematic approach. Couldn't ask for more.
You're very welcome, Saptarshi Chakraborty - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 5300+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html
This train is well described and presented. Thank you.
I appreciate your kind words, thank you! Anders ❤️
Thanks so much Anders for this helpful content. 👍👍
Thank you so much, Iwan, for the nice words 😊
Sir, you really explained this so easily as if it's nothing. However when someone tries to do the same without watching your video it seems to be a nightmare.
Thanks for the kudos, UnBoreMaster, and yes it can be hard when alone. My best advice is to copy every step in the video to learn the most. Have you seen my community? It's 100% free, and we're 13,000+ members who help each other: discord.gg/iloveautomation Kind regards, Anders
Fantastic tutorial buddy :) keep it going :)
Hey Ashwin Kumar. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 6000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Thank you anders, this video is very helpful for me.
Thanks a ton, Aayma Vlogs 🤩 Have a great day. You're more than welcome at my Discord, where we're 5800+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Excellent tutorial, thank you very much for this, i really appreciate your efforts.
Hey PL Sistemas. Thanks a lot 😊 Have a great day. Kind regards, Anders
This is such a good video tutorial for Desktop Power Automate. Brilliantly explained with a great use-case. Thank you so much 🙏
Hey Rod - thanks a lot 🙌😊
Great video, thank you for sharing your knowledge
Thanks a ton, appreciate all the support 😎🙏
Great video Anders!
Thanks a lot, Steve 😊
Awesome video! Good explanation and it definitely helped.
Hey Sotgar - I'm so happy to hear 😍
Oooh yeah baby I love it 🔥🔥
Hey S - thanks a lot 😍
Very helpful for beginners.
simply extraordinary.... Thank you
Thanks a ton, Zaki 😊
This lessons are F¨¨ïng Amazing, love them!!! Thank you soooooo MUCH! =)
Thanks a lot, Guido 😍 I've created an updated version here: ua-cam.com/video/POfK2A8iWAs/v-deo.html Kind regards, Anders
@@andersjensenorg I´m having trouble on running the steps, though.
I follow the steps :
1.Launching a new Chrome instance.
2.Utilizing the "Extract data from a tab on the web page" tool.
3.Right-clicking on the auxiliary AI element.
4.Selecting "Extract element value."
5.Clicking on "Text" to extract the desired information.
But on the preview TAB, there seems to be no information extracted from the web.
What do you suggest me doing?
Thank you very much in advanced!
This is amazing stuff!!!
Thanks a ton, Mayo! 🙌
Than you . Your videos are very helpful .
I'm so glad to hear, thanks a lot 😊 Kind regards, Anders
simply brilliant, exactly what I was looking for. very well explained.
Hey Mustafa - thanks a ton 😍🤩 Have a great day. Kind regards, Anders
Thanks for the video, this was fun :D
It's my pleasure. Did you already complete it? 😀
thank you for a great tutorial!
You're very welcome, SpinetSam - your support helps me a lot 😍
Thank you for this tutorial. Really detailed and excellent, i hope i can learn this myself now!
Glad it was helpful! Kind regards, Anders
Great video. Thanks again for your wonderful explanation. 😊
Hey Mike. Thanks a ton for your support 😊 We're about to come to an end in the Power Automate for Desktop series, but then I'll started the advanced one. Kind regards, Anders
That was great. Thank you.
Thanks a ton, Shivam Yadav 🤩 Have a great day. Kind regards, Anders
Great tutorial! Appreciate it!
Hey Joseph, thanks a lot - highly appreciated 🙌
This is just great Anders!!!!!
Thanks a bunch, @Cmart6444 🤩 I've created a Discord. We're more than 11,000+ RPA developers networking and solving problems here: ua-cam.com/video/xWFz-S96XGo/v-deo.html You're more than welcome. Kind regards, Anders
wonderful lesson ，hope you teach me more.
Thanks a lot, Zoeyu - the next months will be all about UiPath and then I come back to Power Automate videos 😊 Have a great day. Kind regards, Anders
Great explaination. Subscribed to channel.Thanks 🙏🙏
Thanks a ton, Dhananjai class 🤩 Have a great day. You're more than welcome at my Discord, where we're 6000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Tillykke. Fremragende forklaring.
Hilsen fra Brasilien.
Haha, mange tak 😃
Amazing video, I glad to learn.
Hey Sreekanth, thanks a ton for the nice comment 🙌💥
Tks for your videos! I’m learning a lot with you 👏👏👏
Thanks a lot, @wmferreira 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 11,000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Great content Anders! Very well explained and love the organisation. Exactly what I was looking for for this particular project. Keep up the stellar work! Is it possible to add time delays before scaping the next page?
I believe you would just use the "Wait" action in your "for each" loop
Thanks a lot, Brian - and yes, as Amelia says, you can use e.g. the Wait action (thanks, Amelia). Kind regards, Anders
The quality is amazing...
Hey Shashikkant Lohar. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
thank you so much for this tutorial it will help me on my job
Thanks a bunch, @sergiohilario426 🤩 I've created a Discord. We're more than 11,000+ RPA developers networking and solving problems here: ua-cam.com/video/xWFz-S96XGo/v-deo.html You're more than welcome. Kind regards, Anders
Many thanks for this nice and helpful video.
Thanks a lot, @ALVINMAN452 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 9000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Thank you, Anders - this tutorial has been extremely helpful for a project I am working on involving collecting and comparing product reviews across multiple shopping websites. Wonderful presentation and I appreciate the time you take to explain everything! 🙌🙌
Hey Micah - I'm so glad to hear. Thanks a lot for commenting 😊 Kind regards, Anders
Excellent tutorial
Hey @dzeeman121. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 8000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Hi,
i need the result in single worksheet by below and below, not in separate sheets.
Can you please provide me the solution?
Hey Vijay. I did in the video as well? Added to the same sheet for each topic. 3 pages. Kind regards, Anders
Hi Anders,
Really your video is very helpful. Thanks a lot!
I have 10K web URL in Excel from the same manufacturer/Third party. I need to extract data from web page in a single active sheet.
I tried for a single web URL, it is working good. Thanks.
Hi Andres,
i stucked at one point. Can you please hep me out?.
1. I have bunch of website URL in one Excel.
2.i need to extract data from all website URL.
3. saved in single Excel.
Here one thing, i couldn't know how paste the URLs in "Google URL Address Bar".
😇#Get the Website URL from Excel
#Paste into "Google URL Address Bar" and give "Enter"😇
#Extract Data from each website
# Save into Singe Excel
Very good your tutorial, congratulations! Can you show me how I can do when not on a next button, nor does page 1, page 2 appear?
Sure 🙂 How can a human navigate to the next page then? We just copy that. Please provide a sample page. Kind regards Anders Ps thanks a ton 👍😍
@@andersjensenorg I sent an email with image and link, but it would look like this:
Thanks for responding so quickly. On the website it appears 10 items per page and just below it appears as pages:
page [1] [2] [3] [4] [5] [...] [957] where I can browse to list, but there is no option for [Previous] or [next]
Great session, thanks
My pleasure, kind regards, Anders
Hi Anderson,
Thank you for your detailed video about it.
Instead of adding a new worksheet for each topic, how can we append data into Excel,
let's suppose, I have a part number and scraped their prices from the website but instead of writing it into one Excel sheet it's creating a separate multiple Excel sheet(not a tab) for each of the numbers.
So how can we write into one excel?
Thanks!
This is great. Thanks for the nice overview on how to use Power Automate!
By the way, usually the character "|" is called "pipe".
Hey Vincius. Thanks for the nice words. More PAD videos will follow 😊
And thanks!! I will always call it pipe from now 😄
Thank you Anders for all these valuable tutorials that are helping me so much to start with Power Automate. I have been following this tutorial until the end of web scraping but I got this error on line 14 (Add new worksheet): "Excel instance i un-initialized. Please doublecheck that the correct Excel instance has been specified and that it's used after a Launch Excel/Attach to running Excel action and not after the Excel instance has been closed". I checked everything but I cannot find what I am doing wrong since I followed all your steps. Could you help me with that? many thanks in advance.
Hey Carlos. Thanks a ton 😍 PAD can sometimes lock Excel. Check the last part of this video on how to solve it: ua-cam.com/video/4Py-V85bPfo/v-deo.html Kind regards, Anders
Hey Anders, thanks for you video! I have a quick question-if I store the web scraping result in a variable instead of in excel, can I execute sql query to insert the variable into a table in sql server? I already connected power automate to sql server and wanted to insert the web scraping result into a table but I failed.
Hey Jiachen Christian Xu 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 Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html Have a great day. Kind regards, Anders
Thank you sir! Really appreciate it!
Show de bola, sempre com excelentes conteudos! Parabéns! :D
Muito obrigado meu amigo. Muito apreciado. Tenha um bom dia. Atenciosamente, Anders
First of all, that's a very detailed and excellent walk through. Its very much appreciated. I am trying to follow on your instructions but I found myself facing an error when attempting to get the data from the 3 pages using the "Next" button (40:25 in your video). It actually works on the first query but then fails as it loops and have a different search field. Could you please help with getting this issue resolved. 🙏
Hey Artfool. Thanks a lot 😊 Sure, do you use the next function in Power Automate for Desktop or do you use "my" method for finding the next button? If the first, please change it to my method. If it's my method, can you please post the problem with a screenshot at my Discord (link is in the description)? It's free and then we'll fix it. Kind regards, Anders
Hello Jensen, Do you have a video that show how to click on links in a list on a webpage depending on a condition? I need to click on a link if that link contains MSA if not then iterate through the rest.
Love the video! Followed it step by step to learn about Power Automate. Question though: during testing, I kept on getting the error on open Excel. I had to kill it in Task Manager since it was running in the backend. Any comment to use to close it?
Sorry, I meant to post this under web scraping to Excel video.
Thanks a lot. Yeah that's a common bug. Open PowerShell as an admin and type: taskkill /f /im excel.exe and press enter Kind regards, Anders