Thanks Kevin. This video (like many others you do) is a really eye opener. MS creates so many products yet fails to simply demonstrate how to use them and what benefits one can get by using them. You do a great job filling this void. Thanks a lot.
MS does demonstrate how to use it. there's a video on their yt channel. just doesn't get a lot of views bc who wants to go to MS to learn about its own tools right? lolz
@SHRModding People who want to learn but don't take the time are called lazy ppl lol. Just bc something is convenient doesn't mean it will be a longterm solution.
It's also worth pointing out that these automations can run in remote compute instances; you don't _have_ to run them locally. You can also initiate them from the power automate website or from within flows. It is a full RPA solution. For example, when email received, save attachment, run PAD to transfer content to legacy app, confirm entry to sender.
Can't thank you enough for uploading this tutorial. I was very close to hiring an outside consultant to develop tools to analyze all the data we collect. But after watching this video I was able to develop two automation tools that allow me to process huge amounts of data. Even 3 months ago I was analyzing barely 5% of all data and essentially were flying blind. Now I can analyze nearly 100% of the data and stay ahead of any undetected failure modes! I have no background in software or programming. Your video did the impossible - it taught an old dog some nifty new tricks :)
That's awesome for you man. This is one of the reasons I have a passion for tech! Just sucks very few ppl see tech that way but oh well, at least we do 😎
For multiple monitors, try to stick every UI elements in the same monitor to avoid unexpected behaviour. You can use a new virtual desktop to enforce it.
Wow, I am blown away. As a technology educator, I really appreciated how thoroughly you covered the topic, and how well you took a complex process and broke it into discrete concepts that could be easily understood by any audience regardless of their familiarity with the platform. I was already familiar with Power Automate on the web, but I wasn't aware of PAD. I can see this being extremely useful for the web QA work that I do. I would love to see more deep dive videos into advanced features of Power Automate for completing various tasks with this tool. I also really enjoyed your more subdued delivery in this video. While I like your energy, I think with longer-form videos, it's hard to keep that going for more than a couple of minutes, and some viewers may find it distracting. This felt like a quality Pluralsight or LinkedIn Learning micro course. Well done!
Finally. I've been waiting for years for Microsoft to create an app like PAD. I've had to use a mishmash of Task Scheduler, .BAT or VBS and VBA to automate the crappy small tasks that take ages to do manually. No more death by a thousand cuts.
I feel your pain, been using task scheduler with python scripts that always seem to throw a wobbler every now and then and when I have to resolve it, its not a straight forward thing
To me, the Windows automation and ui is broken. Remember when vbs was advertised? Then they cripple apps because of security concerns. They make zip files downloaded from net blocked by default, file permissions to configure everywhere, elevation prompts, file in use locks, apps prompt for enabling macros or file from untrusted source, ui changes, 32bit 64bit variant, app folder location different based on version, network mapped drives not visible in elevated process, have fun automating that mess...
Oh, did I tell you about Windows ribbon controls? Office apps have ribbon controls, but third party apps use custom ribbon menus made by other companies, some are c++ controls. This may break automation, as they are not standard. There are apps that do direct rendering in windows, you cant identify the controls, also grids with virtual mode, in which visible data is rendered on the fly as you navigate, that wont be extracted easily from an app. Apps are made in multiple languages, some have controls made in different languages in same app, will run into problems. So this automation will run nicely only with some builtin apps.
That was the single most helpful thing I have ever seen. I was thinking of automating a lot of processes as we are about to start our marketing and with photos and meta data stripping and resizing and tagging photos this will be just wonderful. There will be a learning curve but I can see how powerful this is.
Extremely instructive! I'm embarking on automating as many chores as possible in my job and this video will be the cornerstone of that effort-- thank you!
I appreciate you uploading this video, Kevin. Thank you! As an RPA developer, I'd love more such videos from you on advanced concepts in Power Automate Desktop.
I design AI and I had to understand and read human feelings to write my code, and based on this video, you seams to be going through hard times. I can see that clearly. I hope I am wrong and I wish you the best. Great Tutorials!
Sensational tutorial, clearly explained and demonstrated and skipped over areas of duplication like copying each value. This is how all tutorials should be 👍
Wow!! Just speechless. Thank you Kevin for this, I am absolutely blown away! Haven’t used power automate before but what you covered here is incredible. I am a sys admin and my mind is just thinking of how many tasks I can automate with this. Well done!
Come on sys admin) Do you even know about AUTOIT, or power of the power shell? You can actually parse files right from comand prompt. It have loops, search, variables and logic, you can extract data, pipe it from one command to another, search, take process id's, checksums, save, open etc. For short automation tasks is the best way doing job, without implement extra software. Also as admin you can instantly apply it on any machine of your network.
@@MetaJamm relax there superstar, powershell is not new and actually requires some scripting knowledge and skills, power automate is a new way to do automation without needing to know coding, and this video demonstrates it very well. You found an opportunity to show your superiority online and straight away attacked, hope your insecurities are satisfied now, you have been ackdowledged for your genius mind, salute!
This is completely amazing...with this I've just turned 6 hours worth of work (copy->paste->email x 300) into 30 mins (I could maybe cut that down even more but giving that this is new to me I want to spot check the outputs) you are AWESOME
Suggestion : You may talk about licence cost to be able to cover everything. Great video. Thank you I also prefer your previous voice style :) keep it up
Thanks for the note! I got a bunch of feedback from viewers that I spoke too much in a presentation voice, so I tried a more conversational tone, although I'm not quite sure if this is it. I'll keep experimenting to see what works the best.
@@KevinStratvert I also noticed this but thought you were just adjusting your voice to suit the microphone. In my opinion, you should find a sweet spot between this voice and the old voice.
@@KevinStratvert While different people will have different preferences, my preference is for your presentation voice. After all, you are presenting and not having a conversation while speaking in these videos.
Hi Kevin, I have quick question, I have a desktop flow that works fine if I run it manually from the power automate desktop version but if the cloud triggers the event, it gives the following error: { "error": { "code": "UIAutomation.SelectMenuOptionError", "message": "Problem while executing action 'SelectMenuOption'. Failed to select option (option wasn't found)" } } Did you see such issue before? Thanks
Thanks for the great tutorial I've got a few questions 1) when opening each Word document in the loop, what's the purpose of renaming the file? why not just simply use the "currentfile" variable? 2) why close/terminate Word when done reading data from each file, only to run Word again for the next file? I believe there's a way to close an open word document without closing the entire process. It should be noticeably faster.
Hi Kevin. Really great demo thank you. Might be worth mentioning that this is a paid licenced product. I needed to sign up for a trail to follow it. Seems like an extremely useful tool. I would love to see some videos based around SharePoint Online, also how power automate can be used with SharePoint Online. Even a video around how SharePoint online and Teams work together - I'm wondering where one stops and the other begins! Thank you for your hard work.
I know. What I did was create a trial account for E3,it lasts 90 days (as opposed to E5 which lasts 30-60 days I think). Doing that to test PAD and Power Bi
You are one of the best content creators on RUclips. By far. The speed of your narration is excellent. Plus the content is concise. I have attention deficit disorder and am slower digesting information as I am now in my 70s. I do have a question Is it possible to use Power Automate with Microsoft Office online apps?
Great video Kevin, would love to see 1) how this can be done with sending emails monthly to various recipients based on assignment names in an excel spreadsheet and 2) the web flow as well. Thank you!!!!!
Thanks for the wonderful tute. Now that Power Automate is free for all since March 2021, for this to work a) Protected View must be disabled in the Trust Center for the Word Documents b) PC might have to be restarted if it does not run the first time after modification Keep up the good work man!!
This is such a great and comprehensive video - thank you so much! I've been binging through your content since I've been working a lot more in the Microsoft environment and you've been a huge help!
i genuinely cant tell who this channel is for some videos will be like "i teach you how to plug in your mouse and keyboard" and some will be like "how to learn machine code in 20 minutes or less"
Thank you, very well documented. This feels like you stepped up and did do it for a little more advanced audience. This however is also a more complex topic, where it is good to point out that it is good to have a backup of your documents before running the PDA for the first time - in case we do a mistake :-)
Ha, yeah, this was definitely a more involved video, which is why I didn't drop one on Monday 😁 Good point on the backup... alternatively, create the extract file in a different folder so it doesn't affect the source files.
Thank you for the tutorial. Mind blowing! I have a related question: why did we need to rename all the word docs to “extract”? Couldn’t we have opened winword.exe using the currentItem loop variable, and extracted the data?
@@NilavraBhattacharya I've asked myself the same question so I tried disabling that step to see what's broken, and it turns out the UI elements capture uses the window's name (i.e. "Extract.docx - Word") as a filter to figure out where to capture. I tried variabilising this using "%CurrentItem.Name% - Word" but with no success yet. Maybe that's not something you can do...
I think one thing that needs to be called out is that you can use PAD only if you have a Power Automate with RPA license. A free or basic plan will not allow you to create Flows in the desktop app.
This is an amazing walk through. I wish more people had the skills to walk through products like this as you are not just telling us where to click, you explain why.. and that's so simple, yet so uncommon.
No it's not, it pretends it's free but visit the pricing site and you'll find there's no free version to compare. What you get is the complete edition for a trial period then it ends and you're left with a shell of the application. The kicker being they won't let you not have the premium and they won't tell you what is in the 'free' version. Shoddy, underhand marketing.
@7:22 - the Advance & Variables, has more options, you skip over ??? what is "On error" to the left of Save ??? you did not show the folder after you tested your flow? was there just one file left call "Extract" ???
I remember using scripting and Excel Macros to automate tasks, but this GUI program makes it easy for non-programmers to accomplish the same thing. Kudos to MS!
Ow... Very interesting Video.. Keep it up... Every single step has described clearly and it can be understand everyone without any prior knowledge.. Thanks a lot 👍
Great tutorial, Kevin! Quick note... I ran through this with multiple monitors and it worked just fine. Maybe the newer versions of PAD have been updated to work with multiple monitors.
Great video, Kevin, as always. Seems really useful, I'll definitely try it. You're the best 💯😎 One thing though...are you OK? You seem a little out of energy, sad even... I mean, your voice does.
Thanks for the note! I got a bunch of feedback from viewers that I spoke too much in a presentation voice, so I tried a more conversational tone, although I'm not quite sure if this is it. I'll keep experimenting to see what works the best.
That is an outstanding Tutorial. The MS documentation makes it very difficult to figure out exactly where to start and my prior attempts left me scratching my head (and without any solutions).It looks like I'll have a brief demo for Proof of Concept to show to peers and suits for using PAD to do automated testing in a couple days. Thanks!
HAHAHAH.... * "At this point I probably start looking for new work!!!"* .....I almost fell out of my chair laughing and you say it with such a straight face! Love these edutainment videos!
Thanks for the note! I got a bunch of feedback from viewers that I spoke too much in a presentation voice, so I tried a more conversational tone, although I'm not quite sure if this is it. I'll keep experimenting to see what works the best.
@@KevinStratvert hi Kevin. As far as I’m concerned, I would say keep your "enthusiastic" tone, this was your signature so to say. Speaking slower makes the video a bit "boring". Again this is my personal feeling 😬😉
Thank you so much for making this video! I recently found this PWD and I was looking for a way to learn basics. Your video was very easy to understand. I hope you make more content related to PWD in future :3
This is again amazing and extremely useful Kevin! A question though: how would you process with a form in word (or else actually) that uses check boxes and radio buttons? How to turn them in a meaning variable in excel?
Of course! Thanks for the note on the audio! I'm using the new Sennheiser MKH 50 microphone. It works very well for indoor dialogue. I also have acoustic panels on my walls and a high-ply rug which helps eliminate any echo/resound. After I record, I adjust the levels to -10 through -15 dB, apply a de-esser to remove those high pitched S sounds, and apply a compressor to remove any spikes on the audio track. All-in-all, I'm very pleased with the output.
2023 and this is still usefull, the advanced bit about dealing with files is really good. Just missing some testing so see if everything is working after each part, but this probably was adressed already after so many years. Thanks!
Great work mate!! Long term fan of ya channel, I make numerous recommendations on your videos keep ‘em coming!! Your prep, delivery, tone and examples are so good. I am finding myself watching your channel instead of Netflix 😂 Great work!! Any tips on Power Automate; (trigger) taking form response, (action) 1. generating a template PDF 2. saving to MS Team SharePoint under a folder named using a unique identifier in form. Cheers Grant 🙏
@@fantasytrain42 Fortunately she understood the situation and told Power Automate Desktop to not interfere in our relationship. I'm happy because it's not funny being singled out like that being innocent and all. Do you think I should sue Microsoft?
Thanks for the note! I got a bunch of feedback from viewers that I spoke too much in a presentation voice, so I tried a more conversational tone, although I'm not quite sure if this is it. I'll keep experimenting to see what works the best.
That's so awesome ! Never know about PAD. As I can see, this is a Graphical enhancement of Windows Batch Files. But the provision to process with UI elements is really cool !! Thanks Kevin !
Great stuff Kevin, I already started using it for Webapps after today (After using iMacros and others), would be great to have tutorials split based on desktop and webapps. One of challenges already found was, how to continue RPA process when flow continues via a popup window and not in same tab. 1000 thanks for this video.
![Power Automate Beginner to Pro Tutorial [Full Course]](http://i.ytimg.com/vi/1p5kI7SYz4Q/mqdefault.jpg)
I wonder how many people have used this to automate their whole days workflow and subsequently just show up and watch RUclips videos all day. Hehe
Getting there 😉
I hope I will one of them.
Lppllllllllllllliioyoollld
Soon
Funny you mention that cause I am soooooooo on my way. And no one in my office is smart enough to understand. Lol.
Thanks Kevin. This video (like many others you do) is a really eye opener. MS creates so many products yet fails to simply demonstrate how to use them and what benefits one can get by using them. You do a great job filling this void. Thanks a lot.
Agree with this
@@rockenOne pp00 pp 0 pop p0ppppppppp0p
MS does demonstrate how to use it. there's a video on their yt channel. just doesn't get a lot of views bc who wants to go to MS to learn about its own tools right? lolz
MS always has tutorials on how to use their apps and software, yet they may not go into depth like Kevin does.
@SHRModding People who want to learn but don't take the time are called lazy ppl lol. Just bc something is convenient doesn't mean it will be a longterm solution.
It's also worth pointing out that these automations can run in remote compute instances; you don't _have_ to run them locally. You can also initiate them from the power automate website or from within flows. It is a full RPA solution. For example, when email received, save attachment, run PAD to transfer content to legacy app, confirm entry to sender.
In your example, if mail is received and attachment is a zip file., can attachment be saved and unzipped automatically using flow.?
@@Sandeep007219 Yes, extracting zips is a standard Sharepoint action. It called Extract Archive or Extract zip or something like that.
Can't thank you enough for uploading this tutorial. I was very close to hiring an outside consultant to develop tools to analyze all the data we collect. But after watching this video I was able to develop two automation tools that allow me to process huge amounts of data. Even 3 months ago I was analyzing barely 5% of all data and essentially were flying blind. Now I can analyze nearly 100% of the data and stay ahead of any undetected failure modes! I have no background in software or programming. Your video did the impossible - it taught an old dog some nifty new tricks :)
That's awesome for you man. This is one of the reasons I have a passion for tech! Just sucks very few ppl see tech that way but oh well, at least we do 😎
For multiple monitors, try to stick every UI elements in the same monitor to avoid unexpected behaviour. You can use a new virtual desktop to enforce it.
Wow, I am blown away. As a technology educator, I really appreciated how thoroughly you covered the topic, and how well you took a complex process and broke it into discrete concepts that could be easily understood by any audience regardless of their familiarity with the platform.
I was already familiar with Power Automate on the web, but I wasn't aware of PAD. I can see this being extremely useful for the web QA work that I do. I would love to see more deep dive videos into advanced features of Power Automate for completing various tasks with this tool.
I also really enjoyed your more subdued delivery in this video. While I like your energy, I think with longer-form videos, it's hard to keep that going for more than a couple of minutes, and some viewers may find it distracting. This felt like a quality Pluralsight or LinkedIn Learning micro course. Well done!
Thanks for the note Greg, much appreciated! 👍
Finally. I've been waiting for years for Microsoft to create an app like PAD. I've had to use a mishmash of Task Scheduler, .BAT or VBS and VBA to automate the crappy small tasks that take ages to do manually. No more death by a thousand cuts.
I feel your pain, been using task scheduler with python scripts that always seem to throw a wobbler every now and then and when I have to resolve it, its not a straight forward thing
To me, the Windows automation and ui is broken. Remember when vbs was advertised? Then they cripple apps because of security concerns. They make zip files downloaded from net blocked by default, file permissions to configure everywhere, elevation prompts, file in use locks, apps prompt for enabling macros or file from untrusted source, ui changes, 32bit 64bit variant, app folder location different based on version, network mapped drives not visible in elevated process, have fun automating that mess...
Oh, did I tell you about Windows ribbon controls? Office apps have ribbon controls, but third party apps use custom ribbon menus made by other companies, some are c++ controls. This may break automation, as they are not standard. There are apps that do direct rendering in windows, you cant identify the controls, also grids with virtual mode, in which visible data is rendered on the fly as you navigate, that wont be extracted easily from an app. Apps are made in multiple languages, some have controls made in different languages in same app, will run into problems. So this automation will run nicely only with some builtin apps.
Thanks
Thanks so much Neopress! Much appreciated 🙏
That was the single most helpful thing I have ever seen. I was thinking of automating a lot of processes as we are about to start our marketing and with photos and meta data stripping and resizing and tagging photos this will be just wonderful. There will be a learning curve but I can see how powerful this is.
Extremely instructive! I'm embarking on automating as many chores as possible in my job and this video will be the cornerstone of that effort-- thank you!
Fantastic! Before I saw this video, I did not even know of Power Automate Desktop
I never regretted watching any of your videos... Your usefulness in the world cannot be measured...
This was the most useful video for a long time now. Thanks for sharing Kevin
Thanks Kevin. Especially thank you for not having pad music in the background.
I'll second that.
Yeah
I appreciate you uploading this video, Kevin. Thank you! As an RPA developer, I'd love more such videos from you on advanced concepts in Power Automate Desktop.
I design AI and I had to understand and read human feelings to write my code, and based on this video, you seams to be going through hard times. I can see that clearly. I hope I am wrong and I wish you the best. Great Tutorials!
Certainly one of the best video for anyone who wants to get started with PAD for the very first time! Good Job Kevin!
Thanks for the note Kym!
One of your best videos. You sound more natural instead of your normal computer voice. The video edits are a nice touch too.
Thanks for the note Michael!
Sensational tutorial, clearly explained and demonstrated and skipped over areas of duplication like copying each value. This is how all tutorials should be 👍
The perfect introduction for IT Pros and end users. Intro cannot be better than this. Thanks a lot kevin for taking the time to prepare the video.
Wow!! Just speechless. Thank you Kevin for this, I am absolutely blown away! Haven’t used power automate before but what you covered here is incredible. I am a sys admin and my mind is just thinking of how many tasks I can automate with this. Well done!
Come on sys admin) Do you even know about AUTOIT, or power of the power shell? You can actually parse files right from comand prompt. It have loops, search, variables and logic, you can extract data, pipe it from one command to another, search, take process id's, checksums, save, open etc. For short automation tasks is the best way doing job, without implement extra software. Also as admin you can instantly apply it on any machine of your network.
@@MetaJamm relax there superstar, powershell is not new and actually requires some scripting knowledge and skills, power automate is a new way to do automation without needing to know coding, and this video demonstrates it very well.
You found an opportunity to show your superiority online and straight away attacked, hope your insecurities are satisfied now, you have been ackdowledged for your genius mind, salute!
@@iliassoukallaris7274 This is not attack, maybe just a slightly biting) Sorry if i being offensive to much. Pease!
@@MetaJamm thanks for mentioning autoIT, wasnt aware of it but been very curious about scripting in windows for automation etc
This is completely amazing...with this I've just turned 6 hours worth of work (copy->paste->email x 300) into 30 mins (I could maybe cut that down even more but giving that this is new to me I want to spot check the outputs) you are AWESOME
Wow. This is a great video. I never knew how to create a simple flow and launch it. 6:35. Thanks. PAD is going to be very helpful in various tasks.
Thanks so much, Kevin. This is extremely helpful and gives me something new to play with.
Kevin, I must say a massive thank you, but not just for this video but for all your tutorials.
Suggestion : You may talk about licence cost to be able to cover everything. Great video. Thank you
I also prefer your previous voice style :) keep it up
The way he explained this is off the charts! Excellent job.
You sounded a little different this time. Not the usual energetic voice.
Awesome video!!
I agree with Manish. Hope you are okay Kevin. Your energy seemed low today, but great video as usual! Get some rest.
Personally, I prefer it. Not if it's because he's under the weather though :-)
Thanks for the note! I got a bunch of feedback from viewers that I spoke too much in a presentation voice, so I tried a more conversational tone, although I'm not quite sure if this is it. I'll keep experimenting to see what works the best.
@@KevinStratvert I also noticed this but thought you were just adjusting your voice to suit the microphone. In my opinion, you should find a sweet spot between this voice and the old voice.
@@KevinStratvert While different people will have different preferences, my preference is for your presentation voice. After all, you are presenting and not having a conversation while speaking in these videos.
Hi Kevin, I have quick question, I have a desktop flow that works fine if I run it manually from the power automate desktop version but if the cloud triggers the event, it gives the following error: {
"error": {
"code": "UIAutomation.SelectMenuOptionError",
"message": "Problem while executing action 'SelectMenuOption'. Failed to select option (option wasn't found)"
}
}
Did you see such issue before? Thanks
Thanks for the great tutorial
I've got a few questions
1) when opening each Word document in the loop, what's the purpose of renaming the file? why not just simply use the "currentfile" variable?
2) why close/terminate Word when done reading data from each file, only to run Word again for the next file? I believe there's a way to close an open word document without closing the entire process. It should be noticeably faster.
same questions here. I would also like to know at which steps that does the 'delete'? as original file get deleted
@@JonathanJournal In Rename File (Point no. 4) , he selected owerwrite
"Merci" Kevin. "Thanks" from Paris, France. A very useful vidéo. Excited to get new videos about PowerAutomate in the future
Hi Kevin. Really great demo thank you. Might be worth mentioning that this is a paid licenced product. I needed to sign up for a trail to follow it. Seems like an extremely useful tool. I would love to see some videos based around SharePoint Online, also how power automate can be used with SharePoint Online. Even a video around how SharePoint online and Teams work together - I'm wondering where one stops and the other begins! Thank you for your hard work.
Yes please! I'd like to join to this request. Especially now with the Lists available.
Thanks for the suggestion! I've added this to my list. Stay tuned. Cheers!
Hi! Very nicely explained. But can u tell me why we are adding "/t" before giving the file path of "Extract"?
That was so crazy! I was always looking for how to automate with python. But this one goes up to my expectation! Thanks in numbers!
Very interesting video, I was so happy to learn about this... but the fact that it does not work with personal accounts is a real bummer.
I know. What I did was create a trial account for E3,it lasts 90 days (as opposed to E5 which lasts 30-60 days I think). Doing that to test PAD and Power Bi
I don't know its exist until you post this video. Great job! Awesome!
Thanks!
Wow, thanks so much! Much appreciated 🙏
Never heard of this before. It's actually a great intro to programming logic for people with no experience in it.
That will be my use of it. I like how it breaks it down into categories.
You are one of the best content creators on RUclips. By far. The speed of your narration is excellent. Plus the content is concise. I have attention deficit disorder and am slower digesting information as I am now in my 70s. I do have a question Is it possible to use Power Automate with Microsoft Office online apps?
Great video Kevin, would love to see 1) how this can be done with sending emails monthly to various recipients based on assignment names in an excel spreadsheet and 2) the web flow as well. Thank you!!!!!
Thanks for the wonderful tute. Now that Power Automate is free for all since March 2021, for this to work
a) Protected View must be disabled in the Trust Center for the Word Documents
b) PC might have to be restarted if it does not run the first time after modification
Keep up the good work man!!
This is such a great and comprehensive video - thank you so much! I've been binging through your content since I've been working a lot more in the Microsoft environment and you've been a huge help!
i genuinely cant tell who this channel is for some videos will be like "i teach you how to plug in your mouse and keyboard" and some will be like "how to learn machine code in 20 minutes or less"
Thanks, that was a very useful introduction!
đón chờ những ca khúc tiếp theo của Phúc, càng nghe càng thích giọng ca của Phúc ❤️
Thank you, very well documented. This feels like you stepped up and did do it for a little more advanced audience. This however is also a more complex topic, where it is good to point out that it is good to have a backup of your documents before running the PDA for the first time - in case we do a mistake :-)
Ha, yeah, this was definitely a more involved video, which is why I didn't drop one on Monday 😁 Good point on the backup... alternatively, create the extract file in a different folder so it doesn't affect the source files.
Thank you for the tutorial. Mind blowing! I have a related question: why did we need to rename all the word docs to “extract”? Couldn’t we have opened winword.exe using the currentItem loop variable, and extracted the data?
@@NilavraBhattacharya I've asked myself the same question so I tried disabling that step to see what's broken, and it turns out the UI elements capture uses the window's name (i.e. "Extract.docx - Word") as a filter to figure out where to capture. I tried variabilising this using "%CurrentItem.Name% - Word" but with no success yet.
Maybe that's not something you can do...
Thanks, kevin. You explain it very well in short and crisp way!!!
I think one thing that needs to be called out is that you can use PAD only if you have a Power Automate with RPA license. A free or basic plan will not allow you to create Flows in the desktop app.
Thanks, I was coming to say that.
You can use programs like Mouse Click which can do the same. Microsoft is just late to the show
That's not true. PAD can be used stand alone. Only integration of PAD with online flows with requires a premium license.
PAD is free for all windows 10 users
@@mueez89 now it is, at the moment of the video was released it was not.
One of the best tutorials I had saw in RUclips.
This is an amazing walk through. I wish more people had the skills to walk through products like this as you are not just telling us where to click, you explain why.. and that's so simple, yet so uncommon.
Makes non-programers feel like geeks. Very good video btw. Thanks.
Looks like the recent announcement that it's basically free now will get you a lot more views of this video
Yes Jeffrey... I just came today from getting to know this big new from MS
Where is it free?
No it's not, it pretends it's free but visit the pricing site and you'll find there's no free version to compare. What you get is the complete edition for a trial period then it ends and you're left with a shell of the application. The kicker being they won't let you not have the premium and they won't tell you what is in the 'free' version. Shoddy, underhand marketing.
@@neilwalker4277 that is precisely what I thought it would be. Thanks
@@steves9250 would you mind putting that site?
@7:22 - the Advance & Variables, has more options, you skip over ???
what is "On error" to the left of Save ???
you did not show the folder after you tested your flow?
was there just one file left call "Extract" ???
Hey Kevin, thank you for putting this together! You just earned a new subscriber. 🥳
I am applying for a new job that if I have proficiency in automation, it could be an great advantage, look forward to finish this video.
Well i know where my spare time is going, great video.
I remember using scripting and Excel Macros to automate tasks, but this GUI program makes it easy for non-programmers to accomplish the same thing. Kudos to MS!
Oh wow, Kevin! Fantastic Video! Hats Off!
Boy, I'm glad you're continuing your MS related videos. Thanks a bunch!
This must be Microsoft’s answer to UIPath or any other RPA solutions out there.
Ow... Very interesting Video.. Keep it up... Every single step has described clearly and it can be understand everyone without any prior knowledge.. Thanks a lot 👍
Thanks a lot 😊
I always thought of a software like this. Didn't know they went ahead and made it.
Great tutorial, Kevin! Quick note... I ran through this with multiple monitors and it worked just fine. Maybe the newer versions of PAD have been updated to work with multiple monitors.
Thanks for confirming! It was likely a bug that's now been fixed 👍
Great video, Kevin, as always. Seems really useful, I'll definitely try it.
You're the best 💯😎
One thing though...are you OK? You seem a little out of energy, sad even... I mean, your voice does.
Thanks for the note! I got a bunch of feedback from viewers that I spoke too much in a presentation voice, so I tried a more conversational tone, although I'm not quite sure if this is it. I'll keep experimenting to see what works the best.
That is an outstanding Tutorial. The MS documentation makes it very difficult to figure out exactly where to start and my prior attempts left me scratching my head (and without any solutions).It looks like I'll have a brief demo for Proof of Concept to show to peers and suits for using PAD to do automated testing in a couple days. Thanks!
HAHAHAH.... * "At this point I probably start looking for new work!!!"* .....I almost fell out of my chair laughing and you say it with such a straight face! Love these edutainment videos!
You changed your voice and pace ?
This sounds a bit less enthusiastic than before :-(
But content is great as always !
Thanks for the note! I got a bunch of feedback from viewers that I spoke too much in a presentation voice, so I tried a more conversational tone, although I'm not quite sure if this is it. I'll keep experimenting to see what works the best.
@@KevinStratvert hi Kevin. As far as I’m concerned, I would say keep your "enthusiastic" tone, this was your signature so to say. Speaking slower makes the video a bit "boring".
Again this is my personal feeling 😬😉
I like the conversational tone. I can’t stand listening to a computer voice
Thank you so much for making this video! I recently found this PWD and I was looking for a way to learn basics. Your video was very easy to understand. I hope you make more content related to PWD in future :3
This is again amazing and extremely useful Kevin! A question though: how would you process with a form in word (or else actually) that uses check boxes and radio buttons? How to turn them in a meaning variable in excel?
Check boxes can write true or false in chosen cell, you can use that.
Thank you so much for the requested video. Your audio quality has improved dramatically, I presume you are using your new Sennheiser Microphone?
Of course! Thanks for the note on the audio! I'm using the new Sennheiser MKH 50 microphone. It works very well for indoor dialogue. I also have acoustic panels on my walls and a high-ply rug which helps eliminate any echo/resound. After I record, I adjust the levels to -10 through -15 dB, apply a de-esser to remove those high pitched S sounds, and apply a compressor to remove any spikes on the audio track. All-in-all, I'm very pleased with the output.
This is one of the greatest things that ever happened
2023 and this is still usefull, the advanced bit about dealing with files is really good. Just missing some testing so see if everything is working after each part, but this probably was adressed already after so many years. Thanks!
Hey
Please make a video on how to use Microsoft Azure 🙏🏼🙏🏼🙏🏼
Thanks for the suggestion! I've added this to my list. Stay tuned. Cheers!
@@KevinStratvert Great! I would have suggested this if I didn't see this comment.
0:02 - Hi Kevin! 👋
37:11 - Definitely a thumbs up from me, so 608th like from me! 👍
37:25 - Really enjoyed it! ☺️ Bye and cheers!
Incredible!
This was a great demonstration of power automate tools! Thanks!
@26:55 "Copy as Path" !?! How did I not know this was a thing!?
Great work mate!! Long term fan of ya channel, I make numerous recommendations on your videos keep ‘em coming!!
Your prep, delivery, tone and examples are so good. I am finding myself watching your channel instead of Netflix 😂
Great work!!
Any tips on Power Automate; (trigger) taking form response, (action) 1. generating a template PDF 2. saving to MS Team SharePoint under a folder named using a unique identifier in form.
Cheers Grant 🙏
kevin did u change your map. It sounds different
Thanks Kevin, you teaching in a didactic way.
Also make a video on how to use Microsoft access and what's the use of it
I have 365 but I never use access
Video on Microsoft Access is landing in an hour and a half 👍
@@KevinStratvert thanks for remembering and thank you for the video
Every time you are bringing a interesting topic
That's made me not to skip your videos.
Thank you kevin...
My wife thought I was cheating on her but as I explained to her it was *clearly* Power Automate Desktop who wrote those flirtatious emails on its own.
Hahaha
And did the divorce papers arrive by automation
@@fantasytrain42 Fortunately she understood the situation and told Power Automate Desktop to not interfere in our relationship. I'm happy because it's not funny being singled out like that being innocent and all. Do you think I should sue Microsoft?
Effectively explained, you have left no stone unturned, thank you so much for the tutorial.
Cool, we did this at IBM on 3270 terminals in the 80's.
Bloody h3ll! This is amazing! Thank you very much.
you sound different now. i just watched your videos last month.
Thanks for the note! I got a bunch of feedback from viewers that I spoke too much in a presentation voice, so I tried a more conversational tone, although I'm not quite sure if this is it. I'll keep experimenting to see what works the best.
@@KevinStratvert hope your doin' good. keep up the good work Kev. we have a lot of things to discover hehe
That was a brilliant example of practical use of PAD
so handsome this guy
That's so awesome ! Never know about PAD. As I can see, this is a Graphical enhancement of Windows Batch Files. But the provision to process with UI elements is really cool !! Thanks Kevin !
"The Greatest Commandment" Illustration by Ethan Ajo.. I liked the way the child use drawing and animation in his comics.. check it out..
Simplified Best Tutor ever
Wow... This is just insane man... Hats off to you..
Extremely Helpful, It opens up the mind that what we can do in terms of automation.
This was truly excellent Kevin. Everything I needed to know in one place.
game changer! This looks like a seriously powerful tool. Great tutorial Kevin - thanks
Power Automate is so much more than I thought it was!!, thanks!. My head is spinning with ideas.. power automate, AHK, powershell, etc.
@24:40 - why rename, can't you just use the currently just open word instance to extract the needed fields/records/info ???
Very Helpful and easy to understand. Thanks a lot Kevin
Super helpful. A power automate gateway tutorial would be awesome! :)
Noted!
Great stuff Kevin, I already started using it for Webapps after today (After using iMacros and others), would be great to have tutorials split based on desktop and webapps. One of challenges already found was, how to continue RPA process when flow continues via a popup window and not in same tab. 1000 thanks for this video.