What You'll Learn in Intro to Programming Using Power Automate

Course Length

6 hours (1 day)

Learning Objectives

Describe basic programming concepts such as inputs, outputs, logic, and flow using Power Automate
Identify and use triggers, actions, and connectors to build simple automated flows
Create and use variables to store and manage different types of data
Apply basic conditional logic (if/else) to support decision-making in flows
Use loops to handle repeating tasks and process data collections
Apply simple expressions and troubleshoot basic flow errors using run history

Target Student

This course is designed for beginners and IT/Business Analyst professionals who want to understand core programming concepts such as variables, conditions, loops, and logic without needing traditional coding experience.

Course Outline

This course introduces the fundamentals of programming using the visual, low-code environment of Power Automate. Through practical demonstrations and guided exercises, learners will explore how flows represent programs and how to build dynamic, data-driven automations. By the end of the course, participants will gain a strong foundation in programming concepts and be able to build more advanced and flexible automation solutions within Microsoft 365.

Section 1: Introduction to Programming Concepts

What Is Programming?

Inputs, Outputs

Logic and Flow

Events and Triggers

How Power Automate Represents Programming Visually

Comparing Traditional Coding vs. Power Automate

Section 2: Understanding Flow Structure

Triggers vs. Actions

Sequential Execution

Understanding Connectors

Expressions and Dynamic Content Basics

Naming Conventions for Readability

Section 3: Variables and Data Handling

What Are Variables?

Types of Variables:

String
Integer
Boolean
Array

Object (Intro Level)

Initializing Variables

Setting and Updating Values

Using Variables Across Steps

Section 4: Conditions and Decision Logic

If/Else Logic in Power Automate

Comparison Operators:

Equals, Contains, Greater Than, etc.

Nested Conditions

Real-World Decision-Making Examples

Section 5: Loops and Iteration

Why Loops Are Important

Apply to Each Loop

Do Until Loop

Loop Control Concepts

Iteration

Exit Conditions

Section 6: Working with Arrays and Collections

What Are Arrays?

Creating and Populating Arrays

Filtering Arrays

Using Array Outputs in Loops

Section 7: Expressions and Functions

Introduction to Expressions

Common Functions:

concat()
length()
utcNow()
toLower()/toUpper()

Using Expressions Inside Actions

Debugging Expressions

Section 8: Error Handling and Troubleshooting

Common Errors and How to Fix Them

Using Run History

Configuring Retry Policies

Basic Error Handling Approaches

Section 9: Putting It All Together

Designing a Complete “Program” in Power Automate

Combining Variables, Conditions, Loops, and Expressions

Designing for Clarity and Maintainability

Section 10: Best Practices

Clean Flow Design

Naming Standards

Reusability

When to Move to Advanced Techniques

Where to Go Next (Advanced Power Automate, APIs, Dataverse)

Intro to Programming Using Power Automate

Upcoming Classes

All Public classes are held online
with a live instructor

No dates have been scheduled for this class. Please contact us for more information or request a private class.

Have a Group?

Complete the form to receive a quote for private or customized training.

More people = GREATER savings

The Great Canadian Training & Consulting Company Advantage

When you train with us, your training will not just check a box. We make sure it is GREAT!

Experienced Trainers
Learn or Come Back Free Policy on Public Classes
Email After-Training Support

All of our courses include

PDF Reference Guide

Take your learning further with a digital Reference Guide you can access anytime. It’s practical, paper-free, and accessible on any device.

After-Training Support

Get 30 days of after-training support via email to apply what you've learned

Certificate of Completion

Boost your credentials with a Certificate of Completion, confirming the skills you’ve acquired with us.

Want even more?
Check out our add-ons

Extended After-Training Support

Extend your support beyond the standard 30 days for ongoing assistance.

Can I customize my course?
OF COURSE!

Customized to meet your unique needs

We can customize your training to fit your exact needs, whether it's making small adjustments or creating entirely new courses. From setting specific objectives and including your own files to addressing unique challenges, we're here to help. We can even tailor the training to align more closely with how you work and to fit perfectly into your schedule. Our goal is to provide training that's as unique as your goals.

Use your own files instead of our exercise files

You can opt to use your working files in your private training sessions (instead of our standard exercise files). This allows you to see how the lessons apply directly to your day-to-day role and get work done while you train—a true win-win!

Access to your recorded session for 60 days

You can request your private session be recorded. You can have access for 60 days to revisit what you’ve learned.