Skip to content

Pages

Courses

ALL COURSES

Resources

ALL RESOURCES

Blogs

ALL BLOGS
Use coupon code LEARN21 at checkout for 21% off any course. Valid through 6/30/21.
*Offer excludes Scaled Agile (SAFe®) courses and private team training.

Microsoft Power Automate Workshop

Microsoft Power Automation (formerly Microsoft Flow) is an automation tool in Office 365 that empowers users to automate tasks and processes without writing code. For example, you can use Power Automation to automatically save email attachments to OneDrive or SharePoint. Need a process to approve leave requests? Use Power Automation!

Students will learn how and why to use Microsoft Power Automation. We will begin by creating Flows from one of the hundreds of available templates and then customizing the Flow to meet their specific requirements. Then, we’ll cover how to create totally customized Flow from scratch. Exercises will lead students through creating Flows with a variety of “connectors” including SharePoint, Microsoft Forms, Excel and Outlook/Exchange. Lab exercises will also demonstrate how to automate common tasks such as sending emails or kicking off a business process when a specific event takes place such as receiving an email or when a new SharePoint list item is created.

One of the most popular Power Automation features is the ability to process approvals. Students will learn how to create a simple approval process. Then, they build on that knowledge by creating approval Flows check to verify that an approver is not “out of the office” before assigning an approval to them as well as sending reminder emails to the approver.

Finally, students will extend their Power Automation knowledge with an introduction to using Flow expressions.

This class is designed for End Users (team members, project members) and Power Users who are new to Power Automation with little to no experience.

You Will:

Available formats for this course
In-Person
Live Online
Private Team Training
Duration
1 day/8 hours of instruction
Education Credits
7 PDUs
7 Technical PDUs
7 PDUs
Public Classroom Pricing

Starting at: $695(USD)

$950(CAD)

GSA Price: $585

Group Rate: $595

Get the full details on this course. Download the .PDF Brochure below:

Part 1: Overview of Power Automation and Flow Capabilities

  1. Power Automation capabilities
  2. Introduction to the Flow Design environment
  3. Types of Flows
    • Automated
    • Instant
    • Scheduled
  4. Basic Components of a Flow
    • Connections
    • Triggers
    • Actions
    • Conditions
    • Loops
  1. Flow templates
  2. Flow Integration with SharePoint
  3. Flow Licensing

Lab: Creating a Flow from a Template

  1. Create a Flow that sends an Email when a new SharePoint list item is added from a template
  2. Modify the template email text
  3. View run history

Part 2: Creating Flows

  1. Creating a new Flow
  2. Selection of a trigger
  3. Selection of actions
  4. Connection Information
  5. Naming and Saving a Flow
  6. Running the Flow
  7. Editing a Flow and re-running
  8. “Debugging” Flows

Lab: Creating a Flow

  1. Create a Flow that performs the following actions:
    • Creates a SharePoint list item when a new Form is submitted
    • Sends an email
  1. Create a Flow that does the following:
    • Runs once a day
    • Retrieves items form a SharePoint list of projects
    • Updates the SharePoint list if the item is overdue

Part 3: Creating Approval Flows

  1. Overview of Flow approval capabilities
  2. Approval center
  3. Types of approvals
    • Simple
    • Sequential
    • Parallel
  4. Responding to an approval request

Lab: Creation of an Approval Flow

  1. Select the “for a selected document” trigger and a SharePoint document library
  2. Start an approval proves on the selected document
  3. Update document metadata based on the approval outcome

Part 4: Using Variables and Expressions

  1. Using variables
    • Types of variables
    • How and when to use variables
  2. Flow Expressions
    • Expressions overview
    • Expression categories (String, Math, Date/Time, additional)
    • Expression syntax

Lab: Using Expressions

  1. Using Expressions in Actions
  2. Using expressions with variables
  3. Using expressions in conditions
  4. Using Expressions in emails
  5. Nested expressions

Part 5: Team Flows

  1. Adding additional owners to a Flow
    • Implications of adding additional Owners
  2. Adding run-only users

