- Видео 7
- Просмотров 26 703
Thomas "Shaky" Petersen
Добавлен 6 май 2021
Tutorials done quick - Power Automate Desktop, license structure
This is the first episode in a tutorial series I'm launching. I don't assume any programming experience, that said, it will be moving fast so keep your boots on.
This first episode is relaxed, I will be covering the licensing structure and explain why you maybe not need any license if you already have 365 licenses.
0:00 introduction
0:20 Overview
0:55 Cloud flows
1:40 Desktop flows
3:10 Attended / Unattended licensing
5:48 User license for cloud flows
8:39 Power Automate Desktop overview
9:26 Power Automate (online)
This first episode is relaxed, I will be covering the licensing structure and explain why you maybe not need any license if you already have 365 licenses.
0:00 introduction
0:20 Overview
0:55 Cloud flows
1:40 Desktop flows
3:10 Attended / Unattended licensing
5:48 User license for cloud flows
8:39 Power Automate Desktop overview
9:26 Power Automate (online)
Просмотров: 1 341
Видео
Power Automate Desktop - RegEx
Просмотров 2,3 тыс.2 года назад
The Power Platform Done Quick series is an attempt at solving your issues quickly without having to search the video for the 30 seconds that actually help you. Todays subject is Regular Expressions. Surprisingly easy once you spend a couple of hours on it and extremely powerful.
Power Automate Desktop - Logging and cloud flow template
Просмотров 2 тыс.2 года назад
The Power Platform Done Quick series is an attempt at solving your issues quickly without having to search the video for the 30 seconds that actually help you. Todays subject is something you should always consider when making a desktop flow. Logging and cloud flow template. This is my approach. 0:00 Introduction 1:02 Writing to CSV file 1:46 Creating the logList 2:15 Timestamp 4:21 Using a log...
Cloud flows - Basic Expressions
Просмотров 2592 года назад
The Power Platform Done Quick series is an attempt at solving your issues quickly without having to search the video for the 30 seconds that actually help you. Covered here is how to use basic expressions in your cloud flows, a VERY handy tool 0:00 Introduction 0:59 Reading raw output 2:32 When dynamic content loops.. 3:28 The outputs() function 4:36 Looking at the json output 5:20 Accessing va...
Power Automate Desktop - advanced UI elements
Просмотров 16 тыс.2 года назад
The Power Platform Done Quick series is an attempt at solving your issues quickly without having to search the video for the 30 seconds that actually help you. Covered in this video is looking for website text and using ordinals 0:00 Introduction 0:11 Properly editing the UI element 1:24 Browser dev tool 2:54 Contains operator 4:14 Multiple similar elements 4:46 Ordinals 6:35 Variables in selec...
Power Automate Desktop - move mouse to web element
Просмотров 3,6 тыс.2 года назад
The Power Platform Done Quick series is an attempt at solving your issues quickly without having to search the video for the 30 seconds that actually help you. Covered here is custom objects, data tables, lists and bool operators in Power Automate Desktop. 0:00 Describing issue 6:13 finished solution
Power Automate Desktop - advanced variables
Просмотров 1,5 тыс.2 года назад
The Power Platform Done Quick series is an attempt at solving your issues quickly without having to search the video for the 30 seconds that actually help you. Covered here are custom objects, data tables, lists and bool operators in Power Automate Desktop. Here are some helpful bool functions you can use! Contains(VAR, 'KEY', False) NotContains(VAR, 'KEY', False) IsEmpty(VAR) IsNotEmpty(VAR) S...
Hi! Do you have any video about WINDOWS UI ELEMENTS SELECTORS? Not Web selectors, but Windows selectors. Thanks
heya, no i don't. The concept is the same though, just different element names.
Great clip! I can see we are multiple Danes working in this community, that's so cool to see! :)
thx, glad you liked it :)
@thomas"Shaky" Peterson what if this is the <a class="inside_table_link winAutomationHighlightingClassForSelectedElementsGreen" href="/Contract/View/DownloadContractFile?contractFileId=5d0820c1-43c3-40e3-ac23-068d86eb3674&addDate=12%2F08%2F2022%2013%3A19%3A08&fileName=23-DES-ITBPW-291%28Ardent%29executed12.8.22-NoCert.pdf" target="_blank" winautomationvisibilitylandmark="true" mspad-previous-style="" style="">23-DES-ITBPW-291(Ardent)executed12.8.22-NoCert.pdf</a> and i have multiple links which when open have multiple links on the web page that when click download a file so there is so similar pattern here like <a class="inside_table_link winAutomationHighlightingClassForSelectedElementsGreen" href="/Contract/View/DownloadContractFile? till here can I automate to download all such links from the web page?
Thanks for the great video, able to understand clearly.
I'm very happy it was helpful, thx for mentioning it :)
Hey Thomas - I've probably watched each of your videos a dozen times or so over the last year. They're all fantastic. I also check your channel every couple months in hopes that you've posted something new. In the event that you no longer plan to post RUclips videos, I figured it was time to post a comment & at least express my appreciation for your work. You're a fantastic teacher/instructor. Dealing with nuanced topics, I think it's hard to strike a balance between oversimplification & intimidation. You strike that balance very well, even with complex topics, making them seem more approachable. I know this is a strange comment to make out of the blue on a year old video, but the approachability of your demos was honestly inspiring for me. Anyways, I just wanted to tip my cap & thank you. I hope you'll consider posting videos again someday, but if not, thank you again & I hope life's treating you well.
Wow, I am extremely humbled, thx a lot for saying that. I wouldn't mind making more videos at all, I simply can't think of a subject. If you have any suggestions I'd be happy to make a video on it. Thx again Marc, have a good one
Unrelated, but how do you insert the headers in the flow lines, eg: 1 Custom object?
hey Kristian, I don't know what a flow line is. Custom object don't have headers, they have keys and values.
I see that the headers are comments, they just look different than my comments
Great video Thomas, please keep them coming!
Thx mate, that motivates a lot
@@thomasshakypetersen1609 Honestly you deserve it. Btw how can I contact you personally regarding a paid request?
Very nice. I'll ask if you could help with another head-scratcher, I'd appreciate if you had the time to check! Basically I activate a web browser on a page, select a button, and the action generates a second tab (where I'd like to submit username and password) which comes with a "formally incorrect URL" - I can't use it directly to open a new browser instance. Unfortunately, PAD switches back to the original tab before it can fill the fields, and the flow fails since it can't recognize the UI elements. I've tried clicking on the tabs area "on the right", but of course the trick doesn't work. I've also tried typing text (hotkey combination Ctrl+2) to switch to the second tab. Still doesn't work. PAD doesn't do image recognition like Automate Anywhere either, so right now I'm a little stuck on this apparently little issue.
sure, the "launch edge/chrome..." action attatches itself to a single tab. When opening a new tab, you need to run a new "launch..." action and choose the "attatch to.." option. There, you can either attatch to the activated tab or choose it by title ( ex. shopping cart , the * are wildcards)
Dude I'm so grateful about your explanation, I was trying to get warranty date from Dell website and the Power Automate was getting text equal to the first search, so after I removed the 'condition' text equal to text and kept the class title, it worked well. Thanks a lot!!!
great solve mate, glad i could help
Can you make more videos like this, with advanced examples
was thinking about it, yeah :)
You save my day Thanks
great job. super useful!
I have a client and they want to setup their environment. How should I proceed? Since this is their POC process developed in PAD, should I suggest that they get one User License and to have one Virtual Machine that the BOT is always logged into?
Wow did this help me, thank you.
Glad to hear it :)
Good day. Thomas where would be a good place to learn in detail about Power Automate (i.e. course work or books)? It seems like there is a lot of tailored information for easy tasks. I is real hard to find in-depth information in abundances like yours. I would like to know in-depth information about all Power Automate, but right now I'm learning how to make flows between software's on Windows. It is hard to get thing to repeat without having to redo all of the UI element each time, when I open Power Automate and the software's. Do you have any good suggestions? Thank you Jeff
hiya Jeff, the best youtuber (and most popular) is probably Anders Jensen, ruclips.net/video/0S_QgIOvB7c/видео.html
Great valuable Infos. Thanks for Sharing!
Great - Everyone asking me about selectors in PAD gets a link to this!
thanks Anders :)
Thank you. I have some questions, hope you don’t mind. Do you end up setting the flow to failed, if it failed? Right now all flows would succeed, even upon error. In the last scope you have some dataverse actions. Is that just for one line entry from the current flow or do you gather the log from the desktop flow? Thank you.
Hi Jens, no problem. Nice catch, I actually usually set a "terminate flow" action in the global error handling subflow and use the "get last error" action with error msg. That way, I can have an error msg read: "a;b;c;lastError" where a,b,c are cases automated. I can then parse that error in the cloud flow. I never upload the entire log, but I have on occasion uploaded a chunk (that case) to dataverse.
Do you know if it's possible to print a list of all variable names from a flow?
Unfortunately, there isn't any functionality that would do that. When the desktop flows run, they're cached here Users\ ... \AppData\Local\Microsoft\Power Automate Desktop And it deffenietely is possible to extract a list of variables from there. It's a bother however :)
@@thomasshakypetersen1609 agreed. It would be a lengthy process to code as well. I appreciate your videos and hope you decide to do more!
How do you get all the data from the box for each down scroll please explain
you don't need to scroll down, it reads the data from the html code, not what your eyes can see. So just keep looping through the data and use an 'on error, go to label' to exit the loop when there isn't any more data
@@thomasshakypetersen1609 hi have tried the loop, it extracts 15 items which are visible and from 16 item it's not able to extract because for 16 items we should scroll down any option
@@mukramcricktech6934 I see, well in that case the code doesn't load the rest of the board until you scroll down. It's annoying but fixable.You have to scroll down every 10 or so items. Create an if sentence at the top of the loop, checking if a counter = 10. If yes, scroll down. Is that possible?
thanks for sharing great video may I ask how can I loop it to the last of Ordinal when I original don't know how much is there? cheers
Hiya Dexter, you simply don't know when the rows stop :) The trick is to do error handling on the first read action in the loop. If it fails, set a bool to %True% and continue flow. Then an if sentence with bool = True ? => exit loop. Hope that helped
So helpful! I've been looking for an explanation on how the ordinals system works. Totally didn't know it had a starting point of zero. Would've taken me at least a few more days of testing and frustration to figure that out. Thanks very much!
Thx, glad it was helpful!
Thank you for making my day. Great video
thx, glad you liked it!
p͎r͎o͎m͎o͎s͎m͎ 😩
exactly What i was looking for.. thanks for posting this.
Thank you! Was really helpful. Would appreciate more examples on RegEx.
glad you liked it Nikolai. There are just sooooo many different operators, uses and so on so it's hard to pick. If you need a regex for a specific thing, throw it here and i'll regex it
@@thomasshakypetersen1609 Oh, that would so nice of you. I was actually trying to parse text: <ns0:Customer>DummyCustomer</ns0:Customer> with a positive lookup = (?<=ns0:Customer>).+, but this expression retrieves all values after "Customer>" in this case. How could I get the value "DummyCustomer" via RegEx?
@@nikolaidedenkov8414 you include a lookbehind. So ?<=ns0:Customer>).+(?=<ns0:Customer>)
@@thomasshakypetersen1609 Thank you, just what I was looking for. Appreciate a lot!
How to detect logo in Web UI
a logo will have an <img> element that you can find with the browsers dev tool. The img element will probably have a src attribute, which would be the name of the image.
@@thomasshakypetersen1609 If website is dynamic then?
@@arenahax6655 the image name is almost always static. Try to reload the website to check what changes and what doesn't
@@thomasshakypetersen1609 i am talking a scenario when dynamic websites aka different url with different design needs to automate?
@@arenahax6655 there is always some static aspect of it. It depends from site to site of course, unfortunately I don't have a general answer to the issue except for identifying what is static and what isn't.
thank you for your video, just please when you recored the video make it 1080 p or more 😇
Yeah, probably a good idea :) Thx
Thank you Shaky Really helpful
i would love to see an example, on Window Name matching. As i have the same Window but with different Titel, depending from where you start the window.
Great content! I have subscribed your channel, looking forward to more of your power automate videos.
thx mate, very glad you liked it
Is it posible select an element from a shadow root?
I remember having problems with it, so every time I encounter one I use a .js, that works fine.
Haha, I skipped the TryCatch part and came back - realizing I got a nice shout out. Thanks a lot 😍
Nice video, Thomas 🙂 I hope you create more.
an You plz show me how to handle a downloaded file in power automate, a serie filename: FunnyS01E01.mkv. I want to move this file to an external hd. The filepath on this hd is Funny. The sub dir is S01. Here I want my file. Next time its an other filename but same structure.
You mean in Power Automate Desktop right? There is a 'move file' action, just choose the file you wanna move and where you want to move it. If the destination changes, you can insert a variable into the destination path, like C:\%pathVariable%\
yep, possible. Easy in fact 🙂 Can you plz show me. Your answer from Discord
Wrong video, this is it ruclips.net/video/nRHp15Yu_8A/видео.html
IS there any way to have nested list Variable? Like a list of Lists?
No, there isn't. The structure is lifted from the .NET framework. Nested variables are basically data tables, so that would probably be the way to go about nested lists.
Nice video. =)
Brilliant! Thanks ever so much.
Glad you liked, give a shout if you're wanting any topics covered.
Thanks for sharing those ingenious methods of how to get some of those things done. I've seen much longer videos explaining it much worse 😃
Thanks a lot, it's awesome hearing that the short video is appreciated. If you have any suggestions on how to improve or maybe what subject would be helpful, I'd love to hear it.
@@thomasshakypetersen1609 for me it was great that you showed how to cleverly adapt the UI element selectors. It's really hard to find any documentation on how to use that, so your tips to make it as short as possible and use F12 first to find a unique element were very helpful. If you would like to make another video to provide additional insights in the use/meaning of those different levels and features listed on each level, that would be highly appreciated.
@@janvanhaver6970 when you say levels, are you referring to UI selectors? If so, consider it done!
@@thomasshakypetersen1609 yes, those different lines that you can select or deselect and per line the different things then listed on the right