Building Power Automate Cloud Flows Faster With Ai

Master Power Automate with AI: Build efficient cloud flows, automate tasks, and harness AI tools effortlessly

What you'll learn

Create cloud flows: Learn to build and optimize workflows in Power Automate for automating repetitive tasks efficiently.

Use AI tools: Leverage AI Builder and Copilot to enhance your automation and save time in designing and managing flows.

Integrate external data: Connect Power Automate with SharePoint, Excel, and other data sources for seamless workflows.

Master flow controls: Use conditions, switches, scopes, and approval actions to create advanced and flexible workflows.

Secure workflows: Learn best practices for securing flows, managing permissions, and optimizing automation processes.

Requirements

Basic computer skills: Familiarity with using web-based applications and navigating online tools.

Microsoft account: Access to a Microsoft 365 account to use Power Automate and related tools.

No prior experience required: The course is beginner-friendly and designed for users new to Power Automate.

Eagerness to learn: A willingness to explore automation and AI tools to improve productivity.

Description

Unlock the power of Power Automate and AI to build cloud flows faster and automate everyday tasks with ease! This course, designed for both beginners and professionals, will teach you how to create, control, and optimize flows to save time and boost productivity.With 10 hours of hands-on lessons, you’ll dive deep into triggers, variables, arrays, and external data connections using tools like SharePoint and Excel. Learn how to integrate AI Builder and Copilot to automate repetitive tasks, generate expressions, and create smarter workflows.Key topics covered:Introduction to Power Automate and cloud flowsTriggers, types, and managing flow control actionsConnecting flows to external data sources like SharePoint and ExcelUsing AI Builder to add intelligent automationLetting Copilot assist in designing and improving flowsSecuring and managing flows with proper permissionsThis course provides step-by-step guidance with real-world examples to ensure you grasp every concept. By the end, you’ll be confident in creating and managing flows that save hours of work.Whether you are a business user, IT professional, or simply want to improve your workflow automation skills, this course is perfect for you. No prior experience with Power Automate is required.Join now to learn how to combine the power of automation and AI tools to simplify your daily tasks, improve processes, and take your productivity to the next level!

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Is this the right course for you?

Lecture 3 Licenses and URLs

Lecture 4 Build your very first Flow

Lecture 5 The big picture - From trigger and action to Power Platform

Section 2: Flow triggers and types

Lecture 6 Flow type is defined by trigger type

Lecture 7 Adding input parameters to an Instant Cloud Flow

Lecture 8 Using Power Automate mobile app to run instant cloud flows

Lecture 9 Creating the SharePoint site and list for the rest of the course

Lecture 10 Calling an instant cloud flow from a SharePoint list item

Lecture 11 Scheduled cloud flow and recurrence trigger

Lecture 12 Automated cloud flows

Section 3: Variables and arrays in Power Automate

Lecture 13 What is this section about?

Lecture 14 Initialize and set string variables

Lecture 15 Working with numeric variables

Lecture 16 Working with Boolean variables

Lecture 17 Working with Array variables

Lecture 18 Apply to each - Loop through array elements

Lecture 19 Working with Object variables

Section 4: Connecting flow to external data (SharePoint)

Lecture 20 Let's get one record from a SharePoint list

Lecture 21 Using "Get items" to get all items from SharePoint list

Lecture 22 Using "Condition" to filter list items

Lecture 23 Introduction to OData filter

Lecture 24 Insert a list item to SharePoint

Lecture 25 Updating a list item in SharePoint

Lecture 26 Update a SharePoint list item when you don't have ID

Lecture 27 Deleting one or multiple SharePoint list items

Lecture 28 Creating a deleted item alert on a SharePoint list

Lecture 29 Accessing files in a SharePoint library from Flow

Lecture 30 Creating files inside SharePoint library

Lecture 31 Create a flow that is fired when an email arrives

Section 5: Understanding Flow control actions

Lecture 32 What are we going to talk about and why it is important

Lecture 33 Where do we need "Switch" instead of condition

Lecture 34 Using switch in Power Automate flow

Lecture 35 Adding scope to Flow

Lecture 36 Adding Branch to your flow

Lecture 37 Working with "Terminate" and "Compose"

Lecture 38 Controlling the flow with "Run after"

Lecture 39 Using Approval actions in Power Automate Flow - Part 1

Lecture 40 Using Approval actions in Power Automate Flow - Part 2

Lecture 41 Start and wait for an approval "OF TEXT"

Section 6: Working with Child Flows

Lecture 42 Create your first child flow

Lecture 43 How to call a child flow from another flow

Lecture 44 Adding a connection to Child flow ?

Section 7: Cloud Flow Security

Lecture 45 Flow ownership and authoring

Lecture 46 Permission to run a Flow

Lecture 47 Flow connection security

Lecture 48 Basics of Power Automate licensing

Section 8: Working with Excel Data

Lecture 49 Prepare your excel file for Power Automate

Lecture 50 How to fire a trigger, directly from inside Excel table

Lecture 51 Reading a single row from Excel table

Lecture 52 Using “OData filter“ for Excel data

Lecture 53 How to create, update and delete records in Excel table

Section 9: Working with AI Builder

Lecture 54 Typical problem for AI Builder

Lecture 55 Changing the trigger - The nightmare

Lecture 56 GPT and AI Prompts

Lecture 57 Combining AI Prompts and taking care of approval warning

Lecture 58 Using AI Prompt to generate code and HTML tags

Lecture 59 JSON output from AI Prompt

Lecture 60 AI Builder summary and next steps

Section 10: Let Copilot do the boring parts of building a Flow

Lecture 61 Introduction to "Describe it to design it"

Lecture 62 Set your expectations from AI

Lecture 63 Get your design ideas from AI

Lecture 64 Asking Copilot to write expressions for your flow

Lecture 65 When you don't have a clue about how to create flow

Lecture 66 What is Copilot really good for

Business professionals: Ideal for individuals looking to automate repetitive tasks and streamline workflows.,IT professionals: Perfect for IT experts who want to enhance their automation skills with Power Automate and AI tools.,Beginners to Power Automate: Designed for those with no prior experience but eager to learn workflow automation.,Managers and team leaders: Great for anyone seeking to boost team productivity through efficient process automation.,Students and learners: Suitable for anyone interested in exploring Microsoft Power Platform and AI-driven automation.