RPA Challenge in Power Automate for Desktop (Selectors)
ฝัง
- เผยแพร่เมื่อ 19 มิ.ย. 2024
- This video tutorial shows how to solve the RPA Challenge in Microsoft Power Automate for Desktop. The hands-on use-case is famous for going through important RPA concepts such as UI Elements and selectors, web automation, Excel, and optimization of your RPA flows.
COURSE MATERIALS:
📂 The steps: andersjensen.org/microsoft-po...
🍣 CSS Diner: flukeout.github.io/
VIDEOS FOR YOU:
🔹 Power Automate for Desktop Tutorial: • Power Automate Desktop...
🔹 My RPA Developer Salary: • My RPA Developer Salar...
👨👩👧👦 Discord: / discord
- Join my network with 2700+ RPA Developers, where we solve RPA problems, network, and help each other upgrade our careers. It's free!
FOLLOW ME:
💼 LinkedIn: / andersjensenorg
📸 Instagram: / andersjensenorg
👨 Facebook: / andersjensenorg
🐦 Twitter: / andersjensenorg
💌 Email Newsletter: andersjensen.org/email-newsle...
MY MONITOR (Amazon affiliate):
🖥️ Samsung 49-inch CRG9 Curved Monitor = geni.us/MDpejc
- If you are buying this, I can recommend the Mi Monitor Light Bar = geni.us/3Wwad
0:00 Intro
You'll learn to solve the RPA challenge in Microsoft Power Automate for Desktop. First, download the Excel book and inspect the sheet with data for the challenge. It's 7 columns and 11 rows, where the first is a header column. The data must be filled into input fields on the RPA Challenge page. Later we'll speed hack the solution to solve it quickly and apply reusability to the solution (one RPA best practice).
2:41 Read the Excel data
Use a Launch Excel action to open the Excel book with data. Provide the document path. Untick the Make instance visible parameter, as we don't need to see what's going on. Tick the Read-only parameter, as we don't need to write things back to the Excel sheet. Remember to use a Close Excel action so you don't lock your Excel book with Power Automate for Desktop. To find the range of data, we use a Find first free column/row action, which provides variables for the first free column/row after our data. The first problem occurs; it seems like we have 1001 rows for data and one column too much - we'll fix that manually (making sure we have good data quality). Now we can read the data with a Read from Excel worksheet. Remember to tick the First line of range contains column names in the advanced parameters, as the first line is headers.
10:50 Populate fields with the Excel data
We have read our data in Power Automate. Now launch a browser with the Launch new Chrome action. Use a For each action to iterate through each value in our Excel sheet (Data Table). The Populate text field on web page action is used to type into the fields. We refer to the CurrentItem and the column in scope to fill the correct data into the field. Add a Ui Element for the field and remember to rename it. Use a Click link on web page action to click the submit button. We open the Developer tools to find a CSS/jQuery selector for the fields and buttons, as this is part of the challenge.
38:55 The fastest RPA Challenge solution in Power Automate
We can do the challenge solution even faster. In the Click link of web page action, we untick the Wait for page to load parameter. In the Populate text field on web page action, we untick Emulate typing and Wait for page to load parameters. In the debugger, set the Run deal to 1ms, which is the delay between the actions of the flow.
41:41 Dynamic selectors in the RPA Challenge
This will not make your solution faster; in fact a little slower. But if you manage this concept, you'll get a lot better as an RPA developer. We create a dynamic selector in the UI Elements of Power Automate, so we only need to use one Populate text field on web page action. Add each selector to a list and use a For each action to iterate through each selector.
#office365 #powerautomate #microsoft - วิทยาศาสตร์และเทคโนโลยี
What was your time? Please post it here in the comments 👇
1894ms on Chrome but it was 10 seconds+ on Microsoft Edge. Do you have a browser preference for RPA?
2516 seconds. I wonder if this can be a reason to get new cpu rig. Wish me luck with my mrs. 🤣
2min 30secs
14480ms = 14.48 seconds
7675ms
RPA Challenge! Noice! Watching the automation of this website never gets old. It's so satisfying to watch. =)
Dave - So glad you're visiting 😊 Very nice videos yourself. Kind regards, Anders
Thank you very much again. I re-training with your video (all of 11 video). It help me to improve my knowledge for Power Automate Desktop. I really appreciate it. ❤💯
I'm so glad to hear, thanks for letting me know, Pitak 😍 Have a great day, kind regards, Anders
It is just like cooking.
You can read a recipe and try to imagine how to do it.
If you watch the Chef do it in real life you can get so much more out of it.
Hats off!
Thank you 😊!
Hey Basil Kezios. Thanks for all your support - it's highly appreciated 😊 Have a great day. Kind regards, Anders
Hi Anderson, you are doing really great..Hats off to your videos
Thanks a ton, Sumesh! ❤❤
Really good content!! Thank you so much
Thank you so much, happy to hear 🙂 Kind regards, Anders
Excellent video, thanks
You're very welcome, Pitak N - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: th-cam.com/video/xWFz-S96XGo/w-d-xo.html
Lots of Love form India. You are awesome. Although I have not tried this yet but it was so interesting I saw it 2 times already. So many things i learnt. I will definitely give it a try 🙂 thank you so much for the great content.
Hey Sudhansu - thanks a ton 🤩🤩🤩 I'm glad you like it. During the next weeks, I will have a lot more Power Automate for Desktop videos coming. Have a great day 😊 Kind regards, Anders
excellent job please keep it up👍
Thanks a ton, HASAN 😊
Excellent video, thanks. Quick tip: you can delete all unused UI elements by clicking the 3 dots and selecting "Remove all unused elements".
Hey zmgen - wow thanks a lot. I've never paid notice 😀 Please continue to comment, if you see something I can do better 😊 Kind regards, Anders
Hej Anders
Virkelig fed video! - Især den sidste del med Dynamic Selectors.
Jeg kommer helt sikkert til at implementere dette i mit flow i næste uge.
Tak!
Tusind tak, Asam - fedt du kan bruge det 😊 Har du set denne: th-cam.com/video/cieSRNUykvo/w-d-xo.html Kind regards, Anders
Excelent video. Great learning and quality. Thank you very much. My robot time: 28 seconds.
Wow, in Power Automate Desktop without scripting? 🙂
to speed up to maximum go on advanced of populate text field and disable "Wait for page to load", it is unecessary to be activated while do writing operation.
Thank you, Vincent - I do that from 38:55 in the video 😊 Kind regards, Anders
Thank you again for this video in which you show how to effectively use selectors in webpage. Best for the End how to use List in PAD. is it ok after my practice to publish the italian version of it?
Hey Macrais. Thanks a lot 😊 Do you mean creating it yourself? Then of course.
Hey @Anders 🙂Hope you're doing well. Amazing work here by the way. LOVE it. I was curious if you've competed in any RPA hack-a-thon events?
Hey Bootz2Botz - Thanks a lot 🤩😍 No, unfortunately not - can you recommend anything? Kind regards, Anders
Anders, I love your videos and the way you teach. You have helped me a lot, thank you so much. 😊
I have a question in the construction of the selector: is it possible to inform more than one property of the element in the selector? like in Xpaths, for example:
//*[@data-controller="modal" and @data-target="#site-search"]
Hey Anderson Samoyedem 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: th-cam.com/video/_QRI-Yo2h8U/w-d-xo.html Have a great day. Kind regards, Anders
very helpful, I uesed to record steps bu got many run time errors, this video is more clear.
Thanks a lot, yongle shen 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
My time was 4015 milliseconds. The video recording software slows down the performance 😣 I did it without recording and got 1985 milliseconds.
Great work! I've been able to learn a lot watching your videos. But I'm currently working on a personal automation project and I need to create a pivot table in excel from power automate. Do you have any suggestions on how I could go about that?
Hey Pelumi Olalekan 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: th-cam.com/video/_QRI-Yo2h8U/w-d-xo.html Have a great day. Kind regards, Anders
Very good video! Thank you for sharing with us. Do you have video in Power Automate of the RPA Challenge on RPA Stock Morket?
Thanks a lot, but unfortunately 😔 In 2-3 weeks I have a new one about the RPA Challenge and how to solve it with PAD + OpenAI 😊 Kind regards, Anders
@@andersjensenorg Thank you so much, we can't wait to see the videos! And learn more about Power Automate. It's very difficult to solve. See you soon 🙏😊
I got the same dynamic selector value problem few days ago. It's easier to use F12 instead of reading the web page property to parse for the text.
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
Wow, this seems similar with UFT also, but less coding.. 😊
Im looking for a good RPA tool for QA, will u recommend this PowerAutomate over UIPath?
Hey Geraldine. Then I would go with UiPath, as PA doesn't have a QA module 🙂 Kind regards, Anders
Could you please show how would you do it without using first free row/ column activity? How can we avoid extra 1000 rows without manually deleting them?
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
Hello Sir, I saw your course on Udemy regarding REfeamework, I am completely new to this RPA field and have no prior knowledge or experience, I want to switch my career as it isn't paying enough and I am not learning enough, hence, someone suggested to me RPA Uipath, upon checking for jobs I got to know that almost all organisations demand REfeamework, so is your course enough to give all the experience required so that I can make a switch saying i have 1-2 years of experience in RPA with RE framework?.....I can't say as a fresher because I am working and I want to leverage all the suffering through these years and use it as experience on my resume letter.
Hey Ayush. UiPath is a fantastic place to start, as it's free for private use, so you can practice unlimited. Here's what I would do:
1. Join my Discord with more than 2700 RPA developers: andersjensen.org/#community It's free and here we network and solve RPA problems together 🙂
2. Take our new UiPath Beginner Course: www.udemy.com/course/uipath-1-beginner/?referralCode=3ED73AA1F53036934C12
3. Get UiPath Associate certified
4. Take the REFramework Course: www.udemy.com/course/uipath-reframework-everything-explained/?referralCode=D6D88EA29CDD14738199
5. Get UiPath Advanced certified
Kind regards, Anders
does the challenge include downloading the excel file as well? in that case you need to dynamically figure out how many rows you really have..
Hey stage1media. No, the timer does not include the download. In the newer versions of PAD you can just specify the entire sheet, when using the Read from Excel worksheet. I hope that helped. Have a great day 🙂 Kind regards, Anders
@@andersjensenorg that works great, thanks!
Is it possible to do this with power automate from the cloud?
Unfortunately not, you need to be able to interact with UI elements (Power Automate Desktop). Kind regards, Anders
Need help, Have very simple use case i.e. check if URL is up or not, below is working fine when I have a valid URL but if I provide an invalid URL then Flow is not going to Error condition where I created subflow
with a message showing URL Not Accessible
Launch new Microsoft Edge brower
If windows contains -> Captured UI element to check if we can see a image
Display message, URL is up
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 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
Man, I’m struggling with selectors. I’m doing exactly as you said, but in my case the browser never recognizes the selector! What can I do?
Does it work with regular clicks (where PAD generates the selectors)? If not, reinstall PAD from Microsoft Learn.
@@andersjensenorg when I Add UI Elements for the first time, it works. The item may be dynamic and any attribute I try to configure doesn’t work when I reload the webpage. I will read CSS diner and if I still can’t do it, I’ll back here for help! Thank you so much, your channel is fantastic!
Yeah, and feel free to post on my Discord for more help. Its 100% free (link in description). Kind regards, Anders
86075 milliseconds
Each populate text field seemed to take about a second. No idea why so slow.
That's odd, usually PAD and Edge/Chrome is rather fast. Anyway, congrats on completing the flow - Kind regards, Anders
so I got 6.2 seconds in power automate, doing it the same way basically.
for fun I tried in java and got 6.1 seconds. The development time is 10x faster in PA of course. Here is the video to it : th-cam.com/video/RthsA-WgKvg/w-d-xo.html
I put a link to your video in the description.
Thanks for the great introduction
Haha love it, and yes with scripting we can do much faster 😀
please do video on python scripting with PAD
Hey Naresh, I have Powershell and VBScript with PAD coming up, might also do Python 😊
1647MS
w/o scripting - impressive PD 😦
5319 milliseconds
💪💪
2238 milliseconds
🔥👏🙌
"choose a you ah el". I don't have meaning comment so leaving this one.
Hahaha 😅
67757 milliseconds
💪💪 What do you think of PAD? Kind regards, Anders
4899 milliseconds - my computer isn't that fast...
Haha, well done, Kasper - hardware is probably no 1 issue for (lack of) perfomance 🙂