At 9:40 Anders assigns the variable AmountOfReviewsBeforeEndClick as the first operand of the 'Send Keys Loop' and then AmountOfReviewsAfterEndClick as the second. My understanding was that the variables contained a datatable (rather than the numeric value = RowsCount). In fact, they do both contain a datatable, which can be displayed using a msgbox. The actual row count can be displayed in a msgbox too but requires explicit reference to the RowsCount property of the datatable (ie. %AmountOfReviewsAfterEndClick.RowsCount%). I imagine that the requirement for the loop operands to be numeric, has PA automatically reference the RowsCount property implicitly, rather than throw an error. This was not obvious and had me scratching my head. Mystery solved!
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Hi Anders, your tutorials in Power Automate has help me since the start of my Internship in March up to today. I managed to properly connect two different webapps via REST API and it all thanks to your help. Good onya mate!
Hey, tahuhey, wow, what a lovely message to receive. Thanks a lot 😊🙌 I will do my best to create more Power Automate tutorials that suit your needs. Kind regards, Anders
Good afternoon, Jensen, It seems to me that we need to set the focus to the page we like to scroll before we send key in order for the robot to scroll to the end of the review. Please advise.
wish i could like this twice. haha. PA is great but the learning curve can be steep in some edge cases like this. even when they’re simple, seeing practical applications is super helpful. awesome work! Thank you!
Thank you so much, meta-mac 😊 I agree, nothing is complicated in Power Automate Desktop - you need to get the right idea, which is easier when you have seen it before. Have a great day. Kind regards, Anders
Hi anders, Your videos really halped a lot in learning specially css selectors. Very detailed and well explained.And As you always say , i pratice while watching your video. Thanks a lot and keep up the good work 👍 more power to you 💪
Hi Andres, Thanks for explaining the infinite scroll. It is working really fine. Can you help me extract whole the reviews text that can be initiated by clicking on more?
Great, I have a question, in your example you used a browser that was open, I tried opening a new browser with the Google Maps URL that you left in the description, but the PAD gives a URL error, in this case is there any solution?
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
@@andersjensenorg I want to pull pages from an aspx website and save as pdf so I can later selectively print the ones I need. I can enter search criteria but its faster to just enter the URLs because they are all numbered.
Hi Anders, When fetching tweets from Twitter using a specific keyword, it only extracts the latest ten tweets. When I scroll down and select more, it captures the tweets at the bottom and the ones at the top get removed. Is there a solution for this? Thank you for your guidance.
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.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 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): th-cam.com/video/xWFz-S96XGo/w-d-xo.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 14,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): th-cam.com/video/xWFz-S96XGo/w-d-xo.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 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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Like if the video helped you, thanks ❤
Every Power Automate Desktop best practice explained: th-cam.com/video/QjrxLPg_TdI/w-d-xo.html
At 9:40 Anders assigns the variable AmountOfReviewsBeforeEndClick as the first operand of the 'Send Keys Loop' and then AmountOfReviewsAfterEndClick as the second. My understanding was that the variables contained a datatable (rather than the numeric value = RowsCount). In fact, they do both contain a datatable, which can be displayed using a msgbox. The actual row count can be displayed in a msgbox too but requires explicit reference to the RowsCount property of the datatable (ie. %AmountOfReviewsAfterEndClick.RowsCount%). I imagine that the requirement for the loop operands to be numeric, has PA automatically reference the RowsCount property implicitly, rather than throw an error. This was not obvious and had me scratching my head. Mystery solved!
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Hi Anders, your tutorials in Power Automate has help me since the start of my Internship in March up to today. I managed to properly connect two different webapps via REST API and it all thanks to your help. Good onya mate!
Hey, tahuhey, wow, what a lovely message to receive. Thanks a lot 😊🙌 I will do my best to create more Power Automate tutorials that suit your needs. Kind regards, Anders
Good afternoon, Jensen,
It seems to me that we need to set the focus to the page we like to scroll before we send key in order for the robot to scroll to the end of the review. Please advise.
Good morning, yes and that's what I do at 2:20 in the video 😊 Kind regards, Anders
wish i could like this twice. haha. PA is great but the learning curve can be steep in some edge cases like this. even when they’re simple, seeing practical applications is super helpful. awesome work! Thank you!
Thank you so much, meta-mac 😊 I agree, nothing is complicated in Power Automate Desktop - you need to get the right idea, which is easier when you have seen it before. Have a great day. Kind regards, Anders
Hi anders,
Your videos really halped a lot in learning specially css selectors. Very detailed and well explained.And As you always say , i pratice while watching your video. Thanks a lot and keep up the good work 👍 more power to you 💪
Hey Furqan, 1000x thanks, highly appreciated - and that's the right way to do it: Open PAD and replicate. Have a great weekend, Anders 😊
Awesome video once again.. learnt so much from you since last 1 year on Desktop flows..keep doing the great stuff..
Hey Mayank, thanks a lot, highly appreciated 🙌😊 Kind regards, Anders
Hi Andres,
Thanks for explaining the infinite scroll. It is working really fine. Can you help me extract whole the reviews text that can be initiated by clicking on more?
My pleasure, yes I do it here: th-cam.com/video/7jqD9YucPSA/w-d-xo.html 😊
Thanks, but Anders this assumption is based on each scroll has different numbers of reviews right?
My pleasure, no - this will work regardless (at least on Google reviews). Kind regards, Anders
Do you have any videos about Botcity? I did not find.
Unfortunately not 😒
Great, I have a question, in your example you used a browser that was open, I tried opening a new browser with the Google Maps URL that you left in the description, but the PAD gives a URL error, in this case is there any solution?
Hey William, no problem here, you might need to add a click on the "Review" button. Kind regards, Anders
great job ! Anders, looking forward to watching more quality videos like this. how about s next time😀
Many thanks, Lawrence. Sure, do you have a public example page I can use to demo in the video? Kind regards, Anders
Thank you Anders... Please make a video on the topic captcha solving using OCR
Noted, thank you, Swapna 🙌😊
Hi Anders, it doesn't work when I use this on TH-cam to scrape streams numbers and artists name ?
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Is there any chance you could do a video, if it is possible, on how to feed in a list of URLs from excel and save each page as a pdf to a folder?
Hey Joseph, thanks a lot for the suggestion. Do you have a sample page of what you want to save? Kind regards, Anders
@@andersjensenorg I want to pull pages from an aspx website and save as pdf so I can later selectively print the ones I need. I can enter search criteria but its faster to just enter the URLs because they are all numbered.
Additional note, I'd like to save it as a pdf rather than as an image so I can search through the document to see if it contains key words later on.
Hi Anders,
When fetching tweets from Twitter using a specific keyword, it only extracts the latest ten tweets. When I scroll down and select more, it captures the tweets at the bottom and the ones at the top get removed. Is there a solution for this?
Thank you for your guidance.
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
how to click on hyperlink with same name mutiple times is there any way we can store cardinal values
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Hello my power automate keep running even the the page reached the end of list, so how to stop it from keep running after reach the end?
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 14,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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
So when we compare the values of two data tables, it actually compares the number of their datarows...hmmm
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders