Power Automate Beginner to Pro Tutorial [Full Course]

UPDATED 2024 VERSION AVAILABLE HERE: kzbin.infoKsgxDz-nY_I
Power Automate is an automation tool designed for Citizen Developers to build and automate workflow processes in the cloud and/or on-premises. The ultimate goal of Power Automate is to give you back time. Time that you would have normally spent performing tedious tasks can now be automated, allowing you to focus more on strategic work that makes a bigger impact to your organization.
What You’ll Learn:
• Understanding Flow Triggers
• Creating Flows with Conditional Logic
• Designing Approval Flows
• Building RPA solutions with Power Automate Desktop
• Power Automate Administration
Prerequisites: (to follow along or review later)
✔️ Download student files - share.hsforms.com/17ZL_zaTHQ5...
After you finish this course:
📄 If you have completed this class and would like a certificate, fill out this form - share.hsforms.com/1GSWimWnKTe...
0:00 Intro
19:47 Using Power Automate Templates
35:20 Creating a Power Automate Flow from Scratch
56:24 Using the Condition Action in a Flow
1:12:04 Best Practice Using Trigger Conditions Instead
1:26:41 Pragmatic Works Training Offerings
1:31:04 Approval Flows
1:46:44 Power Automate Desktop Flows
2:12:55 Adding Variables to Desktop Flows
2:39:12 Running Desktop Flows Inside Cloud Flows
2:49:48 Using Solutions
👍 If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Devin30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - pragmaticworks.com/pricing/
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: prag.works/lwtn-trial
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/

Let's connect:
✔️Discord: prag.works/yt-discord
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️KZbin: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
Email: [e-mail]
#PragmaticWorks #DevinKnight #Training #Microsoft #PowerAutomate #BusinessAutomation #Microsoft #MicrosoftFlow #Flow #FreeConference #LearnWithTheNerds
**Any sale mentioned in the video are no longer valid. Offers are subject to change with/without notice and are for a limited time only.
~-~~-~~~-~~-~
Please watch: "(275) Free Pragmatic Works Power Apps Component Library "
• Free Power Apps Compon...
~-~~-~~~-~~-~

[@PragmaticWorks]

NEW UPDATED 2024 VERSION AVAILABLE HERE: kzbin.infoKsgxDz-nY_I 👉 Important files: ◉ Download student files - share.hsforms.com/17ZL_zaTHQ5mPrn5Kd80-Uw8xue ◉ Certificate of Completion - share.hsforms.com/1GSWimWnKTemack2Up7PY9g8xue

[@HippieP629]

Hi. Thank you so much for the video. I filled out the form to get the student files and contoso but I don't see the contoso .exe in the zip file.

[@cdunsford]

This course is helping me solve a real world issue where I need to create MS Planner tasks for assignment to PMs, Engineers, and Trainers when new projects are initiated. Thank you for this public service!

[@PragmaticWorks]

Glad we could help!

[@DaRkPlUm]

Even though I am a beginner, I knew alot of what was contained in the course already. However, if anyone is reading comments before committing 3 hours I do want to say that I wish I found this video sooner, as I would have learnt everything I did much faster. Devin does a really good job of explaining some basic uses of Power Automate and any self-respecting tech head could find dozens of flows to mix and match to make work easier on these basics alone. Thanks for the video Devin and everyone else at Pragmatic Works :)

[@PragmaticWorks]

Thank you for your kind words! We are glad you enjoyed this Learn With The Nerds.

[@sahilk4528]

Pane '👉 Power ... - KZbin - Brave'

[@sahilk4528]

Pane '👉 Power ... - KZbin - Brave'

[@DianaNosorog]

Even though I am a beginner, I knew alot of what was contained in the course already. However, if anyone is reading comments before committing 3 hours I do want to say that I wish I found this video sooner, as I would have learnt everything I did much faster. Devin does a really good job of explaining some basic uses of Power Automate and any self-respecting tech head could find dozens of flows to mix and match to make work easier on these basics alone. Thanks for the video Devin and everyone else at Pragmatic Works :)

[@morowar666]

started yesterday to play with power automate, now even there is a new kind of flow, describe flow, that you pretty much ask what you want to do and suggest a flow. What a time to be alive.

[@varadarajans3527]

Absolutely loved the session. Came in with no idea about power automate and you did a pretty good work to the beginner in me. More power to you Devin!

[@PragmaticWorks]

Happy to help!

[@stephenuk6490]

I can't believe I just sat through a 3 hour video, voluntarily....I was glued to the screen. I learnt so much, it was easy to follow and understand. Also by not editing out the mistake (which of course was by design 😏) perfectly explained how to correct such things. I wish I had watched this before I started trying to set up Flows way back, it would have saved me soooo much time.

[@Jahspecs1]

I absolutely love your classes! You are a master teacher! Thanks so much!

[@brancaypinky]

This video is absolutely brilliant !! Very well explained, straight to the point. Great job !

[@pw.70]

This has been a tremendous help in getting me up to speed with PA. It's not intuitive at all. Thanks for putting this together - top chap!

[@samanthashi552]

The best Power Automate video I have seen so far. Thanks for that.

[@fuzzywuzzy318]

i completed your first 3 part of courses, i will try to finish all of rest tmr, it's really intuitive and detailed and you are talented at teaching new knowledge to beginner, thank you for made this video and made it free

[@SaltAndVi]

This is so damn cool. It's programming with a GUI. Debugging, variables, functions, WOW! I am absolutely blown away. And the teacher here is wonderful.

[@PragmaticWorks]

Glad you enjoyed! Thanks for watching.

[@MrYdoineedthis]

Good pacing, like layering on the lessons learned and accelerating as the presentation continues. Also enjoyed using the proper terminology, introducing them and then relying on them later on. Very nice.

[@PragmaticWorks]

Glad you liked it!

[@davewood9199]

Melanie said it well, so I will first quote her... "Honestly one of the best online course videos I've come across. ... I'm subscribed to this channel now! Wish I had seen it sooner. Thanks for creating this course!". I look forward to discovering more great learning experiences via this channel and the team of trainers behind it. I also am glad you mentioned the option of Virtual Mentoring. I can imagine getting to points with the systems I am developing where such a resource will be of great value.

[@PragmaticWorks]

Glad to hear you are enjoying our content!

[@durgaprasad5488]

do we need to pay to get certificate?

[@suddengun007]

Awesome video guys! Some things finally clicked for me and now I am excited to automate myself out of a job lol! I am going to keep you mind in case my org ever needs some specialized help.

[@melanietoups5504]

Honestly one of the best online course videos I've come across. I learned more from this one video than from 2 weeks of trying to get through a Power Automate course with a paid online education subscription. I'm subscribed to this channel now! Wish I had seen it sooner. Thanks for creating this course!

[@desktopdatacrunching4032]

Thanks Melanie!

[@Lightyagami-tx2xb]

@@desktopdatacrunching4032 your welcome

[@InsightfulJourney123]

Wow 😮 I just found this course! I feel so lucky this show up on my recommendation list. Very well explained! Thank you, Sir!🙏

[@PragmaticWorks]

Glad it was helpful! Thank you for watching!

[@santoshmanellu7780]

Good session - upto the point , precise and high energy session keeps the audience intact and interested. Thank you...

[@vigneswaranj8415]

Thanks, Devin. Really we learned some real-time automation use cases...

[@sonjaboes3138]

Thanks for this video. I'll try working with the information given and might sign in for a course to learn how to automate business processess properly. As a beginner, I'll have to learn more first. This was a good start. Thank you!

[@Cruz0e]

You explain very well, clear, detailed enough (not too), always doing great references, keep it up! You are the best! I am glad I found your video, I learn't a lot from your Ms Access videos in the past. (I finished my course with distinction, I created a nice database to organize poker sit and go and MTT tournaments). I finished an UiPath RPA developer course, but we are still in a year traineeship now, working with clients but once a month we do training, and so to make us learn various tools, we are learning Power Automate too (the school plans to pay for a PL500 exam too for us to get cert)... I got your Cert already :) for start.