Lab:

  1. Add an additional user to a Flow
    • Verify that Flow now appears under Team Flows
  2. Share a “for a selected document” Flow with the SharePoint library
    • Verify that other users can see and execute the Flow

  • End Users
  • Site Owners
  • Information Managers
  • Project Managers
  • Team Supervisors
  • Any person who needs to create process Flows to improve efficiency
  • Anyone who uses SharePoint Online to automate Flows

  • Create Flows from a template
  • Create a Flow from scratch
  • Create approval Flows
  • Create “button” Flows
  • Debug Flows
  • Add additional owners to a Flow
  • Use Microsoft Forms with Power Automation
  • Use SharePoint with Power Automation
  • Use Excel with Power Automation
  • Use Outlook/Exchange with Power Automation

Microsoft Power Automate Workshop Schedule

Location
Date
Register
CPSFDC\Entity\Session::__set_state(array( 'entitySanitizer' => 'CPSFDC\\Utils\\Sanitizers\\SessionSanitizer', 'sfId' => 'a011G00000VNPVDQA5', 'startDate' => '2021-04-23', 'startTime' => '11:30 AM', 'endDate' => '2021-04-23', 'endTime' => '7:30 PM', 'name' => '973004VCL', 'standardCourseFee' => '695', 'standardCourseFeeCAD' => '950', 'courseId' => 'MSFLOW', 'course' => 'a001G00000Cmr9MQAR', 'courseSfId' => 'a001G00000Cmr9MQAR', 'courseName' => 'Microsoft Power Automate Workshop', 'instructorId' => '85707', 'instructorSfId' => 'a0237000001Y4SiAAK', 'instructorDisplayName' => 'Andy Huneycutt', 'instructorName' => 'Andy Huneycutt', 'locationCode' => 'VCL', 'sessionStatus' => 'O', 'city' => 'Live Online Training', 'state' => '', 'cityState' => 'Live, Online Training', 'locationSfId' => 'a0637000000tn2hAAA', 'subjectSfId' => 'a051G00000Jso4mQAB', 'subjectName' => 'Microsoft', 'specialitySfId' => 'a051G00000Jso4wQAB', 'specialityName' => 'Tools & Platforms', 'expertiseSfId' => 'a051G00000JsoBxQAJ', 'expertiseName' => NULL, 'certificationSfId' => NULL, 'certificationBody' => '', 'certificationName' => '', 'pdus' => '7', 'deliveryModalities' => 'In-Person;Live Online', 'fullFacilityAddress' => 'Live Instructor-Led Online Training
Please call Cprime for location details
at 1-877-800-5221
, LOL', 'gtr' => '1', ))
Live, Online Training
Apr 23rd - 23rd 11:30 AM - 7:30 PM ET
$695(usd)
Guaranteed to RunGuaranteed to Run
Register
CPSFDC\Entity\Session::__set_state(array( 'entitySanitizer' => 'CPSFDC\\Utils\\Sanitizers\\SessionSanitizer', 'sfId' => 'a011G00000VNPVEQA5', 'startDate' => '2021-05-14', 'startTime' => '8:30 AM', 'endDate' => '2021-05-14', 'endTime' => '4:30 PM', 'name' => '973004VCL02', 'standardCourseFee' => '695', 'standardCourseFeeCAD' => '950', 'courseId' => 'MSFLOW', 'course' => 'a001G00000Cmr9MQAR', 'courseSfId' => 'a001G00000Cmr9MQAR', 'courseName' => 'Microsoft Power Automate Workshop', 'instructorId' => '85388', 'instructorSfId' => 'a0237000001Y4RDAA0', 'instructorDisplayName' => 'TBD', 'instructorName' => 'TBD', 'locationCode' => 'VCL', 'sessionStatus' => 'O', 'city' => 'Live Online Training', 'state' => '', 'cityState' => 'Live, Online Training', 'locationSfId' => 'a0637000000tn2hAAA', 'subjectSfId' => 'a051G00000Jso4mQAB', 'subjectName' => 'Microsoft', 'specialitySfId' => 'a051G00000Jso4wQAB', 'specialityName' => 'Tools & Platforms', 'expertiseSfId' => 'a051G00000JsoBxQAJ', 'expertiseName' => NULL, 'certificationSfId' => NULL, 'certificationBody' => '', 'certificationName' => '', 'pdus' => '7', 'deliveryModalities' => 'In-Person;Live Online', 'fullFacilityAddress' => 'Live Instructor-Led Online Training
Please call Cprime for location details
at 1-877-800-5221
, LOL', 'gtr' => '', ))
Live, Online Training
May 14th - 14th 8:30 AM - 4:30 PM ET
$695(usd)
CPSFDC\Entity\Session::__set_state(array( 'entitySanitizer' => 'CPSFDC\\Utils\\Sanitizers\\SessionSanitizer', 'sfId' => 'a011G00000VNPVFQA5', 'startDate' => '2021-06-18', 'startTime' => '10:30 AM', 'endDate' => '2021-06-18', 'endTime' => '5:30 PM', 'name' => '973004VCL03', 'standardCourseFee' => '695', 'standardCourseFeeCAD' => '950', 'courseId' => 'MSFLOW', 'course' => 'a001G00000Cmr9MQAR', 'courseSfId' => 'a001G00000Cmr9MQAR', 'courseName' => 'Microsoft Power Automate Workshop', 'instructorId' => '85388', 'instructorSfId' => 'a0237000001Y4RDAA0', 'instructorDisplayName' => 'TBD', 'instructorName' => 'TBD', 'locationCode' => 'VCL', 'sessionStatus' => 'O', 'city' => 'Live Online Training', 'state' => '', 'cityState' => 'Live, Online Training', 'locationSfId' => 'a0637000000tn2hAAA', 'subjectSfId' => 'a051G00000Jso4mQAB', 'subjectName' => 'Microsoft', 'specialitySfId' => 'a051G00000Jso4wQAB', 'specialityName' => 'Tools & Platforms', 'expertiseSfId' => 'a051G00000JsoBxQAJ', 'expertiseName' => NULL, 'certificationSfId' => NULL, 'certificationBody' => '', 'certificationName' => '', 'pdus' => '7', 'deliveryModalities' => 'In-Person;Live Online', 'fullFacilityAddress' => 'Live Instructor-Led Online Training
Please call Cprime for location details
at 1-877-800-5221
, LOL', 'gtr' => '', ))
Live, Online Training
Jun 18th - 18th 10:30 AM - 5:30 PM ET
$695(usd)
CPSFDC\Entity\Session::__set_state(array( 'entitySanitizer' => 'CPSFDC\\Utils\\Sanitizers\\SessionSanitizer', 'sfId' => 'a011G00000VNPVGQA5', 'startDate' => '2021-07-09', 'startTime' => '9:30 AM', 'endDate' => '2021-07-09', 'endTime' => '5:30 PM', 'name' => '973005VCL', 'standardCourseFee' => '695', 'standardCourseFeeCAD' => '950', 'courseId' => 'MSFLOW', 'course' => 'a001G00000Cmr9MQAR', 'courseSfId' => 'a001G00000Cmr9MQAR', 'courseName' => 'Microsoft Power Automate Workshop', 'instructorId' => '85388', 'instructorSfId' => 'a0237000001Y4RDAA0', 'instructorDisplayName' => 'TBD', 'instructorName' => 'TBD', 'locationCode' => 'VCL', 'sessionStatus' => 'O', 'city' => 'Live Online Training', 'state' => '', 'cityState' => 'Live, Online Training', 'locationSfId' => 'a0637000000tn2hAAA', 'subjectSfId' => 'a051G00000Jso4mQAB', 'subjectName' => 'Microsoft', 'specialitySfId' => 'a051G00000Jso4wQAB', 'specialityName' => 'Tools & Platforms', 'expertiseSfId' => 'a051G00000JsoBxQAJ', 'expertiseName' => NULL, 'certificationSfId' => NULL, 'certificationBody' => '', 'certificationName' => '', 'pdus' => '7', 'deliveryModalities' => 'In-Person;Live Online', 'fullFacilityAddress' => 'Live Instructor-Led Online Training
Please call Cprime for location details
at 1-877-800-5221
, LOL', 'gtr' => '', ))
Live, Online Training
Jul 9th - 9th 9:30 AM - 5:30 PM ET
$695(usd)
CPSFDC\Entity\Session::__set_state(array( 'entitySanitizer' => 'CPSFDC\\Utils\\Sanitizers\\SessionSanitizer', 'sfId' => 'a011G00000VNPVHQA5', 'startDate' => '2021-08-27', 'startTime' => '11:30 AM', 'endDate' => '2021-08-27', 'endTime' => '7:30 PM', 'name' => '973005VCL02', 'standardCourseFee' => '695', 'standardCourseFeeCAD' => '950', 'courseId' => 'MSFLOW', 'course' => 'a001G00000Cmr9MQAR', 'courseSfId' => 'a001G00000Cmr9MQAR', 'courseName' => 'Microsoft Power Automate Workshop', 'instructorId' => '85388', 'instructorSfId' => 'a0237000001Y4RDAA0', 'instructorDisplayName' => 'TBD', 'instructorName' => 'TBD', 'locationCode' => 'VCL', 'sessionStatus' => 'O', 'city' => 'Live Online Training', 'state' => '', 'cityState' => 'Live, Online Training', 'locationSfId' => 'a0637000000tn2hAAA', 'subjectSfId' => 'a051G00000Jso4mQAB', 'subjectName' => 'Microsoft', 'specialitySfId' => 'a051G00000Jso4wQAB', 'specialityName' => 'Tools & Platforms', 'expertiseSfId' => 'a051G00000JsoBxQAJ', 'expertiseName' => NULL, 'certificationSfId' => NULL, 'certificationBody' => '', 'certificationName' => '', 'pdus' => '7', 'deliveryModalities' => 'In-Person;Live Online', 'fullFacilityAddress' => 'Live Instructor-Led Online Training
Please call Cprime for location details
at 1-877-800-5221
, LOL', 'gtr' => '', ))
Live, Online Training
Aug 27th - 27th 11:30 AM - 7:30 PM ET
$695(usd)
CPSFDC\Entity\Session::__set_state(array( 'entitySanitizer' => 'CPSFDC\\Utils\\Sanitizers\\SessionSanitizer', 'sfId' => 'a011G00000VNPVIQA5', 'startDate' => '2021-09-03', 'startTime' => '8:30 AM', 'endDate' => '2021-09-03', 'endTime' => '4:30 PM', 'name' => '973005VCL03', 'standardCourseFee' => '695', 'standardCourseFeeCAD' => '950', 'courseId' => 'MSFLOW', 'course' => 'a001G00000Cmr9MQAR', 'courseSfId' => 'a001G00000Cmr9MQAR', 'courseName' => 'Microsoft Power Automate Workshop', 'instructorId' => '85388', 'instructorSfId' => 'a0237000001Y4RDAA0', 'instructorDisplayName' => 'TBD', 'instructorName' => 'TBD', 'locationCode' => 'VCL', 'sessionStatus' => 'O', 'city' => 'Live Online Training', 'state' => '', 'cityState' => 'Live, Online Training', 'locationSfId' => 'a0637000000tn2hAAA', 'subjectSfId' => 'a051G00000Jso4mQAB', 'subjectName' => 'Microsoft', 'specialitySfId' => 'a051G00000Jso4wQAB', 'specialityName' => 'Tools & Platforms', 'expertiseSfId' => 'a051G00000JsoBxQAJ', 'expertiseName' => NULL, 'certificationSfId' => NULL, 'certificationBody' => '', 'certificationName' => '', 'pdus' => '7', 'deliveryModalities' => 'In-Person;Live Online', 'fullFacilityAddress' => 'Live Instructor-Led Online Training
Please call Cprime for location details
at 1-877-800-5221
, LOL', 'gtr' => '', ))
Live, Online Training
Sep 3rd - 3rd 8:30 AM - 4:30 PM ET
$695(usd)
CPSFDC\Entity\Session::__set_state(array( 'entitySanitizer' => 'CPSFDC\\Utils\\Sanitizers\\SessionSanitizer', 'sfId' => 'a011G00000VNPVJQA5', 'startDate' => '2021-10-18', 'startTime' => '10:30 AM', 'endDate' => '2021-10-18', 'endTime' => '5:30 PM', 'name' => '973006VCL', 'standardCourseFee' => '695', 'standardCourseFeeCAD' => '950', 'courseId' => 'MSFLOW', 'course' => 'a001G00000Cmr9MQAR', 'courseSfId' => 'a001G00000Cmr9MQAR', 'courseName' => 'Microsoft Power Automate Workshop', 'instructorId' => '85388', 'instructorSfId' => 'a0237000001Y4RDAA0', 'instructorDisplayName' => 'TBD', 'instructorName' => 'TBD', 'locationCode' => 'VCL', 'sessionStatus' => 'O', 'city' => 'Live Online Training', 'state' => '', 'cityState' => 'Live, Online Training', 'locationSfId' => 'a0637000000tn2hAAA', 'subjectSfId' => 'a051G00000Jso4mQAB', 'subjectName' => 'Microsoft', 'specialitySfId' => 'a051G00000Jso4wQAB', 'specialityName' => 'Tools & Platforms', 'expertiseSfId' => 'a051G00000JsoBxQAJ', 'expertiseName' => NULL, 'certificationSfId' => NULL, 'certificationBody' => '', 'certificationName' => '', 'pdus' => '7', 'deliveryModalities' => 'In-Person;Live Online', 'fullFacilityAddress' => 'Live Instructor-Led Online Training
Please call Cprime for location details
at 1-877-800-5221
, LOL', 'gtr' => '', ))
Live, Online Training
Oct 18th - 18th 10:30 AM - 5:30 PM ET
$695(usd)
CPSFDC\Entity\Session::__set_state(array( 'entitySanitizer' => 'CPSFDC\\Utils\\Sanitizers\\SessionSanitizer', 'sfId' => 'a011G00000VNPVKQA5', 'startDate' => '2021-11-15', 'startTime' => '9:30 AM', 'endDate' => '2021-11-15', 'endTime' => '5:30 PM', 'name' => '973006VCL02', 'standardCourseFee' => '695', 'standardCourseFeeCAD' => '950', 'courseId' => 'MSFLOW', 'course' => 'a001G00000Cmr9MQAR', 'courseSfId' => 'a001G00000Cmr9MQAR', 'courseName' => 'Microsoft Power Automate Workshop', 'instructorId' => '85388', 'instructorSfId' => 'a0237000001Y4RDAA0', 'instructorDisplayName' => 'TBD', 'instructorName' => 'TBD', 'locationCode' => 'VCL', 'sessionStatus' => 'O', 'city' => 'Live Online Training', 'state' => '', 'cityState' => 'Live, Online Training', 'locationSfId' => 'a0637000000tn2hAAA', 'subjectSfId' => 'a051G00000Jso4mQAB', 'subjectName' => 'Microsoft', 'specialitySfId' => 'a051G00000Jso4wQAB', 'specialityName' => 'Tools & Platforms', 'expertiseSfId' => 'a051G00000JsoBxQAJ', 'expertiseName' => NULL, 'certificationSfId' => NULL, 'certificationBody' => '', 'certificationName' => '', 'pdus' => '7', 'deliveryModalities' => 'In-Person;Live Online', 'fullFacilityAddress' => 'Live Instructor-Led Online Training
Please call Cprime for location details
at 1-877-800-5221
, LOL', 'gtr' => '', ))
Live, Online Training
Nov 15th - 15th 9:30 AM - 5:30 PM ET
$695(usd)
CPSFDC\Entity\Session::__set_state(array( 'entitySanitizer' => 'CPSFDC\\Utils\\Sanitizers\\SessionSanitizer', 'sfId' => 'a011G00000VNPVLQA5', 'startDate' => '2021-12-06', 'startTime' => '11:30 AM', 'endDate' => '2021-12-06', 'endTime' => '7:30 PM', 'name' => '973006VCL03', 'standardCourseFee' => '695', 'standardCourseFeeCAD' => '950', 'courseId' => 'MSFLOW', 'course' => 'a001G00000Cmr9MQAR', 'courseSfId' => 'a001G00000Cmr9MQAR', 'courseName' => 'Microsoft Power Automate Workshop', 'instructorId' => '85388', 'instructorSfId' => 'a0237000001Y4RDAA0', 'instructorDisplayName' => 'TBD', 'instructorName' => 'TBD', 'locationCode' => 'VCL', 'sessionStatus' => 'O', 'city' => 'Live Online Training', 'state' => '', 'cityState' => 'Live, Online Training', 'locationSfId' => 'a0637000000tn2hAAA', 'subjectSfId' => 'a051G00000Jso4mQAB', 'subjectName' => 'Microsoft', 'specialitySfId' => 'a051G00000Jso4wQAB', 'specialityName' => 'Tools & Platforms', 'expertiseSfId' => 'a051G00000JsoBxQAJ', 'expertiseName' => NULL, 'certificationSfId' => NULL, 'certificationBody' => '', 'certificationName' => '', 'pdus' => '7', 'deliveryModalities' => 'In-Person;Live Online', 'fullFacilityAddress' => 'Live Instructor-Led Online Training
Please call Cprime for location details
at 1-877-800-5221
, LOL', 'gtr' => '', ))
Live, Online Training
Dec 6th - 6th 11:30 AM - 7:30 PM ET
$695(usd)

Request Private Team Training