awesome tutorial. at 37:00, the text field on the webpage loses focus, so sending the enter key has no effect. under "populate text field on web page" there is an advanced tab, make sure "unfocus text box after filling it" is not blue that fixes that issue
hi, if you hadn't mentioned thie here , newbies like me would have wasted quiet a few hours thinking why it isn't working and trying to fix!! Thank you!!
@@umamaheswariv haha, this newbie did spend hours and then I did a search for "pop" using Edge Ctrl+F on THIS comments section and found @boythee4193 fix; gonna try it now! Just starting to get the hang of this stuff...
Anders, thank you very much for creating this course. It is SUPER useful and goes into elegant and simple best practices that I have not seen elsewhere. I really appreciate that you provide really useful learnings from the very first minute - no time wasted, and the detail is amazing. Your video surpasses anything I found on Microsoft Learn, Udemy or TH-cam. You give me hope that I can become a GREAT citizen developer. Well done on the content and many, many thanks!
Wauw, many thanks 🙌😍 I'm very happy to hear. You're more than welcome in my community of 10000+ RPA developers, where we help each other: discord.gg/iloveautomation, it's of course 100% free 😊 Kind regards, Anders
Dear Anders, I am completely new to this automation field and don't have any background like coding or technical. But your videos are great to watch as you explain in easy ways. I really like your teaching skills which helps beginners to learn or adapt these tools. Thanks a lot.
You're very welcome, Sunil Kumar - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 7000+ RPA developers networking and solving problems: th-cam.com/video/xWFz-S96XGo/w-d-xo.html
What a nice feedback message, thanks a ton Robert 🙌😊 I can recommend this video, if you want to build more step-by-step PAD: th-cam.com/video/BxkfdK8rCRU/w-d-xo.html Kind regards, Anders
Hi Anders, i have just started out learning Power Automate Desktop Flows and i can't thank you enough for making such a wonderful beginners series on the topic. You make it so easy to learn, while elaborating and touching down on all the crucial aspects of the various flow actions and their outcomes. i have managed to create some few basic flows with the help of your videos and now i am stuck at a point where i need some guidance to complete the flow.
@@andersjensenorg Yes absolutely! I have already joined the Discord community and loving it. Your PAD videos have really helped me in saving much of my time and getting familiar with the basics of desktop automation. Now, trying to build some cloud flows. 😃
These videos are the best! Thank you so much for doing them and making them available. I’ve struggled with Power Automate. You course touches on all the things I’ve struggled with. As a non=programmer also very appreciative of all the Best Practices tips.
Hey Bill. I'm so excited to read this - highly appreciated. Then it's much easier to create these videos. So what are you building next in Power Automate (Desktop)? Kind regards, Anders
@@andersjensenorg Right now I’m working on an automation to take emails and convert them into pdf’s then email them then move the email to a processed folder. Then loop through the process.
@@billk1917 Sounds great. And automating our own stuff speed up learning. My first project was to fill in Ebay posts (pictures, texts etc.) from an Excel sheet.
Liked and subscribed. Worked through both this video, and UIpath video of yours as well, fantastic work, thank you so much Anders! You've got a new follower from Canada, learning a ton from you!
Hey Bruce, thanks a ton for such a nice comment, appreciated. 🙂🙌 You're more than welcome at the I Love Automation community. We're 6000+ RPA developers that help each other, and it's of course 100% free: th-cam.com/video/xWFz-S96XGo/w-d-xo.html
Thanks a bunch, @kebincui 🤩 I've created a Discord. We're more than 8000+ RPA developers networking and solving problems here: th-cam.com/video/xWFz-S96XGo/w-d-xo.html You're more than welcome. Kind regards, Anders
Anders, as I said in the past, within the UIPATH series, you're really spectacular as a teacher. It's impossible not to understand you. Great stuff for me, my collaborators and my Master's students. Best!
You're very welcome, @dambad71 - 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: th-cam.com/video/xWFz-S96XGo/w-d-xo.html
You're very welcome, Gobona Fellah - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 5800+ RPA developers networking and solving problems: th-cam.com/video/xWFz-S96XGo/w-d-xo.html
Hey Nick - thanks a lot for the lovely message :) I appreciate your nice comments, they help me a lot as a creator! Have a great day. Kind regards, Anders
Thanks a bunch, @wrajer 🤩 I've created a Discord. We're more than 8000+ RPA developers networking and solving problems here: th-cam.com/video/xWFz-S96XGo/w-d-xo.html You're more than welcome. Kind regards, Anders
@@andersjensenorg Oh yes CSS part especially! Brings this up to another level. Also, in this one it's much better solution for extracting results from multiple pages then in older clip with books on Amazon. 👍
Thanks a lot, Ismayil Isgandarli 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 6000+ RPA developers networking and solving problems: th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Hi Anders, really enjoying the tutorials on Power Automate. What do you suggest as an alternative for VBScript following the discontinuation announcement? PowerShell? Mange takk!
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
You're very welcome, Arsalan Ahmad - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 6000+ RPA developers networking and solving problems: th-cam.com/video/xWFz-S96XGo/w-d-xo.html
This is a beginner course? I can't wait to see what an advanced course looks like 😄 Thanks for your time and work. Great tutorial. Always something new to learn from you, even from a "beginner course"
@@andersjensenorg Not so difficult but challenging, especially in the second part. Perfectly good as internet is full of boring tutorial explaining for example, what "send mouse click" action do. Any hope for an advance/extreme course !?
@@vilimmt Good and bad news. Good news is yes, I'm creating a complete course, that will prepare for the PL-500 course. Bad news, it will be a paid course on Udemy or so 🙂
Hi Anders things got a bit intense at around 1 hour with the loops. The first one was ok, but after that I got lost. I've done some of your UIPath videos and that seems an easier product to get your head around. Not sure if that's just me! Will have another go and see if I can follow! Keep up the good work!
Hey versacedan, thanks a lot 🙂 Hmmmm, I think the difficulty are around the same in Power Automate Desktop and UiPath. My best recommendation is, when you feel you're losing it, just build along and you will eventually understand it (you can also rewind or pause). I don't expect you to understand everything once the video is over. Kind regards, Anders
Hi Anders, Thank you for the wonderful video, I just had one thought! Instead of using loop to identify the Next button, couldnt we have used the Set the element as Pager option in UI element picker? That could have eased our life much more.
Hey Sazzarello, please open up the 'Populate text field on web page' action - Go to advanced and untic the 'Unfocus...'. Then it works 😊 Kind regards, Anders
Hi Anders, I love your videos. I am trying to create a PAD flow that will read a column from a sharepoint list titled "user ID" and then disable the user in active directory. I can't seem to be able to connect PAD to my sharepoint list or have it read the selected column. Do you have any advice?
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 7000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Hi Anders, I just started learning power automate and saw one of your video on UI Automation. Am actually trying to automate data extraction from few tools like tableau, power bi, sharepoint etc., by adding few filters in those., does this video help or can you suggest me any other videos you have shown the same ? Please suggest
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Hi Anders! Thanks for this video. I really enjoyed my first step to learning Power Automate through your video. I have a question though on the first example with the calculator. What if I want to enter more than 1 digit as my Button 'NumberA'. How do I go about it?
Hey Tope, we would need to create a check for digits in the beginning, and then create a loop around the input 🙂 Please post it on my discord (free), then we solve it for you, the link is in the description. Kind regards, Anders
Trouble with Extract element value -> Text: I'm at 38:21 on the video. I'm trying to Extract element value. I right click and can see the options for Text:, Title:, etc. But when I try to left click on Text to select it nothing happens. I succeeded once and the green dots appeared around the text, but I couldn't succeed with the second element. When I tried again I couldn't even get the green dots? I've tried Firefox and Edge without success. Any idea why this might be happening? Maybe the web page changed?
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
The problem I was having sounds similar to those below. It is not an issue with the flow, it is the behavior of the web page I took Anders advice and started "having fun". Rather than looping through the search results, my solution was to insert 2 steps after the first "Send Keys" 1) "Wait for Web Page Content' for the UI element "Show All" 2) "Click on UI Element" "Show All" identified in the previous step. This way, all of the data is loaded and read in a single pass.
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Hey SC, can you go into the Populate text field in the action before and then go to advanced and untick "Unfocus...". Then it will work. Kind regards, Anders
@@andersjensenorg Thanks it works ! But there is another issue in next step Extraction. When I right click, it show extract elements value as 39:02, but then I cannot do a further select under the arrow of Extract Element Value. Also the computer become very lag and even freeze. Can you please suggest to solve this? or due to my computer hardware? (my laptop: i5-8250u and 16gb ram)
Hello Anders, I have learned a lot from your videos in Power Automate, THANK YOU!! I have successfully made some flows to scrape data and write them to Excel. The data is written to more than one worksheet in an Excel workbook. However, the challenge is that there are not tables in each new sheet made. I'm able to create a table in the single worksheet. I can't find a method to do it for all the worksheets within the Excel workbook with unique name on each worksheet. Would mind making a video in how to create a table in each new worksheet created after scraping the data from a website? It would be most appreciated!
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 5800+ 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
Thank you so much for your hard work. Video tutorials they helped me a lot. I have a question. Can I configure power automate so that it copies text from a web page and enters it into the search bar and finds the copied information as a result of a search? Thank you sir!!!
Hey and thanks a lot for the nice comment. Yes, and it's easy. Can you please post the problem on my Discord, and then we solve it (or rather we help you with pointers, and you solve it 😀 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
Anders, thanks for sharing this content. I'm following them and applying the new knowledge into my daily tasks. By the way, I've seen that you have the Actions descriptions in English, while also having your keyboard in Danish. How did you do that? (Note: I've seen your video were you explained the needed configuration in Windows, but I've done that and my keyboard language always comes back to English 😞). Hope you can share that trick too.
Hey Daniel. Thanks a lot. Can you please share a screenshot at the I Love Automation discord (link in description)? The screenshot should be of your Language Settings in Win 🙂 Pick the #power-automate-desktop-help channel Kind regards, Anders
In regards to web scraping, how can close the browser "before" we Launch new browser? I tried adding "Close web browser" as the first step in my flow, but it throws an error.
When you build have a browser open (any random site). Use a Terminate process action in the beginning (where you want your browser to close), in the dropdown find the process name (e.g. msedge or chrome). That will work 🙂
Hi Anders, Need a guidance from you. When ever I try to right click and select extract value using scrape from web chrome it don't work properly as most of time the option to extra value than text value don't appear and got hanged. Even updated the power automate desktop don't understand is it due to some system requirement or due to internet issue.
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
@@andersjensenorg sure man, thank you very much. i have been learning PA from your channel for a truly long period of time, so it was a piece of cake for me. but in this new course (2023) you show some recent examples (Loop Condition - if a web page contains, I usually used - 'set element as a pager' so as always i learned something new :) )
Hey Toya. It depends on what you want to accomplish? If it's getting a job, I will look at what's most popular in job posts in your region. If it's salary, then Power Automate (Desktop) has higher. A lot of parameters. You're more than welcome to join the I Love Automation discord (link is above) and get further inputs 🙌🙂 Kind regards, Anders
So I'm from cape town south africa. I work for a fairly decent company that's very forward thinking howverr I only realized after watching your vids that I'm basically some sort of RPA developer. I have been using UIpath for running certain repetitive task. So based on this it open my mind after seeing that this is actually a career path as I have been using it to just create free time for myself while studying my honours in MIS. I'll surely join the discord and recommend you to everyone I know. Lastly based on the above. Would it be best for me to just become excellent in UIpath or should I try to learn power automate.
Hi Anders, would you be able to do a course about using Outlook via the Graph API in Power Automate Desktop? Great video though, have provided to some of my colleagues so hopefully they will see the light and start using some of these tools!
Hey Kyle. Thanks a lot. It's not in the pipeline, but I've but it on my idea board for new videos 🙂 I saw a similar request on my discord - was that you? Kind regards, Anders
You have such vast experience, but in the past you had to beginn somewhere. What is your advice how someone should start to learn all the basics? Did you do the Trainee courses from Microsoft, or is it all learning by doing? Can you recommend the Microsoft certifications etc. Could be maybe a good video
Hey Hoheshaus. I came from UiPath (most advanced RPA tool), so it was an easy transition. I would go for TH-cam. Have you seen my 100% community, I Love Automation: discord.gg/iloveautomation Here we help each other with solutions and careers 😊 Kind regards, Anders
Hii sir make a video on Extract data from webpage Action where undefined, single value, handpicked values, list Table, Entire html table how to use and where to use in Power automate desktop
Hey suraj - it's basically the same, you just need to find the correct selector(s). Anyway have you tried yourself? If yes, I gladly help you through on the I Love Automation discord. Kind regards, Anders
Friend! How do you simulate a shift click, the shift has to be down in order for my paint brush to work in selecting all the gradients, I searched far and wide 🥺😢🥺
What happens when you run across a page that does not have a "was" or "now" class? Does the automation fail at some point? How does the flow now to continue if neither of these CSS classes exist, while working with CSS selectors?
You need to create your selectors so they're stable. Usually, PAD does it for you, and else we find the classes ourselves. Here the automation would fail if now and was for some reason weren't present. Kind regards, Anders
While doing SAP AUTOMATION there is one check box if I use click it is working fine but while looping it is doing other way and I am not getting what I need , how to handle this check box in SAP through power automate desktop application
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Hi, i have a situations coming from dynamics web form (row injectors), it will change id class every time we create new row, there is no static id class and also name etc., how can we handle 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 5800+ 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 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): 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 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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Th populate text field on web page isn't working correctly I have no clue why. The text variable is input[Id="srchInput"] and unfortunately it doesn't write in the search area but makes the window go down. I've tried several times and reloaded the page but still no success.
Very weird. Just tried with the three different browsers (Chrome, Edge and FireFox) and the selector: input[Id="srchInput"] - Can you for testing try another browser choice (e.g. Edge if it failed in Chrome) and see if it fails there? Kind regards, Anders
@@andersjensenorg Unfortunately does the same for all the browsers. Funny bit is that it clicks the search button and it can do the extract data from web page. But it doesn't do the type into. No clue why?
@@WakoKiler That is very weird. You're more than welcome to post in on my discord, and then one of us will solve it for you (bit hard without screenshots) 🙂
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
I have tried to test the web scrapping using MS Edge, the latest version based in Chromium and i just cant get the elements to be scapped, i dont want to instal Chrome or another Browser to test the web scrapping, why Microsoft let always these crazy things happen with their own products? It is supposed that PAD should work wonderfully with every MS product🙃
Hey Guillermo. I've just tried with both upgraded Edge and PAD, and it works here. Can you try to post the error with a screenshot on my discord (the #powerautomate-desktop-help channel), then we fix it: discord.gg/iloveautomation Kind regards, Anders
Hey Viv_ekk - don't worry, it's not easy the first times. This 11 minute guide will teach you everything about loops: th-cam.com/video/QOM0GG7k_Pw/w-d-xo.html And please open Power Automate Desktop and build with me - you learn 10x faster 🙂 Kind regards, Anders Ps. You're more than welcome at my Discord, where we help each other - the link is in the video description.
How to transpose extracted data from web page (Column) to write to excel in row. 306.00 586.00 asakki13_0-1708336119527.png output will be as in excel 306.00 586.00
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): 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 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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
1:06:08 ohh my GOD it just keeps getting worse, lol! UiPath *utterly eviscerates* Power Automate for multi-page table extraction. Sheesh. What a joke. So much for citizen developers doing this.
Haha 😀 I agree. Not everything works 100% well. But the demand from citizen developers is towards Power Automate Desktop and not UiPath. Mainly because of data privacy/GDPR (companies already trust MS with their data). Have a great day. Kind regards, Anders
![Power Automate Tutorial ⚡ Beginner To Pro [Full Course]](http://i.ytimg.com/vi/KsgxDz-nY_I/mqdefault.jpg)
I'm blown away by all your nice feedback ❤
I've created a 2024 version of the course: th-cam.com/video/B0cHOdBv7Jg/w-d-xo.html
awesome tutorial. at 37:00, the text field on the webpage loses focus, so sending the enter key has no effect. under "populate text field on web page" there is an advanced tab, make sure "unfocus text box after filling it" is not blue that fixes that issue
Hey Boy Thee - thanks a lot for the clarification. It's weird in PAD, that this is an issue for only some. Kind regards, Anders
hi, if you hadn't mentioned thie here , newbies like me would have wasted quiet a few hours thinking why it isn't working and trying to fix!! Thank you!!
@@umamaheswariv haha, this newbie did spend hours and then I did a search for "pop" using Edge Ctrl+F on THIS comments section and found @boythee4193 fix; gonna try it now! Just starting to get the hang of this stuff...
🤣🤣not alone@@umamaheswariv
Anders, thank you very much for creating this course. It is SUPER useful and goes into elegant and simple best practices that I have not seen elsewhere. I really appreciate that you provide really useful learnings from the very first minute - no time wasted, and the detail is amazing. Your video surpasses anything I found on Microsoft Learn, Udemy or TH-cam. You give me hope that I can become a GREAT citizen developer. Well done on the content and many, many thanks!
Wauw, many thanks 🙌😍 I'm very happy to hear. You're more than welcome in my community of 10000+ RPA developers, where we help each other: discord.gg/iloveautomation, it's of course 100% free 😊 Kind regards, Anders
Thanks for all your support and likes 🙌🔥
Here's your invitation and guide to join my Discord: th-cam.com/video/xWFz-S96XGo/w-d-xo.html
Dear Anders, I am completely new to this automation field and don't have any background like coding or technical. But your videos are great to watch as you explain in easy ways. I really like your teaching skills which helps beginners to learn or adapt these tools. Thanks a lot.
You're very welcome, Sunil Kumar - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 7000+ RPA developers networking and solving problems: th-cam.com/video/xWFz-S96XGo/w-d-xo.html
I think I can honestly say that this is the best video tutorial that I have ever encountered
What a nice feedback message, thanks a ton Robert 🙌😊 I can recommend this video, if you want to build more step-by-step PAD: th-cam.com/video/BxkfdK8rCRU/w-d-xo.html Kind regards, Anders
Happy new year to you Anders, and to you all!
Hey Lawrence - thanks a lot and a happy new to you - Have a great day. Kind regards, Anders
Hi Anders, i have just started out learning Power Automate Desktop Flows and i can't thank you enough for making such a wonderful beginners series on the topic. You make it so easy to learn, while elaborating and touching down on all the crucial aspects of the various flow actions and their outcomes. i have managed to create some few basic flows with the help of your videos and now i am stuck at a point where i need some guidance to complete the flow.
Hey PeacefulTunes, thanks you so much for the very nice comment 🥰 I'm so glad to read. Are you still building PAD flows? Kind regards, Anders
@@andersjensenorg Yes absolutely! I have already joined the Discord community and loving it. Your PAD videos have really helped me in saving much of my time and getting familiar with the basics of desktop automation. Now, trying to build some cloud flows. 😃
These videos are the best! Thank you so much for doing them and making them available. I’ve struggled with Power Automate. You course touches on all the things I’ve struggled with. As a non=programmer also very appreciative of all the Best Practices tips.
Hey Bill. I'm so excited to read this - highly appreciated. Then it's much easier to create these videos. So what are you building next in Power Automate (Desktop)? Kind regards, Anders
@@andersjensenorg Right now I’m working on an automation to take emails and convert them into pdf’s then email them then move the email to a processed folder. Then loop through the process.
@@billk1917 Sounds great. And automating our own stuff speed up learning. My first project was to fill in Ebay posts (pictures, texts etc.) from an Excel sheet.
Liked and subscribed. Worked through both this video, and UIpath video of yours as well, fantastic work, thank you so much Anders! You've got a new follower from Canada, learning a ton from you!
Hey Bruce, thanks a ton for such a nice comment, appreciated. 🙂🙌 You're more than welcome at the I Love Automation community. We're 6000+ RPA developers that help each other, and it's of course 100% free: th-cam.com/video/xWFz-S96XGo/w-d-xo.html
Excellent! 👍👍Thanks Anders for sharing
Thanks a bunch, @kebincui 🤩 I've created a Discord. We're more than 8000+ RPA developers networking and solving problems here: th-cam.com/video/xWFz-S96XGo/w-d-xo.html You're more than welcome. Kind regards, Anders
This whole course is the truth as of 2023 with PAD - Nice work.
Thank you so much for the nice comment 😍 Kind regards, Anders
Anders, as I said in the past, within the UIPATH series, you're really spectacular as a teacher. It's impossible not to understand you. Great stuff for me, my collaborators and my Master's students.
Best!
You're very welcome, @dambad71 - 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: th-cam.com/video/xWFz-S96XGo/w-d-xo.html
Woooow, this tutorial is awesome, for my first encounter with RPA Iv learnt a lot. Feeling like a master already
You're very welcome, Gobona Fellah - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 5800+ RPA developers networking and solving problems: th-cam.com/video/xWFz-S96XGo/w-d-xo.html
thank you ,I have learned a lot from your videos in Power Automate
My pleasure, thanks for the support 💪🙂
Great updated video. Appreciate your content SO much!
Hey Nick - thanks a lot for the lovely message :) I appreciate your nice comments, they help me a lot as a creator! Have a great day. Kind regards, Anders
Great course thank you 👍
I'm so happy to hear, thank you 👍😊
Excellent course for MS PAD
thx.
Many thanks, Willy 🤩
Fantastic example Anders! Covers a lot of possibilities and shows in enough detail to allow implementation too. Thanks!
Hey Dave, thanks a lot, highly appreciated 🙂🙌 Kind regards, Anders
Great Video!
Thanks a bunch, @wrajer 🤩 I've created a Discord. We're more than 8000+ RPA developers networking and solving problems here: th-cam.com/video/xWFz-S96XGo/w-d-xo.html You're more than welcome. Kind regards, Anders
Thank you for your time on this.
My pleasure, Krishan 🙏
Great one. I've already passed your similar YT tutorial, but this one has some new useful details. Tnx! 👍
Hey Ivo - I'm so glad to hear 😊 The CSS part and the invoke VB script? Kind regards, Anders
@@andersjensenorg
Oh yes CSS part especially! Brings this up to another level.
Also, in this one it's much better solution for extracting results from multiple pages then in older clip with books on Amazon. 👍
@@ivoradulovic5596 That's nice!
Congrats, very nice Anders
Thank you so much, highly appreciated. Kind regards, Anders 🙂
Great video. Thanks
Thanks a ton 🙌😍
Awesome tutorials ! Thank you so much for creating such a helpful content 🙂
Thanks a lot, Ismayil Isgandarli 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 6000+ RPA developers networking and solving problems: th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Hi Anders, really enjoying the tutorials on Power Automate. What do you suggest as an alternative for VBScript following the discontinuation announcement? PowerShell? Mange takk!
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Awesome Lectio Magistralis.
Thanks a ton 🙌😍
Thank you for the lessons!
Hey Anthony, happy to create them - thanks for your comment, appreciated 🦾😊
Thanks a lot for this great work
You're very welcome, Arsalan Ahmad - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 6000+ RPA developers networking and solving problems: th-cam.com/video/xWFz-S96XGo/w-d-xo.html
This is a beginner course? I can't wait to see what an advanced course looks like 😄 Thanks for your time and work. Great tutorial. Always something new to learn from you, even from a "beginner course"
Haha, hey Vili 😀 Do you think this was too difficult for a beginners course? Kind regards, Anders
@@andersjensenorg Not so difficult but challenging, especially in the second part. Perfectly good as internet is full of boring tutorial explaining for example, what "send mouse click" action do. Any hope for an advance/extreme course !?
@@vilimmt Good and bad news. Good news is yes, I'm creating a complete course, that will prepare for the PL-500 course. Bad news, it will be a paid course on Udemy or so 🙂
@@andersjensenorg Fair enough. I will follow Udemy then.
@@andersjensenorg will it be power automate desktop only or will you include power automate online? Hoping it's just the desktop part.
Hi Anders things got a bit intense at around 1 hour with the loops. The first one was ok, but after that I got lost. I've done some of your UIPath videos and that seems an easier product to get your head around. Not sure if that's just me! Will have another go and see if I can follow! Keep up the good work!
Hey versacedan, thanks a lot 🙂 Hmmmm, I think the difficulty are around the same in Power Automate Desktop and UiPath. My best recommendation is, when you feel you're losing it, just build along and you will eventually understand it (you can also rewind or pause). I don't expect you to understand everything once the video is over. Kind regards, Anders
Hi Anders,
Thank you for the wonderful video, I just had one thought! Instead of using loop to identify the Next button, couldnt we have used the Set the element as Pager option in UI element picker? That could have eased our life much more.
Hey Rajesh, you're right, but it hasn't worked for years. So we have to do it manually 😞 Kind regards, Anders
My Send keys Enter click does not work at 37:58. I am going to use Click UI element in window and continue with the lesson.
Hey Sazzarello, please open up the 'Populate text field on web page' action - Go to advanced and untic the 'Unfocus...'. Then it works 😊 Kind regards, Anders
Hi Anders, I love your videos. I am trying to create a PAD flow that will read a column from a sharepoint list titled "user ID" and then disable the user in active directory. I can't seem to be able to connect PAD to my sharepoint list or have it read the selected column. Do you have any advice?
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 7000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Hi Anders,
I just started learning power automate and saw one of your video on UI Automation.
Am actually trying to automate data extraction from few tools like tableau, power bi, sharepoint etc., by adding few filters in those., does this video help or can you suggest me any other videos you have shown the same ? Please suggest
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Hi Anders! Thanks for this video. I really enjoyed my first step to learning Power Automate through your video. I have a question though on the first example with the calculator. What if I want to enter more than 1 digit as my Button 'NumberA'. How do I go about it?
Hey Tope, we would need to create a check for digits in the beginning, and then create a loop around the input 🙂 Please post it on my discord (free), then we solve it for you, the link is in the description. Kind regards, Anders
And thanks a bunch for the nice words ❤️
yessss! thank youuuuuuuuuuuu
Hahaha, thank you so much 😍 Kind regards, Anders
Trouble with Extract element value -> Text:
I'm at 38:21 on the video. I'm trying to Extract element value. I right click and can see the options for Text:, Title:, etc. But when I try to left click on Text to select it nothing happens. I succeeded once and the green dots appeared around the text, but I couldn't succeed with the second element. When I tried again I couldn't even get the green dots? I've tried Firefox and Edge without success. Any idea why this might be happening? Maybe the web page changed?
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
The problem I was having sounds similar to those below. It is not an issue with the flow, it is the behavior of the web page I took Anders advice and started "having fun". Rather than looping through the search results, my solution was to insert 2 steps after the first "Send Keys" 1) "Wait for Web Page Content' for the UI element "Show All" 2) "Click on UI Element" "Show All" identified in the previous step. This way, all of the data is loaded and read in a single pass.
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Hi, I am using MS edge as web browser. It is not working to send "Enter" key as described on 37:17. I have to use "Press Button on Web Page" instead.
Hey SC, can you go into the Populate text field in the action before and then go to advanced and untick "Unfocus...". Then it will work. Kind regards, Anders
@@andersjensenorg Thanks it works ! But there is another issue in next step Extraction. When I right click, it show extract elements value as 39:02, but then I cannot do a further select under the arrow of Extract Element Value. Also the computer become very lag and even freeze. Can you please suggest to solve this? or due to my computer hardware? (my laptop: i5-8250u and 16gb ram)
Hello Anders,
I have learned a lot from your videos in Power Automate, THANK YOU!! I have successfully made some flows to scrape data and write them to Excel. The data is written to more than one worksheet in an Excel workbook. However, the challenge is that there are not tables in each new sheet made. I'm able to create a table in the single worksheet. I can't find a method to do it for all the worksheets within the Excel workbook with unique name on each worksheet. Would mind making a video in how to create a table in each new worksheet created after scraping the data from a website? It would be most appreciated!
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 5800+ 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
Thank you so much for your hard work. Video tutorials they helped me a lot. I have a question. Can I configure power automate so that it copies text from a web page and enters it into the search bar and finds the copied information as a result of a search? Thank you sir!!!
Hey and thanks a lot for the nice comment. Yes, and it's easy. Can you please post the problem on my Discord, and then we solve it (or rather we help you with pointers, and you solve it 😀 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
Thank you sir
A pleasure, Mahesh - have a great day 🙏🔥
Anders, thanks for sharing this content. I'm following them and applying the new knowledge into my daily tasks.
By the way, I've seen that you have the Actions descriptions in English, while also having your keyboard in Danish. How did you do that? (Note: I've seen your video were you explained the needed configuration in Windows, but I've done that and my keyboard language always comes back to English 😞). Hope you can share that trick too.
Hey Daniel. Thanks a lot. Can you please share a screenshot at the I Love Automation discord (link in description)? The screenshot should be of your Language Settings in Win 🙂 Pick the #power-automate-desktop-help channel Kind regards, Anders
In regards to web scraping, how can close the browser "before" we Launch new browser? I tried adding "Close web browser" as the first step in my flow, but it throws an error.
When you build have a browser open (any random site). Use a Terminate process action in the beginning (where you want your browser to close), in the dropdown find the process name (e.g. msedge or chrome). That will work 🙂
@@andersjensenorg That worked! Thank you!
Hi Anders,
Need a guidance from you. When ever I try to right click and select extract value using scrape from web chrome it don't work properly as most of time the option to extra value than text value don't appear and got hanged.
Even updated the power automate desktop don't understand is it due to some system requirement or due to internet issue.
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
great job! (as always)
Thanks a lot, Grzegorz- did you build the web scraping solution? 🙂
@@andersjensenorg sure man, thank you very much. i have been learning PA from your channel for a truly long period of time, so it was a piece of cake for me. but in this new course (2023) you show some recent examples (Loop Condition - if a web page contains, I usually used - 'set element as a pager' so as always i learned something new :) )
I'm glad to hear - alternative solutions are great to have in the toolbox 😀
Hey Anders hope you well. Between power automate and Uipath . Which one would you advise me on learning ? Thanks alot for all your videos
Hey Toya. It depends on what you want to accomplish? If it's getting a job, I will look at what's most popular in job posts in your region. If it's salary, then Power Automate (Desktop) has higher. A lot of parameters. You're more than welcome to join the I Love Automation discord (link is above) and get further inputs 🙌🙂 Kind regards, Anders
So I'm from cape town south africa. I work for a fairly decent company that's very forward thinking howverr I only realized after watching your vids that I'm basically some sort of RPA developer. I have been using UIpath for running certain repetitive task. So based on this it open my mind after seeing that this is actually a career path as I have been using it to just create free time for myself while studying my honours in MIS. I'll surely join the discord and recommend you to everyone I know. Lastly based on the above. Would it be best for me to just become excellent in UIpath or should I try to learn power automate.
Hi Anders, would you be able to do a course about using Outlook via the Graph API in Power Automate Desktop? Great video though, have provided to some of my colleagues so hopefully they will see the light and start using some of these tools!
Hey Kyle. Thanks a lot. It's not in the pipeline, but I've but it on my idea board for new videos 🙂 I saw a similar request on my discord - was that you? Kind regards, Anders
Interested as well!
You have such vast experience, but in the past you had to beginn somewhere. What is your advice how someone should start to learn all the basics? Did you do the Trainee courses from Microsoft, or is it all learning by doing? Can you recommend the Microsoft certifications etc. Could be maybe a good video
Hey Hoheshaus. I came from UiPath (most advanced RPA tool), so it was an easy transition. I would go for TH-cam. Have you seen my 100% community, I Love Automation: discord.gg/iloveautomation Here we help each other with solutions and careers 😊 Kind regards, Anders
Hii sir make a video on Extract data from webpage Action where undefined, single value, handpicked values, list Table, Entire html table how to use and where to use in Power automate desktop
Hey suraj - it's basically the same, you just need to find the correct selector(s). Anyway have you tried yourself? If yes, I gladly help you through on the I Love Automation discord. Kind regards, Anders
Did you make the pl 500?
Yes (work in progress): th-cam.com/play/PLXXz88_TPiHrnu0itj7At0K-xEZyl2XNr.html
Friend! How do you simulate a shift click, the shift has to be down in order for my paint brush to work in selecting all the gradients, I searched far and wide 🥺😢🥺
Hey Louie. Use a Send keys and in the parameters choose the Insert modifier and there is the Shift 😊 Kind regards, Anders
Sir Make more videos on Advanced level in power automate desktop
Thank you - I will make a lot of them in 2023 🙌😊
What happens when you run across a page that does not have a "was" or "now" class? Does the automation fail at some point? How does the flow now to continue if neither of these CSS classes exist, while working with CSS selectors?
You need to create your selectors so they're stable. Usually, PAD does it for you, and else we find the classes ourselves. Here the automation would fail if now and was for some reason weren't present. Kind regards, Anders
While doing SAP AUTOMATION there is one check box if I use click it is working fine but while looping it is doing other way and I am not getting what I need , how to handle this check box in SAP through power automate desktop application
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Hi, i have a situations coming from dynamics web form (row injectors), it will change id class every time we create new row, there is no static id class and also name etc., how can we handle 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 5800+ 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
Please make videos on API ,XML,FTP etc.
Hey Only, thanks for the ideas - have you seen this: th-cam.com/video/dDhsyfbPChw/w-d-xo.html 😊
I have watched all power automate desktop videos
Can this software do all types of automation?
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Please upload the one video for rpa uipath production support role work in day to day real time project
Great idea!
I have a Mac machine 😢
I need to install windows on the cloud and start .. is there any way help me please
It's unfortunately .NET-based, so it won't work on Mac 😔
Is it possible to, instead of sending an email, create a draft?
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Th populate text field on web page isn't working correctly I have no clue why. The text variable is input[Id="srchInput"] and unfortunately it doesn't write in the search area but makes the window go down. I've tried several times and reloaded the page but still no success.
Very weird. Just tried with the three different browsers (Chrome, Edge and FireFox) and the selector: input[Id="srchInput"] - Can you for testing try another browser choice (e.g. Edge if it failed in Chrome) and see if it fails there? Kind regards, Anders
@@andersjensenorg Unfortunately does the same for all the browsers. Funny bit is that it clicks the search button and it can do the extract data from web page. But it doesn't do the type into. No clue why?
@@andersjensenorg What helped is focus text field on web page before the populate text field. But on its own it still doesn't work unfortunately.
@@WakoKiler That is very weird. You're more than welcome to post in on my discord, and then one of us will solve it for you (bit hard without screenshots) 🙂
Marcin, the same thing happened to me. Try changing the browser size to "Normal" instead of "Maximized."
How to do something in loop? And how to adjust its speed?
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
I have tried to test the web scrapping using MS Edge, the latest version based in Chromium and i just cant get the elements to be scapped, i dont want to instal Chrome or another Browser to test the web scrapping, why Microsoft let always these crazy things happen with their own products? It is supposed that PAD should work wonderfully with every MS product🙃
Hey Guillermo. I've just tried with both upgraded Edge and PAD, and it works here. Can you try to post the error with a screenshot on my discord (the #powerautomate-desktop-help channel), then we fix it: discord.gg/iloveautomation Kind regards, Anders
Hi @anders I am not able to understand the flow & loops 😐😔😔
Hey Viv_ekk - don't worry, it's not easy the first times. This 11 minute guide will teach you everything about loops: th-cam.com/video/QOM0GG7k_Pw/w-d-xo.html And please open Power Automate Desktop and build with me - you learn 10x faster 🙂 Kind regards, Anders Ps. You're more than welcome at my Discord, where we help each other - the link is in the video description.
How to transpose extracted data from web page (Column) to write to excel in row.
306.00
586.00
asakki13_0-1708336119527.png
output will be as in excel
306.00 586.00
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
I have an also question?
Yes, go ahead 🙋♂️🙂
I forgot a question but will you make a video in which we learn all of tools of power automate desktop?
@@andersjensenorg and how can we take a data from one websites and fill in the specitfic field in another websites
Is this only me? I found the screens shared are so blurry. Is there a clearer version? The content is great, though
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
hello
Hey 🙂
You built your first robot.
Jesus christ, you just opened calculator. Calm down.
I think it's an accomplishment, well done 💪💪
1:06:08 ohh my GOD it just keeps getting worse, lol! UiPath *utterly eviscerates* Power Automate for multi-page table extraction. Sheesh. What a joke. So much for citizen developers doing this.
Haha 😀 I agree. Not everything works 100% well. But the demand from citizen developers is towards Power Automate Desktop and not UiPath. Mainly because of data privacy/GDPR (companies already trust MS with their data). Have a great day. Kind regards, Anders