Power Automate Beginner to Pro Tutorial [Full Course]

Поділитися
Вставка
  • Опубліковано 29 вер 2024

КОМЕНТАРІ • 280

  • @PragmaticWorks
    @PragmaticWorks  2 роки тому +25

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

    • @HippieP629
      @HippieP629 Рік тому +1

      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.

  • @ultimopenguin7
    @ultimopenguin7 2 роки тому +2

    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!

  • @MrYdoineedthis
    @MrYdoineedthis 2 роки тому +2

    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.

  • @bhaskey7
    @bhaskey7 6 місяців тому

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

  • @cindyfan7662
    @cindyfan7662 Рік тому +1

    This is an amazing course!

  • @cdunsford
    @cdunsford 2 роки тому +47

    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!

  • @nurudeenadebimpe5230
    @nurudeenadebimpe5230 9 місяців тому

    Greetings from Nigeria

  • @2007pradipta
    @2007pradipta 2 роки тому

    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.😀

  • @megabuilds3007
    @megabuilds3007 11 місяців тому

    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?

  • @efeigbowe891
    @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

  • @HandsOnRealEstate
    @HandsOnRealEstate Рік тому

    Would this be useful for an Apple user ?

  • @taniag3975
    @taniag3975 7 місяців тому

    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?

  • @ms58755
    @ms58755 Рік тому

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

  • @patrick__007
    @patrick__007 Рік тому

    Just watched your video since I am new to Power Automate. Great video. I do have one question about the Teams URL which you included in your "Send MS Form Registration" flow. Where did you grab that from? I saw you copying and pasting the e-mail content..

  • @rok1475
    @rok1475 2 роки тому

    Why is it that so many experts can talk for hours what the thing can do and what the thing is made of but completely unable to succinctly describe what that thing is ?

  • @SAMEENAAFROZABLE
    @SAMEENAAFROZABLE 2 роки тому

    What would be the step for Forms that are shared with you but your are not the owner? how would i be able to use historical items available to me ?

  • @ursnandal
    @ursnandal 2 роки тому

    How to copy and paste Website URL link from already opened websites in multiple tabs of Chrome into Excel row?

  • @Lennings82
    @Lennings82 Рік тому

    hi.
    Is it possible to use one sql output in another sql?
    like SELECT * FROM %query%

  • @shasikumar2851
    @shasikumar2851 2 роки тому

    Hi, I have a problem please help me on this..!!
    I have a sharepoint list where more than 1lakh items get created every day, and I have to delete those items after two days of created date.. Please help me how can i achieve this using power automate.. And help me which license I need to purchase ..?
    Thanks in advance..!!

  • @babugondarammohan4158
    @babugondarammohan4158 3 місяці тому

    Hi

  • @stultuses
    @stultuses 2 роки тому +2

    I have not been able to solve the following issue with power automate
    I have a spreadsheet with URL addresses
    I loop through the cells and open up the web pages and capture the screen
    I then write that screen back to the spreadsheet but on certain websites it fails because the screen contains certain characters that Excel tries to interpret as a formula
    I cannot find a way to set the cell I am copying the web page into, to be of type 'text', which would stop Excel trying to treat the information as a formula
    Anyhow encounter this issue before and how did you solve it?
    It seems power automate had no option for this sort of fine control 😞

  • @DaRkPlUm
    @DaRkPlUm 2 роки тому +142

    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
      @PragmaticWorks  2 роки тому +3

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

    • @sahilk4528
      @sahilk4528 Рік тому

      Pane '👉 Power ... - UA-cam - Brave'

    • @sahilk4528
      @sahilk4528 Рік тому

      Pane '👉 Power ... - UA-cam - Brave'

    • @DianaNosorog
      @DianaNosorog 10 місяців тому

      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
    @stephenuk6490 Рік тому +8

    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.

  • @Stoy-boy
    @Stoy-boy Рік тому +1

    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. 💕

  • @johndamba5687
    @johndamba5687 2 роки тому +7

    his kindness shows it to everyone the kind of heart, feelings and passion he have for another’s man fortune thanks for the 3btc so so amazing

  • @davewood9199
    @davewood9199 2 роки тому +11

    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.

  • @melanietoups5504
    @melanietoups5504 2 роки тому +35

    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!

  • @RoeGabriel_i_EMPOWER
    @RoeGabriel_i_EMPOWER Рік тому +1

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

  • @marcinzajac389
    @marcinzajac389 2 роки тому +1

    ...and what is API???
    Well, I tried to automate reprot process in Power Bi. Just to select name from checkbox and export to pdf....sounds super simple....but like always with Microsoft - does not work.

  • @mikewebb6019
    @mikewebb6019 Рік тому +1

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

  • @suddengun007
    @suddengun007 Рік тому +2

    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.

  • @TheGenesario
    @TheGenesario 11 місяців тому

    Good video. But not 'Pro'. 'Pro' should include more detailed content i.e. editing flows directly in json in order for example to fix broken (messed by MS) connection references. Or at least working with object variables, using scopes and handling errors.

  • @morowar666
    @morowar666 Рік тому +3

    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.

  • @HerskinMeycauayan
    @HerskinMeycauayan 3 місяці тому

    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?

  • @LiveLife378
    @LiveLife378 Рік тому +1

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

  • @amoltejankar
    @amoltejankar 6 місяців тому

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

  • @varadarajans3527
    @varadarajans3527 2 роки тому +9

    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!

  • @OriginalVenomZA
    @OriginalVenomZA Рік тому

    Fun facr, nothing to do with the course. Great course btw. But, Toys R us still exists in South Africa.

  • @torresxavier
    @torresxavier 2 роки тому +2

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

  • @Cruz0e
    @Cruz0e Рік тому

    is it a made up name? Devin Knight...
    Sounds like you are a fan of Devon from Knight Rider:D

  • @MatKjeldsen
    @MatKjeldsen 2 місяці тому

    I am collecting Power Automate champions - come join the fun and learn to automate your daily work life!

  • @gabrielatemporale8693
    @gabrielatemporale8693 2 роки тому +2

    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
      @desktopdatacrunching4032 2 роки тому

      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

  • @tlc4417
    @tlc4417 6 місяців тому

    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.

  • @gunapalani5580
    @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

  • @UKJ28
    @UKJ28 7 місяців тому

    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?

  • @mrkraymnd
    @mrkraymnd 2 роки тому +7

    This is fantastic - thank you for publishing

  • @margaretlopez2195
    @margaretlopez2195 Рік тому +3

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

  • @pvksmaheeth8816
    @pvksmaheeth8816 7 місяців тому

    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

  • @TaraCotz
    @TaraCotz 2 роки тому +1

    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?

  • @dannyhsu5612
    @dannyhsu5612 Рік тому +1

    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!

  • @007lbp
    @007lbp 2 роки тому +4

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

  • @alenjoevarghese1955
    @alenjoevarghese1955 11 місяців тому

    What software is he using to screenshare/videoshare/draw lines/zoom in etc?

  • @mahendrabiradar380
    @mahendrabiradar380 7 місяців тому +1

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

  • @ravvenhawk1110
    @ravvenhawk1110 2 роки тому +2

    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

  • @thestereoclub6735
    @thestereoclub6735 3 місяці тому

    Quality content but multiple ads every 5 minutes. Literally.

  • @fingerprintinit
    @fingerprintinit Рік тому +2

    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

  • @SaltAndVi
    @SaltAndVi 2 роки тому +2

    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.

  • @InsightfulJourney123
    @InsightfulJourney123 2 роки тому +2

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

    • @PragmaticWorks
      @PragmaticWorks  2 роки тому

      Glad it was helpful! Thank you for watching!

  • @SiyamandRashid
    @SiyamandRashid 2 роки тому

    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

  • @Kimwenman
    @Kimwenman 2 роки тому +3

    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
      @PragmaticWorks  2 роки тому

      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
      @MrYdoineedthis 2 роки тому

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

  • @nileshrathod4107
    @nileshrathod4107 8 місяців тому

    I was Trying to automate using template but not receiving message on MS team. below is the text on exclamation sign in circle. I used chat with flow boat and in recipient given my ID.
    "ActionBranchingConditionNotSatisfied
    The execution of template action 'Post_message_in_a_chat_or_channel' skipped: the branching condition for this action is not satisfied."

  • @danlop_2023
    @danlop_2023 Рік тому +1

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

  • @autoshowoff3522
    @autoshowoff3522 2 роки тому +1

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

    • @desktopdatacrunching4032
      @desktopdatacrunching4032 2 роки тому

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

  • @sathiya4516
    @sathiya4516 2 роки тому +1

    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!

  • @MatheusSouza-yh5yj
    @MatheusSouza-yh5yj 3 місяці тому

    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?

  • @vikramnanda2833
    @vikramnanda2833 2 роки тому +1

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

    • @desktopdatacrunching4032
      @desktopdatacrunching4032 2 роки тому

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

  • @vigneswaranj8415
    @vigneswaranj8415 2 роки тому +1

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

  • @shubhamsatpathy6489
    @shubhamsatpathy6489 Рік тому

    I have a question : Can I export my desktop flow to my users and it does need a PAD to be installed at their end ?

    • @desktopdatacrunching4032
      @desktopdatacrunching4032 Рік тому

      Yes if you export it and send the flow to someone else they would need PAD installed on their machine to look at it.

  • @JunedAhmed-rs2hb
    @JunedAhmed-rs2hb 9 місяців тому

    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.

  • @gustavopineda7933
    @gustavopineda7933 Рік тому +1

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

  • @TrassBI
    @TrassBI 2 роки тому +4

    This was very useful session. Thanks for sharing👍

  • @nelsonxaxa5323
    @nelsonxaxa5323 2 роки тому +5

    Amazing session

  • @seedrocmedia
    @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.

  • @zubaydee
    @zubaydee 8 місяців тому

    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!

  • @JamieTorontoAtkinson
    @JamieTorontoAtkinson Рік тому +1

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

  • @vikramnanda2833
    @vikramnanda2833 2 роки тому +1

    What is difference between power app and power automate?

  • @rashimalhotra8642
    @rashimalhotra8642 10 місяців тому

    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?

  • @thanhthule4564
    @thanhthule4564 10 місяців тому

    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!

  • @simondodd6231
    @simondodd6231 10 місяців тому

    Good video but waffly. I watched a 15minute video that covered everything in this course an I still understood it. The presenter knows his stuff but the presentation could have been more succinct.

  • @BryanChance
    @BryanChance Рік тому

    At 8:25 , sometimes they do create the problems. LOL

  • @Kelly-cg7qs
    @Kelly-cg7qs 4 місяці тому

    I would like to ask you to slow down talking and try not to sound like an auctioneer in the future tyvm.

    • @desktopdatacrunching4032
      @desktopdatacrunching4032 4 місяці тому

      Maybe change the video playback speed in the video player to slow it down..

  • @senyotsedze3388
    @senyotsedze3388 Рік тому

    Your teaching is good, but the strategy you adopt for the materials you are using is not favorable for beginners. You need to start everything from scratch. I am getting errors because I can't set up the output controls that you have already configured. We need to know how those configurations are made if you want us to follow you. Otherwise, this is just not good for beginners.

  • @chidozienwokoji4923
    @chidozienwokoji4923 8 місяців тому

    I'm watching from Nigeria. I just found this video 2 weeks ago and have completed it. Can I get a certificate of completion ?

    • @PragmaticWorks
      @PragmaticWorks  8 місяців тому

      Check the video description

    • @chidozienwokoji4923
      @chidozienwokoji4923 8 місяців тому

      @@PragmaticWorks okay . Thank you very much . I'm really enjoying your tutorials especially the ones done by you personally. You are such a precious gift.

  • @eutitiaj
    @eutitiaj 2 роки тому +4

    Amaizing !!! I learn a lot. Thanks

  • @dragosbolohan4139
    @dragosbolohan4139 Рік тому

    can you create a video about how to create a P.A.D. on Facebook, public posts(text, img/video) on a list with pages?

  • @wachhagottoday
    @wachhagottoday 4 місяці тому

    How do I get the Contoso Invoice application ?

  • @vaibhavilohani3421
    @vaibhavilohani3421 Рік тому +1

    Thank you so much for this great tutorial!

  • @siyasangasigila7587
    @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

  • @allyeatworld
    @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!

  • @GB3770
    @GB3770 2 роки тому +1

    I bet that cat is a really good programmer!

  • @parranoic
    @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

  • @perfectionist6624
    @perfectionist6624 Рік тому

    Hello please advise me if it is good to learn power apps and automate by power bi developer?

  • @barbarasanchez1560
    @barbarasanchez1560 2 роки тому +1

    Thank you!! Very helpful information ;)

  • @DiwankarSingh
    @DiwankarSingh 10 місяців тому

    can we automate tasks in xero accounting software

  • @marlynvornelas3943
    @marlynvornelas3943 2 роки тому

    how do you extract "Plain Text" out look emails with power automate without using the HTML to Text converter since the outlook email is already in Plain text format

  • @joelancaster203
    @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?

  • @Perrymatt1973
    @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

  • @francescjuliana888
    @francescjuliana888 2 роки тому +1

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

  • @anelenoroita
    @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

  • @juanjogamon
    @juanjogamon 6 місяців тому

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