Power Automate Beginner to Pro Tutorial [Full Course]

[@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!

[@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.

[@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 :)

[@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.

[@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?

[@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

[@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.

[@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

[@juanjogamon]

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

[@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!

[@margaretlopez2195]

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

[@PragmaticWorks]

You are welcome!

[@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.

[@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!

[@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

[@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!

[@RoeGabriel_i_EMPOWER]

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

[@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!

[@jankovicmisa]

Thanks for creating and sharing

[@PragmaticWorks]

No problem!!

[@fjcoughlin]

Great teacher, great pace. Thx

[@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!

[@mlhtest5928]

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

[@samanthashi552]

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

[@vigneswaranj8415]

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

[@007lbp]

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

[@PragmaticWorks]

Awesome, thank you!

[@mikewebb6019]

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

[@mahendrabiradar380]

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

[@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.

[@oconnoradrian]

Thank you, that was a great intro to Power Automate

[@bhaskey7]

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

[@torresxavier]

Thanks a lot! I cannot access the document presented in the video. Can you share the presentation? Thanks again!

[@desktopdatacrunching4032]

Check the video description for the file downloads.

[@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!

[@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!

[@cindyfan7662]

This is an amazing course!

[@mrkraymnd]

This is fantastic - thank you for publishing

[@PragmaticWorks]

Glad you enjoyed it!

[@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.

[@vikramnanda2833]

You are giving so much knowledge Hiw can we use it effectively

[@desktopdatacrunching4032]

Try some of the example for yourself! Practice is always the best way to learn.

[@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!

[@srinivasCollection]

Awesome training

[@PragmaticWorks]

Glad you enjoyed it!

[@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!

[@natiekroukam4382]

Hello from Alberton, South Africa

[@indranijayakody3381]

Really good video to start learning . Thank you very much

[@nairobi203]

awesome training. Lots of contents. Learnt a lot.

[@nelsonxaxa5323]

Amazing session

[@Stoy-boy]

I am looking for a way to create a tool which automatically takes employees' information from our company's intranet (which is SharePoint-based) and inserts the data into table cells in a Word template in order to build what we call a team sheet. Let's say that I want to create a team sheet listing two employees: Mary Jones and John Smith. Mary and John have their separate pages on our intranet which contain their photos, names, job titles, phone numbers and email addresses. Is there any way I can get the tool to locate Mary's page on the intranet, insert her photo into one table cell, insert Mary's name, job title, telephone number, cell phone number and email address into the next cell, then do the same for John? Thank you so much. 💕

[@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!

[@santoshmanellu7780]

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

[@davidthornton2788]

Brilliant course, thank you

[@francescjuliana888]

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

[@PragmaticWorks]

Glad you found it helpful :)

[@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

[@mqp414]

This training is very helpful. Thank you so much.

[@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)

[@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!

[@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!

[@medhatragab1943]

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

[@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!

[@sabarinathanthangaraj8681]

Excellent Sir!

[@nagautube1]

Great content and thanks to you and ur team

[@MundazMawanga]

Great tutorial, thanks so much!

[@PragmaticWorks]

You're very welcome!

[@eutitiaj]

Amaizing !!! I learn a lot. Thanks

[@PragmaticWorks]

Glad it was helpful!

[@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!

[@srimanthn7752]

Excellent explanation

[@ssomtom]

Very informative. I need some sintax for the name of attachment in compose trigger but it is not offered in the dynamic contents part. Any idea from sy?

[@Jahspecs1]

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

[@MatheusSouza-yh5yj]

Can I use Power Automate to automate reading data from an Excel spreadsheet and fill in this data on any website? If not, what criteria can I use to evaluate whether the website supports automation?

[@desktopdatacrunching4032]

Yes, you can do that with a Desktop flow.

[@supunsharada7759]

This is outstanding.

[@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.

[@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

[@breadandcheese1880]

Great training Team! Thank you so much!

[@HerskinMeycauayan]

Sir, I have a question, timestamp: 27:19, why did I received an error while signing in? It says that the error is create and authorize OAuth connection failed. How do I fix that?

[@zubaydee]

Really AMAZING lesson, thank you so much. I have a problem I hope someone can help me to fix it, every time I add an action and after filling the second value, the “Apply to each” places automatically to the action and that will makes the action looping. Please help!

[@taniag3975]

Great Vid! I have been trying to get my flow to work but each time i send the email the dynamic content is blank. I am not sure how to fix it as everything is correct within the flow. Can you please help?

[@thegodfather5597]

Great tutorial, thanks very much. Can I pls know which Whiteboard software you are using for your tutorial? Looks very professional! Thanks

[@desktopdatacrunching4032]

It's called Zoomit

[@thegodfather5597]

thanks very much! Just downloaded and started using it. It's a great tool!!!

[@hemantbasaiwala8541]

Very Good Session.. Three Cheers for Jonathan.

[@PragmaticWorks]

Glad you enjoyed it!

[@TheMeanor]

Awesome video, thanks!

[@PragmaticWorks]

Glad you liked it!

[@pvksmaheeth8816]

at 31:01 when i click test it is asking me to enable the flow to continue testing. where should I enable I'm tired of searching

[@dannyhsu5612]

hi Devin, Thanks so so much for this training! ITS SUPER HELPFUL! I have a question for you, not related to this training itself, but I wanted to know what software and tool are you using to annotate your screen by drawing the squares, the arrows etc... i.e. at 45:14 mark. Thanks so much in ADVANCE!

[@desktopdatacrunching4032]

It's called zoomit!

[@itexperience]

@1:37:55 Can't you add another action beforehand to harvest emailadresses of an AAD group, and then use a variable to insert those email-address?

[@desktopdatacrunching4032]

You could be then there'd be a few more actions needed to make it into a semicolon separated list. If you don't do that then you'll need to loop over the approval action for each email in the variable.

[@NickWindham]

Great tutorial video!

[@PragmaticWorks]

Glad you liked it!

[@allyeatworld]

Do you have a full course just like this for Power Apps (esp Canvas Apps) please? I can't find it on your youtube channel!

[@megabuilds3007]

Thanks, great video for the beginners. Doubt is, How to dynamically give the variables in desktop flow you have shown? For example we have Invoice details in excel/sharepoint list. So it has to get details from there and fill in the application?

[@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.

[@Kimwenman]

You have done enough for me in this great course, however, I have a small issue I am unable to figure out. I have made an approval cloud workflow, and the only issue seems to be the dynamic content. I have tried File Id, File name encoded, file path encoded, file etag, content type, file content - and always get an error in the link that it puts in the email. Is there something I am missing? I feel like I have tried so many options and watched other videos, which all seem to match yours -so not sure what I am missing. Looking for your assistance.... thank you again - this was an amazing course.

[@PragmaticWorks]

Hi Kim, It's a little difficult to troubleshoot in the comments here. If you'd like to discuss further it's probably best to look into our Virtual Mentoring service. pragmaticworks.com/virtual-mentoring/

[@MrYdoineedthis]

My first thought always is an invalid character in the file name path. Try running again without any special characters if possible.

[@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.

[@danlop_2023]

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

[@gabrielatemporale8693]

Fantastic course! Can Power Automate work with applications through Remote Desktop? Thanks a lot! The RPA in a Day course in Pragmatic Works web is also amazing.

[@desktopdatacrunching4032]

Hi Gabriela, I haven't done this myself but it does seem possible. docs.microsoft.com/en-us/power-platform-release-plan/2020wave1/power-automate/run-ui-automation-scripts-virtual-machines

[@UKJ28]

this video is 2 years old. i just wanted know if this is relevant today also or there have been changes in power automate after this video?

[@siyasangasigila7587]

Good day. We have a people picker field that allows multiple values. If ten people are selected on that field, how do I send an email to all ten people using Power Automate? Thank you

[@ahmedaiad3372]

well said Bro, You 've said every thing

[@JunedAhmed-rs2hb]

Hello, I have created a scheduled flow that runs monthly. I have two excel file in SharePoint, and I created the flow that will pull data from one excel file (let's say Excel 1) and paste the data to ther excel sheet (Excel 2). So, my flow is : Recurrence>List rows in a Table> Add a row in a Table. So for the very first month (January), it runs well, however when my flow runs for February, it also pulls January data again along with February data. How can I stop getting the data that is already pulled by the previous run? Please help me out.

[@wachhagottoday]

How do I get the Contoso Invoice application ?

[@leonardostreit3527]

Wonderful lesson! Tks

[@PragmaticWorks]

Glad you enjoyed!

[@autoshowoff3522]

Is it possible to create BigData - Presto with Custom connector?

[@desktopdatacrunching4032]

I'm not familiar with that specific data source but if there's an API you should be able to build your own.

[@brancaypinky]

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

[@Perrymatt1973]

Great video i was wondering if you can help, i cannot add yammer into my Sharepoint because of work restrictions, but i am trying to create a flow that posts a new feed onto a page in sharepoint from either a SP list or Microsoft forms, as an alternative to using the yammer chat app as people can then comment on the news/chat there. thanks

[@amoltejankar]

Can I create the internal web application in power automate like Physical inventory Management (Warehouse) web application

[@ms58755]

Hi Kevin, I want to schedule email from sharepoint and want to attach latest file only, how to do it, kindly guide, thanks

[@TrassBI]

This was very useful session. Thanks for sharing👍

[@PragmaticWorks]

Glad it was helpful!

[@gunapalani5580]

Can any help me with how to write an expression for adding serial Number if a new row is added in table while extracting outlook mail details

[@rashimalhotra8642]

Hi, should we create unmanaged solution for storing all power automates in Production? Our company don’t want to wait for patch deployments each time. Will it have any impact?