Thanks for your support 🙌🔥 You can help me by giving this video a thumbs up....or down 👍👎 Let me know what you think of the teaching. Kind regards, Anders
Thanks a lot, Alvaro San Martin 🤗 Your feedback helps me immensely. 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 Kind regards, Anders
Thank you for these tutorial series Anders. Currently on a week long work time-off and using this available time to learn Power Automate from your videos. I'm an aspiring Data Analyst and now studying to source & manage data from Web to Excel. I really appreciate your effort. 👍
Hey Jonah - sorry for the very LATE reply 😐 Thanks a lot for the very nice comment, I'm so glad to play a (little) role in your automation journey 😊 Kind regards, Anders
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 13,000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
I have just come accross these tutorials as I believe that power Automate Desktop can help me with my work. Thank you, Anders. I am trying to search a list of websites to see if a particular word exists somewhere on the site and return a yes or a no. I can get PAD to see if the word exists by using the action 'If web page contains' , but this only works on a particular page URL that I set. I can't see a way to search the whole site. Is this possible? Can you make a demonstration of this please? Thank you.
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 12,000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
wonderfully explained.. thank you.. I am trying to do similar write to excel activities , but the data is not getting written in the excel, any thoughts please?
Thanks a lot 😊 Did you remember to open the close Excel and choose 'Save'? Also check my video from today about save web data to Excel: ua-cam.com/video/FH_7D402lP8/v-deo.html Kins regards, Anders
@@andersjensenorg thank you for the speedy response... did save the excel, but the scraped contents were not getting written, also sometimes, in the place of the entire hyperlink of the webpage, it was writing only 'h', looks like the 'h' from https was only getting written. I am trying to scrape linked in and get the information like title, number of followers, webpage, and the number of followers for a given name which is my input. can you suggest some tips / steps as there are 2 types of pages, one with the name as it is and another when there are many people with the same name. my Robot was working fine and getting the data in the internal data table , but is not showing that today and has got corrupt after I tried some steps, any guidance in this regard will greatly help. thank you.
thank you for the speedy response... did save the excel, but the scraped contents were not getting written, also sometimes, in the place of the entire hyperlink of the webpage, it was writing only 'h', looks like the 'h' from https was only getting written. I am trying to scrape linked in and get the information like title, number of followers, webpage, and the About for a given name which is my input. can you suggest some tips or any video's that are similar.. I am doing this for the first time and your video helped a lot. :)
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 12,000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Is it possible to get data from a website that states that it doesn't store the data, rather makes computations when you click next page or page number from the website? There are also many many many pages of data. trillions. could that be put into a file that can be sorted?
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 11,000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Make sure to go into task manager and ensure that all of the Excel processes have been stopped. If the flow errors after opening Excel it will not be closed.
I kind of like your courses, the material you have is great, however with power automate desktop continually updating, half the stuff doesn't work. On your teaching, your voice is both pleasant and irritating, I understand that English is your second language and you are trying to emphasize certain words, to me it comes across as very irritating, I think you need a more natural flow of words and that will come with practice. I think you do a great job otherwise.
THanks for the feedback 😊 I would like to improve my English, but in this fast-paced niche (automation/AI), I don't have the time to, but I hope you'll still follow. Have a great week. Kind regards, Anders
Thanks a bunch, @yuvrajjadhav1506 🤩 I've created a Discord. We're more than 10,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 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 10,000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Could you do a tutorial of how to name a file in Excel, dynamically after running a loop for webscraping through different websites? Im not able to tell how to name the file while saving it with the value of the cell in Column 2 of the file where I get the links from.
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 10,000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Great video, Anders! I learned a a lot and everything works as in your video. However I think I found a bug? If you try to run the Jasonprocess-part with 50 CVRnumbers, the flow will fail with the StatusCode 200 and WebServiceResponse "{"error":"QUOTA_EXCEEDED","message":"Your quota has been exceeded...}". How come? and is there any way to fix it?
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 10,000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
I follow your step to "Extract Data from Webpage". However, the data can't be extracted into DatafromWebpage. At your video 47:35 or ua-cam.com/video/7R5EjshDoQU/v-deo.html. I'm using Chrome. So the data can't be written to excel. how to fix it?
I fixed it finally. It's because the webpage need time to get the data from the website. I set a wait 10s process before the "Extract Data from Webpage" process, then it works. Of course, as instructed by Anders, there should have some webpage variable to show that the data is refreshed. But I don't know what it is. Can Anders or others to give me hints !
Web data from multiple webpages store in different Excel files everytime create new file automatically Like Book 1,Book 2, Book 3......😓 I want multiple web data extracted in single Excel file Please solve this problem?
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 10,000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
First Thank you for the awesome tutorials. Please help me to solve a error am getting in flow desktop In my flow i want to click on a text which link is activated by java script and i don't understand how to click on this link because click link on the web page is not working on that text. please help me!!
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 9000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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 10,000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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 9000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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 9000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Wonderful course. One area that is puzzling me in regard to the CSS selection process in Power Automate Desktop, is the use of the greater than sign. In purse CSS, that means child element, not next element. So when we have div:contains("something") > div... I'm expecting to process through child elements of the first. Not the next element. Other than that, its all good.
You're very welcome, @chandanmaity - your support helps me a lot 😍 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
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 9000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
You are amazing.I wish to start my career as Power Automate developer.please upload full content of power automate and I have questions .is it power automate only enough for to get job opportunities
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 8000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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 8000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Hey @Mallone089. 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 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 8000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Hi. So I followed all the steps given and before the "postal code split" did the run of the process and received an error saying Failed to save document. HAs there been some xls protection changes that actually cause the file not to be savable automatically?
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 8000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Hello Jensen, Does power automate have feasibility to extract the date from web with selected date, week, year , if so can you share any example please... Thanks
You're an extraordinary teacher Anders. I came into these tutorials knowing nothing and now, at least, have the slightest understanding of what can be done. I'm not a developer and have no desire to become one--I just need this to help me harvest a bunch of data and have created a couple of flows that collected what I need. Thank you!
Wow, Robert. What a nice comment, thanks a lot 🥳 Have you seen my Power Automate Desktop beginners guide: ua-cam.com/video/qfpHqfp2R3Y/v-deo.html Some things will be repeaten, but I think it's a nice framework to get started. Have a great day (and please let all the great, and not so great, feedback follow). Kind regards, Anders
@@andersjensenorg Yes I've seen that and have probably spent 20 - 30 hours watching and re-watching various videos you've posted. I'm about to look at your PDF extraction videos because I have a serious problem I'm working on: creating individual indexes for nearly 300 pdf newsletters (each about 25 pages long) and then creating a master index. So thank you again.
You're very welcome, Dave G - 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
@@andersjensenorg Quick question for you Anders. I watched your excellent video on AI Builder. I want to try it, but I don't see it on my PA desktop app. Any idea why that might be?
How about a PAD lesson that teaches how to interact with ERP systems…Batch processing, loops, error handling & reporting,triggered w/ mobile Device or desktop shortcut
You're very welcome, Tuấn Nguyễn Đình - 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
Would you have any ideas or tutorials on how to scrape the thumbnail item images on eBay or Amazon? Along with the typical fields (title, price, etc.) I'd really like to find a way to also grab the product image as part of each item scrapped.
Thanks a lot, Neela Roy 🤗 Your feedback helps me immensely. 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
I am facing issues locating the json property, since there is a NULL value in one of the fields. any suggestions on how to resolve? the process stops as soon as the row that has this field as NULL is hit
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 6000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
This video made you my hero !! I have no words to thanks you for making things soo sooo easy for me. This was my first video from your channel and guess what !! from now I am not going to miss any of your future or past videos. Thank Thank you so much for making my day. Love from India ❣ And will do a hamble request please please never stop making such tutorials🤭
Thank you so much for your kind words! Your comment made me feel like a superhero, even though I don't have a cape (yet). 😂 I'm glad that my video was helpful and that you enjoyed it. It's wonderful to have you as a subscriber and I promise to keep creating tutorials that make your day! Sending lots of love back to India ❤️🇮🇳
Thanks a lot, Joshua M 🤗 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
Hey Yogiraj Sutar. Thanks a lot 😊 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
Thank you very much for your extraordinary effort in helping the power automate community. please, if you can take a example for " Use paging " in "Extract data from web page".
Thanks a lot, HASAN - I'm so happy about your comments here and there 😊 Regarding your problem: Check this video at 37:34 - ua-cam.com/video/WXK0u2yXLrU/v-deo.html Kind regards, Anders
Great video. I do find the contains function to be very useful when an element contains text. To click on the language buttons you could try button:contains('English'). That would reduce the logic needed to get the correct element!
I prefer watching your videos over Netflix 😅, am a fan here based in Singapore… Love the way you explain how each Action works and what it does!💯💯 Btw, I was able to do an introductory demo of Power Automate to our QA team by just simply watching thru your video tutorials, isn’t that cool!! 😎😎😎 I hope you ca n show more tips and tricks about the built-in selectors and regular expressions..😊Thank you and more power!
Hey Geraldine. Wow, thanks a lot for the nice words. It's not cool, it's mega cool - great job. Regarding your request, I got a RegEx video in the pipeline. I'll do selectors as well. Any particular case, you want to see? Kind regards, Anders
Hi Anders, Thanks a lot for the video. BTW, you mentioned about the "CSS selector series" that you are going to prepare. Can you please update the link in here if it already created or please let us know when you will be updating the series....Thanks again!
Hi Anders thank you for the great video. I have a similar use case. But there are couple of more pages in the same url with data to be extracted? how can i extend this use case to extract the information from multiple page. thanks
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Great Videos Anders. I'm wondering if there's a way to write to a worksheet that's protected in excel? I can't find an unprotect action in Power Automate.
Hey Derek Lauder 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
You mentioned in your video there was a file for what to do if you Excel file locks up. I didn't see anything in the upper right corner. Will you please post it here?
Hi Anders, great video, thanks for sharing. I have a use which you may show in your next videos. I got an email with a HTML table inside in email body. I need to transfer this with PAD in excel. Kind regards Nguyen
Hey Nuin Huin 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
Note: I had to add a "wait 6 seconds" for my page to load - the run didn't have time to scrape the page before continuing to the next step. It caused my results table to be blank.
Hey Emily. Yeah, you could/should do a check for the page you want to scrape, when you observe problems. You can use the same approach, as I do at around 21:52, where I check for English. Just change the English to e.g. an element of the table, e.g. CVR. I hope this helps. Kind regards, Anders
Hey Kellsea, yes for sure - have you seen the SharePoint actions (scroll all the way to the end of the actions). They're still in preview though. Kind regards, Anders
Hi Anders, my PAD failes call the Power Automate Extension on Edge. Microsoft cannot provide a solution so far. Do you have any ideas about this issue?
Hey Raymond. Unfortunately not, as I'm sure you've already tried re-installing etc. 😑 Have you seen my Discord? You're more than welcome to post the problem there. Here's how to join (it's of course free): ua-cam.com/video/xWFz-S96XGo/v-deo.html
I made a loop for the BOT to enter a link to extract the data, come back to enter another link to extract another data, but instead of it incrementing the lines both in the table and in Excel, it opens several files and saves one in each file, like me can I do to put each extracted file one under the other?
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 4900+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
just to make sure about power apps I can create apps but for other people to use they pay per user/month ? thats a bit expensive for company has 100 employees can create the web app once but will take longer to develop of course but on the long run will be cheaper
Hey virtumind 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
Hi Andres Can u please help me on how to combine two datatables which contains more than 1000 rows I'm trying a lot in loop it's taking more time can u please 😔 help me
Hey Only Ips 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
Thanks for your support 🙌🔥
You can help me by giving this video a thumbs up....or down 👍👎 Let me know what you think of the teaching. Kind regards, Anders
man, you are the hero for whom nobody asks, but everybody needs. thank you a lot, great job!
Hey Grzegorz, thanks a lot for the nice words/support 😊 If you have ideas for things to see in the future, please let me know. Kind regards, Anders
HUGH FACT BRO!
Best content available in UA-cam for PowerAutomate, thanks a lot Anders!
Thanks a lot, Alvaro San Martin 🤗 Your feedback helps me immensely. 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 Kind regards, Anders
@@andersjensenorg I joined the Discord yesterday and got very helpful answers to my douts, thanks a lot for all your work, it is outstanding!
Thank you for these tutorial series Anders.
Currently on a week long work time-off and using this available time to learn Power Automate from your videos.
I'm an aspiring Data Analyst and now studying to source & manage data from Web to Excel.
I really appreciate your effort. 👍
Hey Jonah - sorry for the very LATE reply 😐 Thanks a lot for the very nice comment, I'm so glad to play a (little) role in your automation journey 😊 Kind regards, Anders
Very good video. Explained in very simple ways. Thanks. If you can make similar video for scraping from eBay, it will be very helpful for many.
Thanks a lot, Rahul, I've placed it on my to-do, but I don't plan to to it in 2024 😞 Kind regards, Anders
This vidéo is a gem. Just love it, thanks a lot.
My biggest pleasure, thank you 😊 Kind regards, Anders
Hi Anders i am facing this issue, my tool run only once. your .xlsx is open in other application please close it.
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 13,000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
@@andersjensenorg thanks
its actually nice you reply to everyone, you take the time to do it, when someone has a problem, i know your trying your best to reply to everyone
Thank you so much, and sorry for the late reply here 😔😊 Kind regards, Anders
I have just come accross these tutorials as I believe that power Automate Desktop can help me with my work. Thank you, Anders.
I am trying to search a list of websites to see if a particular word exists somewhere on the site and return a yes or a no. I can get PAD to see if the word exists by using the action 'If web page contains' , but this only works on a particular page URL that I set. I can't see a way to search the whole site. Is this possible? Can you make a demonstration of this please? Thank you.
I cannot extract the data from webpage. I am using the same method that is in the video but for me the values are coming as BLANK for each CVR
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 12,000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
wonderfully explained.. thank you.. I am trying to do similar write to excel activities , but the data is not getting written in the excel, any thoughts please?
Thanks a lot 😊 Did you remember to open the close Excel and choose 'Save'? Also check my video from today about save web data to Excel: ua-cam.com/video/FH_7D402lP8/v-deo.html Kins regards, Anders
@@andersjensenorg thank you for the speedy response... did save the excel, but the scraped contents were not getting written, also sometimes, in the place of the entire hyperlink of the webpage, it was writing only 'h', looks like the 'h' from https was only getting written. I am trying to scrape linked in and get the information like title, number of followers, webpage, and the number of followers for a given name which is my input. can you suggest some tips / steps as there are 2 types of pages, one with the name as it is and another when there are many people with the same name. my Robot was working fine and getting the data in the internal data table , but is not showing that today and has got corrupt after I tried some steps, any guidance in this regard will greatly help. thank you.
thank you for the speedy response... did save the excel, but the scraped contents were not getting written, also sometimes, in the place of the entire hyperlink of the webpage, it was writing only 'h', looks like the 'h' from https was only getting written. I am trying to scrape linked in and get the information like title, number of followers, webpage, and the About for a given name which is my input. can you suggest some tips or any video's that are similar.. I am doing this for the first time and your video helped a lot. :)
Thank you. So helpful. Could we have access to this Power Automate project file? Dropbox, GDrive, etc?
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 12,000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Is it possible to get data from a website that states that it doesn't store the data, rather makes computations when you click next page or page number from the website? There are also many many many pages of data. trillions. could that be put into a file that can be sorted?
sorted to only scrape data if a certain valule is not zero
Hey Lee, thanks a lot for coming back with the solution 😊 Kind regards, Anders
my excel dont open then copy & paste information. HELP :(
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 11,000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Make sure to go into task manager and ensure that all of the Excel processes have been stopped. If the flow errors after opening Excel it will not be closed.
Awesome...
Thank you 😊
this helps sooooo much, thanks
I'm so glad to hear, thanks 😍 Kind regards, Anders
I kind of like your courses, the material you have is great, however with power automate desktop continually updating, half the stuff doesn't work. On your teaching, your voice is both pleasant and irritating, I understand that English is your second language and you are trying to emphasize certain words, to me it comes across as very irritating, I think you need a more natural flow of words and that will come with practice. I think you do a great job otherwise.
THanks for the feedback 😊 I would like to improve my English, but in this fast-paced niche (automation/AI), I don't have the time to, but I hope you'll still follow. Have a great week. Kind regards, Anders
You are great bro
Thanks a bunch, @yuvrajjadhav1506 🤩 I've created a Discord. We're more than 10,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
Hi Anders I am getting error I process write to excel worksheet
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 10,000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
It's good to know "contains" function in the selector. Thank you.
Thanks a lot 😊
Could you do a tutorial of how to name a file in Excel, dynamically after running a loop for webscraping through different websites?
Im not able to tell how to name the file while saving it with the value of the cell in Column 2 of the file where I get the links from.
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 10,000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
An excellent video once more time. Many thanks again.
Thanks a bunch for the nice words, kind regards, Anders 😊
Great video, Anders! I learned a a lot and everything works as in your video. However I think I found a bug? If you try to run the Jasonprocess-part with 50 CVRnumbers, the flow will fail with the StatusCode 200 and WebServiceResponse "{"error":"QUOTA_EXCEEDED","message":"Your quota has been exceeded...}". How come? and is there any way to fix it?
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 10,000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
I follow your step to "Extract Data from Webpage". However, the data can't be extracted into DatafromWebpage. At your video 47:35 or ua-cam.com/video/7R5EjshDoQU/v-deo.html. I'm using Chrome. So the data can't be written to excel. how to fix it?
I fixed it finally. It's because the webpage need time to get the data from the website. I set a wait 10s process before the "Extract Data from Webpage" process, then it works. Of course, as instructed by Anders, there should have some webpage variable to show that the data is refreshed. But I don't know what it is. Can Anders or others to give me hints !
Thanks a lot for the message back 🙌🙂
Web data from multiple webpages store in different Excel files everytime create new file automatically
Like Book 1,Book 2, Book 3......😓
I want multiple web data extracted in single Excel file
Please solve this problem?
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 10,000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
First Thank you for the awesome tutorials.
Please help me to solve a error am getting in flow desktop
In my flow i want to click on a text which link is activated by java script and i don't understand how to click on this link because click link on the web page is not working on that text.
please help me!!
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 9000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
any chance you can help me extract data from pdf document to excel to import to crm for marketing campaign, please?
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 10,000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Amazing video just had one question how can you extract data from a body or subject of an email with desktop p.automate
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 9000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
When Quota is Exceeded on JsonAsCustomObject, what do we do?
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 9000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Wonderful course. One area that is puzzling me in regard to the CSS selection process in Power Automate Desktop, is the use of the greater than sign. In purse CSS, that means child element, not next element. So when we have div:contains("something") > div... I'm expecting to process through child elements of the first. Not the next element. Other than that, its all good.
Thank you so much. The Child Combinator selector indeed uses the > for the child elements 🙂
Thanks for all your effort
You're very welcome, @chandanmaity - your support helps me a lot 😍 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
Great lesson Mr Jen
Many thanks, Mr thp 😊
great content sir, but I am not able to open up the website for scrapping
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 9000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
You are amazing.I wish to start my career as Power Automate developer.please upload full content of power automate and I have questions .is it power automate only enough for to get job opportunities
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 8000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Amazing amazing video. U r an angel
My pleasure, thank you so much tapasruparelia 🙌😎
Can it download files like if there is text and address and a pdf file download link can it download the files along with title and address
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 8000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Thank you Andres for this step by step Guide. Especially the Selector modification helped me a lot.
Hey @Mallone089. 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
@anderjenson Hi I have tried the same but my bot is extraction is empty cells how to resolve this empty data extraction please help me out
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 8000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Hi. So I followed all the steps given and before the "postal code split" did the run of the process and received an error saying Failed to save document. HAs there been some xls protection changes that actually cause the file not to be savable automatically?
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 8000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Hello Jensen, Does power automate have feasibility to extract the date from web with selected date, week, year , if so can you share any example please... Thanks
Hey Harish, Yes you can schedule Power Automate Desktop flows. Kindly check this one: ua-cam.com/video/CN_tPdAEkTc/v-deo.html
@@andersjensenorg thank you so much
You're an extraordinary teacher Anders. I came into these tutorials knowing nothing and now, at least, have the slightest understanding of what can be done. I'm not a developer and have no desire to become one--I just need this to help me harvest a bunch of data and have created a couple of flows that collected what I need. Thank you!
Wow, Robert. What a nice comment, thanks a lot 🥳 Have you seen my Power Automate Desktop beginners guide: ua-cam.com/video/qfpHqfp2R3Y/v-deo.html Some things will be repeaten, but I think it's a nice framework to get started. Have a great day (and please let all the great, and not so great, feedback follow). Kind regards, Anders
@@andersjensenorg Yes I've seen that and have probably spent 20 - 30 hours watching and re-watching various videos you've posted. I'm about to look at your PDF extraction videos because I have a serious problem I'm working on: creating individual indexes for nearly 300 pdf newsletters (each about 25 pages long) and then creating a master index. So thank you again.
Excellent. This is going to help me streamline my work processes a lot more easily than with Python.
You're very welcome, Dave G - 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
@@andersjensenorg Quick question for you Anders. I watched your excellent video on AI Builder. I want to try it, but I don't see it on my PA desktop app. Any idea why that might be?
How about a PAD lesson that teaches how to interact with ERP systems…Batch processing, loops, error handling & reporting,triggered w/ mobile Device or desktop shortcut
Great idea, Kevin. Have you seen this video (light ERP): ua-cam.com/video/BxkfdK8rCRU/v-deo.html Kind regards, Anders
Thank you for these tutorial series, Mr. Jensen.
You're very welcome, Tuấn Nguyễn Đình - 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
Would you have any ideas or tutorials on how to scrape the thumbnail item images on eBay or Amazon? Along with the typical fields (title, price, etc.) I'd really like to find a way to also grab the product image as part of each item scrapped.
Sure check this, where I scrape the Amazon URL. The same technique is used for Image ua-cam.com/video/POfK2A8iWAs/v-deo.html
excellent, this is great information
Glad it was helpful! 🥳🙂
Very well explained. I love the way you add one step at a time, and then check the output. Keep doing the good work! Appreciate it very much!
Thanks a lot, Neela Roy 🤗 Your feedback helps me immensely. 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
I am facing issues locating the json property, since there is a NULL value in one of the fields. any suggestions on how to resolve? the process stops as soon as the row that has this field as NULL is hit
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 6000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
This video made you my hero !! I have no words to thanks you for making things soo sooo easy for me. This was my first video from your channel and guess what !! from now I am not going to miss any of your future or past videos. Thank Thank you so much for making my day. Love from India ❣ And will do a hamble request please please never stop making such tutorials🤭
Thank you so much for your kind words! Your comment made me feel like a superhero, even though I don't have a cape (yet). 😂 I'm glad that my video was helpful and that you enjoyed it. It's wonderful to have you as a subscriber and I promise to keep creating tutorials that make your day! Sending lots of love back to India ❤️🇮🇳
I got stuck at the Set Variables: %Result Data Table + [CurrentItem['CVR'],... always gives me an error, and I have it the same as in the video
I did it, apparently copy and paste did not work
Hey KelsC, it needs to be %ResultDataTable + CurrentItem['CVR']...
Excellent tutorial! I learned a ton, thanks. More projects!
Hey KelsC, thanks a lot for the nice words 😍🙌
Thank you sir. It is difficult to find such teachers as yourself. Please continue your efforts and they are appreciated.
Thanks a lot, Joshua M 🤗 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
Great work sir with suitable explanation
Hey Yogiraj Sutar. Thanks a lot 😊 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
Great series of tutorials Andre’s… thank you & keep them coming!😊
Thanks a bunch, DIY-Investors 🥳🙂
You are amazing! I love the PAD content, it has been super useful ❤️
Thanks a ton, Nathaniel - A lot of new PAD videos is in the pipeline 😊 Kind regards, Anders
Thank you very much for your extraordinary effort in helping the power automate community. please, if you can take a example for " Use paging " in "Extract data from web page".
Thanks a lot, HASAN - I'm so happy about your comments here and there 😊 Regarding your problem: Check this video at 37:34 - ua-cam.com/video/WXK0u2yXLrU/v-deo.html Kind regards, Anders
Great video. I do find the contains function to be very useful when an element contains text. To click on the language buttons you could try button:contains('English'). That would reduce the logic needed to get the correct element!
Thanks a lot, Chandler - and great input, I'll try to use your expression in one of the next videos 😊
I prefer watching your videos over Netflix 😅, am a fan here based in Singapore… Love the way you explain how each Action works and what it does!💯💯
Btw, I was able to do an introductory demo of Power Automate to our QA team by just simply watching thru your video tutorials, isn’t that cool!! 😎😎😎
I hope you ca n show more tips and tricks about the built-in selectors and regular expressions..😊Thank you and more power!
Hey Geraldine. Wow, thanks a lot for the nice words. It's not cool, it's mega cool - great job. Regarding your request, I got a RegEx video in the pipeline. I'll do selectors as well. Any particular case, you want to see? Kind regards, Anders
Hi Anders, Thanks a lot for the video. BTW, you mentioned about the "CSS selector series" that you are going to prepare. Can you please update the link in here if it already created or please let us know when you will be updating the series....Thanks again!
Hey Mahesh, thanks a lot. I'm still working on it (CSS), but check this from 23:33 - ua-cam.com/video/A8cLOfItmv8/v-deo.html 😊 Kind regards, Anders
Hi Anders thank you for the great video. I have a similar use case. But there are couple of more pages in the same url with data to be extracted? how can i extend this use case to extract the information from multiple page. thanks
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Great Videos Anders. I'm wondering if there's a way to write to a worksheet that's protected in excel? I can't find an unprotect action in Power Automate.
Hey Derek Lauder 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
Amazing vídeo, fantastic!
Thank you so much, Leandro - my pleasure 😀
You mentioned in your video there was a file for what to do if you Excel file locks up. I didn't see anything in the upper right corner. Will you please post it here?
Hey Emily. Check this video: ua-cam.com/video/4Py-V85bPfo/v-deo.html at 16:19 😊 Kind regards, Anders
Hi Anders, great video, thanks for sharing. I have a use which you may show in your next videos. I got an email with a HTML table inside in email body. I need to transfer this with PAD in excel. Kind regards Nguyen
Hey Nuin Huin 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
Why do you use “Ctrl+clic” when you add an UI element and not just “clic” ?
Thank you !
That's how the program works 🙂 If you just click, it will click normally. Kind regards, Anders
great job
Thanks a lot, Lawrence 😊
Thanks
My pleasure 😊
Note: I had to add a "wait 6 seconds" for my page to load - the run didn't have time to scrape the page before continuing to the next step. It caused my results table to be blank.
Hey Emily. Yeah, you could/should do a check for the page you want to scrape, when you observe problems. You can use the same approach, as I do at around 21:52, where I check for English. Just change the English to e.g. an element of the table, e.g. CVR. I hope this helps. Kind regards, Anders
Can you link to an Excel file that is saved in SharePoint instead of on-prem?
Hey Kellsea, yes for sure - have you seen the SharePoint actions (scroll all the way to the end of the actions). They're still in preview though. Kind regards, Anders
Hi Anders, my PAD failes call the Power Automate Extension on Edge. Microsoft cannot provide a solution so far. Do you have any ideas about this issue?
Hey Raymond. Unfortunately not, as I'm sure you've already tried re-installing etc. 😑 Have you seen my Discord? You're more than welcome to post the problem there. Here's how to join (it's of course free): ua-cam.com/video/xWFz-S96XGo/v-deo.html
@@andersjensenorg Thanks Anders! I will join the Discord to post the problem.
I made a loop for the BOT to enter a link to extract the data, come back to enter another link to extract another data, but instead of it incrementing the lines both in the table and in Excel, it opens several files and saves one in each file, like me can I do to put each extracted file one under the other?
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 4900+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
just to make sure about power apps I can create apps but for other people to use they pay per user/month ? thats a bit expensive for company has 100 employees can create the web app once but will take longer to develop of course but on the long run will be cheaper
Hey virtumind 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
Hi Andres
Can u please help me on how to combine two datatables which contains more than 1000 rows
I'm trying a lot in loop it's taking more time can u please 😔 help me
Hey Bhavana, you could solve it with a script, else we have to loop (if we want to stay in PAD). Kind regards, Anders
WHY EXTRACT ACTIVITY DO NOT EXTRACT DATA
Hey Only Ips 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
@@andersjensenorg ,please make videos on all activities of power automate desktop