Course / Course Details

Power Automate

  • Super admin image

    By - Super admin

  • 0 students
  • 5 Hours 15 Min
  • (0)

Course Requirements

  • No prior knowledge of AI or programming required

  • Basic computer skills (using a browser, email, files)

  • Curiosity to learn new technology

  • Access to a laptop or desktop with internet

  • Willingness to practice with simple AI tools

  • Course Description

    What will you learn in this course?
    • Create automated workflows connecting Outlook, Excel, SharePoint, and Teams for increased productivity and efficiency
    • Design flows to automate repetitive tasks, approvals, and data management in business processes
    • Integrate Power Automate with Power Apps and AI Builder to develop intelligent automation solutions
    • Utilize Power Automate Desktop to automate desktop tasks, reducing manual effort and enhancing operational speed

    Course Curriculum

    • 1 chapters
    • 17 lectures
    • 0 quizzes
    • 5 Hours 15 Min total length
    Toggle all chapters
    1 Part 1 Power Automate Desktop versus Server
    8.38 Min

    Microsoft have given the same name to two completely different products: the old Microsoft Flow (now called Power Automate), which allows you to automate workflows in the cloud, and the old Win Automation (now called Power Automate for Desktop), which allows you to implement Robotic Process Automation on your desktop computer. This video summarizes the differences between the two software applications and gives an example of each.


    2 Part 2 Creating Basic Flows
    16.13 Min

    This video will get you started with creating basic flows in Power Automate: the tutorial walks you through an example of creating a flow to send an email to someone using Outlook 365.


    3 Part 3 Creating triggered flows
    7.45 Min

    This tutorial will show you how to write a flow which runs on a trigger. For the example used for this video, this trigger will be someone adding a new recipe to a specified folder in OneDrive, which will then cause Power Automate to send a notification email out.


    4 Part 4 The Compose action and debugging
    17.48 Min

    This tutorial shows how you can create a text file in OneDrive when someone selects a file in SharePoint. The flow you'll create uses a Compose action (one of the most important in Power Automate) to bring the information you want to export together, before using a OneDrive action to create a text file. You'll also learn about the limitations of debugging in Power Automate, and how to get round these.


    5 Part 5 Variables and Basic Arrays
    22.02 Min

    This tutorial is the first of a series of 3. It explains what variables are in Power Automate and how to use them, and also gives example of setting and collapsing arrays. The next two tutorials in the series will show how to tidy up flows to make them neater and more elegant, and how to add conditions to test expressions in flows.


    6 Part 6 Tidying Up Flows
    12.05 Min

    This tutorial will show you how to make flows easier to read (and also more efficient). You'll learn how to group actions together using Scope, how to create branches in flows and how to work with expressions more efficiently. Note that you should watch the previous tutorial on variables and arrays before watching this one (this is the second tutorial in a mini-series of three).


    7 Part 7 Conditions
    11.43 Min

    This tutorial will show you how to add conditions to flow, whether using the simple Condition action to test between two possibilities or the more complicated Switch action to test between multiple mutually exclusive options.


    8 Part 8 Working with tables
    33.03 Min

    This tutorial will show how to load data from Excel tables, SharePoint lists, Outlook (for example, lists of emails) and OneDrive (for example, lists of files and folders). The tutorial also shows how to select only the columns you need, and how to present the information in an HTML table.


    9 Part 9 Sorting and Filtering using OData
    27.33 Min

    This tutorial shows how you can use OData to sort and filter tables of rows returned from online cloud-based apps like SharePoint and Excel 365, and why you should want to do this.


    10 Part 10 Apply to Each loops
    19.24 Min

    This tutorial will explain some of the things about Power Automate which may have been puzzling you, such as: - why Power Automate keeps randomly embedding your actions in Apply to Each loops - how you can copy dynamic content into an expression for subsequent editing - the syntax of expressions, on what all those question-marks mean The tutorial explains how to create and use Apply to Each loops in Power Automate, using the example of looping over the rows in an Excel table.


    11 Part 11 Error Handling
    23.1 Min

    This video shows how to handle errors in Power Automate flows. While it contains some complicated expressions, it will give you a good understanding into creating JSON expressions (as well as in the best way to implement error-handling).


    12 Part 12 Approvals
    34.06 Min

    This video shows how you how to create an approvals process. For our example when someone adds a film to a suggested watch list, you (or someone else) will be able to accept or reject the recommendation, giving your reasons. This acceptance or rejection (with the corresponding reason) will be flagged in SharePoint and the person who added the film will receive a notification of the result.


    13 Part 13a Automating Forms
    19.27 Min

    This video shows how to write flows to run when someone fills in a form that you've created. The cloud-based Forms application only exposes one trigger and one action, so there's not too much that you can do to automate forms using flows, but this tutorial also gives a handy introduction to how to create and distribute surveys using the easy-to-use Forms application.


    14 Part 13b Automating Power BI Desktop
    21.06 Min

    This video shows how you can create Power Automate buttons in Power BI reports, which run flows when you click on them. The example in this tutorial shows how you can email the current data in the filter context for a visual to someone just by clicking on a button embedded in a report.


    15 Part 13c Automating Teams
    15.23 Min

    This video shows how you can create a flow to interact with Teams. The example used is to listen for specific keywords mentioned in a Teams channel, and post updates to another channel when these designated keywords are mentioned.


    16 Part 14 Child flows solutions and inputs
    17.06 Min

    This video shows how you can delegate your error-handling to a separate flow, and then call this child flow when an error is triggered. Along the way you'll also learn about passing inputs to triggers and about creating solutions.


    17 Part 15 Tracked Properties
    11.01 Min

    This video shows how you can create tracked properties for any action, using them for this example to time how long an action takes to run.


    Instructor

    Super admin

    As the Super Admin of our platform, I bring over a decade of experience in managing and leading digital transformation initiatives. My journey began in the tech industry as a developer, and I have since evolved into a strategic leader with a focus on innovation and operational excellence. I am passionate about leveraging technology to solve complex problems and drive organizational growth. Outside of work, I enjoy mentoring aspiring tech professionals and staying updated with the latest industry trends.

    0 Rating
    0 Reviews
    12 Students
    161 Courses

    Course Full Rating

    0

    Course Rating
    (0)
    (0)
    (0)
    (0)
    (0)

    No Review found

    Sign In or Sign Up as student to post a review

    Student Feedback

    You must be enrolled to ask a question