[@rohitjoshi3301]

Such a great quality material. It was my first tutorial for power automation and still the best one.

[@PragmaticWorks]

Great to hear! Thanks for watching!

[@fingerprintinit]

Very great content for people who are totally new to this tool and need a good knowledge from beginning, gives overview and details about its capabilities and areas of use, thanks

[@PragmaticWorks]

Thank you for watching!

[@zachariahbauer6576]

1:09:30 you gotta love these guys. I used to just quickly scroll through their videos and attempt to pull out what I needed. That sort of worked, kind of like Enron’s accounting practices did until, well until they didn’t. Thanks for helping make our lives easier and this content more digestible.

[@nelsonxaxa5323]

Amazing session

[@juanjogamon]

Very good course. The teacher is very knowledgeable and has excellent communication skills. I recommend it. Congratulations.

[@mlhtest5928]

Great content, thanks for taken the time to do so!

[@mrkraymnd]

This is fantastic - thank you for publishing

[@PragmaticWorks]

Glad you enjoyed it!

[@ultimopenguin7]

BETTER EDITOR with EXPERIMENTAL FEATURES?! 🥇 Tidbits of info like that are exactly why I watch these long videos that otherwise I'd skip, or training that may seem irrelevant or of a more beginner level. Almost let that ego get in my way, haha. Thank you so much for this detailed video!

[@PragmaticWorks]

Thanks for watching!

[@breadandcheese1880]

Great training Team! Thank you so much!

[@margaretlopez2195]

I am a beginner and was able follow this session. Thank you very much.

[@PragmaticWorks]

You are welcome!

[@francescjuliana888]

Tutorial very useful. Great work. You have the ability to speak quick and being understood.

[@PragmaticWorks]

Glad you found it helpful :)

[@jehbosheva]

There's a lot of learning in one sitting! Kudos! I was wondering if the same process goes when you want to create a Calendar Event after an action set to "Approve" from a Trigger List. Most online lecture show an email receive after the Approve, but what if the Approver not only wants to receive an Outlook email but want to update his/her calendar. That would be amazing. Thanks again!

[@007lbp]

Great Session. Im from Brazil and im a big fan from Pragmatic Works.

[@PragmaticWorks]

Awesome, thank you!

[@bhaskey7]

I am going through your lectures, very helpful. Thanks a lot for sharing your knowledge with us.

[@mqp414]

This training is very helpful. Thank you so much.

[@gustavopineda7933]

I enjoyed this course , It was pretty useful cuz I didn't know a lots things that will improve my flows. Thanks a lot . 👍

[@PragmaticWorks]

Thank you for watching!

[@mahendrabiradar380]

Thank you so much for this video. this has made Power automate easy now :)

[@JamieTorontoAtkinson]

I would definitely recommend this company. I’ll be using their services in the future great work guys keep it up!

[@PragmaticWorks]

Thanks so much for watching!

[@TrassBI]

This was very useful session. Thanks for sharing👍

[@PragmaticWorks]

Glad it was helpful!

[@davidthornton2788]

Brilliant course, thank you

[@Anandvyshnavi]

It was à superb session that we have learnt good information .

[@PragmaticWorks]

Glad to hear that

[@oconnoradrian]

Thank you, that was a great intro to Power Automate

[@MrFrankcoughlin]

Great teacher, great pace. Thx

[@vaibhavilohani3421]

Thank you so much for this great tutorial!

[@sathiya4516]

Hi Devin, Thank you for this wonderful session, I am really enjoyed and interesting on your mentor. I am really admire of your speech. Thanks again!

[@PragmaticWorks]

Glad you enjoyed it!

[@cindyfan7662]

This is an amazing course!

[@eutitiaj]

Amaizing !!! I learn a lot. Thanks

[@PragmaticWorks]

Glad it was helpful!

[@mketkee]

Superb video! Many thanks!

[@nairobi203]

awesome training. Lots of contents. Learnt a lot.

[@stevemcc7208]

Great video. I am a power automate rookie and this is a great help. thank you! If I could ask a question - I have a Shipping Request form issue. PHASE 1: The user fills out the request for items to be shipped by the warehouse. The user receives a confirmation email that it was sent to the warehouse. PHASE 2: The warehouse completes the shipping and another confirmation email should go to the user when the form is set to "SHIPPED" I can't get the second phase email to work. (it just sends 2 emails at the same time, the second has not waited or reacted to the warehouse action)

[@indranijayakody3381]

Really good video to start learning . Thank you very much

[@supunsharada7759]

This is outstanding.

[@sabarinathanthangaraj8681]

Excellent Sir!

[@nagautube1]

Great content and thanks to you and ur team

[@medhatragab1943]

Thank you very much.. You gave me a good starting point to lean

[@RoeGabriel_i_EMPOWER]

This is the best video on learning power automate from scratch. Do you guys do any consulting work?

[@hemantbasaiwala8541]

Very Good Session.. Three Cheers for Jonathan.

[@PragmaticWorks]

Glad you enjoyed it!

[@TaraCotz]

I managed to create a flow which downloads attachment from emails to one drive. But I need to be able to convert the format of the file whe it gets saved using the flow. The files are sent through a broadcaster in SAP P10 as XML spreadsheet 2003 format and I need it in excel format in order to compress the size and make it compatible with power query to do my actual task. My question is, is there a way to use power automate or desktop automate to download the attachment as a desired format?

[@ahmedaiad3372]

well said Bro, You 've said every thing

[@leonardostreit3527]

Wonderful lesson! Tks

[@PragmaticWorks]

Glad you enjoyed!

[@2007pradipta]

thanks Devin for qualitative training. Can we have completed guide and real time example of Licensing of Power Apps and Power Automate ? As Licensing quite complex in this.😀

[@ravvenhawk1110]

Hello sir, thank you very much for your efforts, I have a question if I may, you mentioned that we should take our hand off the mouse and let the flow run, that way we will not interact with the flow, (I am talking about the desktop process) my question is, it possible to run the flow AND minimize the power automate desktop software so I can work on other stuff? Is that possible? Thanks again. Cheers

[@srimanthn7752]

Excellent explanation

[@asaadAI]

Great content! thank's

[@lynn7140]

Thank you for your sharing.

[@srinivasCollection]

Awesome training

[@PragmaticWorks]

Glad you enjoyed it!

[@trinhtri6608]

The content is great. The right video which I want to find for learning. thank so much

[@PragmaticWorks]

Glad it was helpful!

[@trinhtri6608]

@@PragmaticWorks I wish I know your channel sooner. Thanks

[@SiyamandRashid]

Thank you very much for this great video, I have a question plz: can we do an approval in away that both requester and approver receive a pdf file with their signature ? For example i have a paper travel request i want after approval by the supervisor i receive a pdf travel request paper with the approval signature

[@MundazMawanga]

Great tutorial, thanks so much!

[@PragmaticWorks]

You're very welcome!

[@barbarasanchez1560]

Thank you!! Very helpful information ;)

[@PragmaticWorks]

Glad you liked the video! Thanks!

[@natiekroukam4382]

Hello from Alberton, South Africa

[@doniaelfouly4142]

very informative , thank you

[@Resciacastro1]

Great content! I would love to know what tools you use to dynamic change between screen, turning on/off your camera in the presentation and type in the screen. Thanks in advance!

[@babi8071]

Thank you very much, really helpful!

[@PragmaticWorks]

Thanks! Glad you enjoyed!

[@theodejong1123]

Hi Devin, Thanks for the video! Very helpful. I have got quite a specific question, I hope that your knowledge about Power Automate is sufficient for this case. I have a lot of Word documents, that contain bookmarks. These bookmarks have to be turned into Quick Parts in order for SharePoint to read them and auto populate rows. Any idea on how to automate this?

[@luisbarbosa5597]

u are da future, ma man

[@mikewebb6019]

Hi great video. Question: what’s the red arrow & box tool you are using for the presentation? Thanks for sharing!

[@LiveLife378]

@bDevinKnight I would really like to take a power automate advance or regular bootcamp with you. I enjoy your teaching style more than I do some of your other trainers on staff.

[@TheMeanor]

Awesome video, thanks!

[@PragmaticWorks]

Glad you liked it!

[@RomuloMagalhaesAutoTOPO]

Cool. Thank you.

[@PragmaticWorks]

Our pleasure!

[@efeigbowe891]

Very fantastic lesson sir. I have a question . When passing in your dynamic variables in the desktop flow, I noticed that you didn't show a way we could dynamically input different data for the invoice. Like we had the same company name and figure each time the flow ran

[@gauravk1987]

Hi Devin, Thank you for this helpful video. My question is whenever a user account password is reset , the power automate flow running on that account starts failing and we have to reauthenticate. Is there any way to handle that? not sure if its a token issue. I read somewhere that we can turn off the expire token setting but couldn't find it.

[@parranoic]

My advice for anyone starting with power automate that want to learn fast is to do as many real world projects as possible, when starting a project test the outputs of your actions and save often, google is your friend don't try to reinvent the wheel, it's a buggy platform and a real pain to work with but it can also be really rewarding

[@samuelmyanga1587]

I repeat This Men is amaizing ......he is the best educator :)

[@PragmaticWorks]

Glad you enjoyed!

[@NickWindham]

Great tutorial video!

[@PragmaticWorks]

Glad you liked it!

[@shubhampawar8506]

Great video❤

[@gandgcreations]

Thanks so much, really helpful. I have a question, can you use the Power Automate desktop, and automate a flow using a cloud based application or application that resides in the internet, Do you just populate the URL to access the app and the rest is the same?

[@rrrvvvv4940]

Hello. Thank you very much for teaching. But if I want to follow along and want to do the first flow I need to have 365 outlook and Teams? What office package do you recommend?

[@tabishwani1612]

Well Explained

[@danlop_2023]

Knight, that must be one of the best family names for a man in existence.

[@qtronicqilt8898]

Thanks, QQ.

[@joelancaster203]

Love the session really helpful. Do you run any sessions/courses on emailing SQL data? I would like bring in Sql data and mail it as a HTML within the body. Or would anyone here know where i might find a tutorial on this subject?

[@isaiah53_1]

Thank you so much 🙏🏽

[@PragmaticWorks]

You are so welcome

[@thanhthule4564]

Thank you David for your informative course. Could I please ask for the link to reference guide for fomula language for power automate (document library for power automated expressions). Thank you!

[@seedrocmedia]

This is great. Thanks for being generous enough to give it out for Free, much appreciated. One question though - I'm using MacBook Pro, and was not able to Install the Power Automate Desktop on my system, is there a work around for this, or the Mac users should forget about using the Desktop version? Thanks.

[@Greg-rw5xq]

Hi Devin, Excellent content - I've just discovered you today. My question regards data privacy and security. Since all of this information is stored in a (Microsoft controlled?) cloud, how do we as businesses ensure that our data is secure? I don't see any encryption efforts unless it is something I've missed elsewhere? Essentially we could be sharing all sensitive documents and CRM data with Microsoft using these tools, is that correct?

[@tlc4417]

Does power automate support file sharing? I want to create a data driven subscription and for each record in that dataset a report file is generated and drop this to a file sharing folder or our nas/unix folder.

[@anelenoroita]

Hi, Thanks for this amazing video you really helping us improve everyday. Just a question: Is it possible to extract Polly responses on Teams and send them to a SharePoint list using Power Automate, can you please suggest some logic if there's a way to achieve this. Thank you

[@musicislost]

What is the best way to power automate an approval than after approval it goes to a specific user handling that approver. I have two employees that only want to be notified if its their team requesting an item.