Advanced Power Automate Flows
Learning Outcomes
Get More Info
data, Tech & ai skills in






What’s Included
Course Introduction
Course Introduction
Power Automate Desktop flows are often not simple and straightforward in practical business situations. This lesson will introduce some of the more advanced situations we'll encounter in this course, and introduce our case study.
Setting up the Flow
Setting up the Flow
In this lesson, we'll get started with our flow by creating the flow in Power Automate Desktop, and adding the initial actions to the flow.
Changing the Case of Text
Changing the Case of Text
The first task we want to accomplish in our flow is converting names to title case. In this lesson, we'll extract the relevant data from Excel, create a loop to change the text case, and write the new values back into Excel.
Splitting the Address Field
Splitting the Address Field
Our second task in our flow is to split the address data into multiple fields, to make it easier to analyze. In this lesson, we'll develop a loop that will complete this task.
Adding the New Address Data
Adding the New Address Data
After splitting the address data into multiple components, we then need to add these components to Excel. We'll learn how to do this in this lesson.
Creating a Subflow
Creating a Subflow
Subflows make your flows shorter and easier to follow when they contain certain actions that are repeated multiple times. This lesson will introduce the concept of subflows and show you how to create one.
Using a Subflow
Using a Subflow
In order to use subflows, you need to provide a link between the main flow and the subflow. We'll create this link in this lesson and see how it affects the actions in the subflow.
Using an If Statement
Using an If Statement
Sometimes you'll only want to run some of the actions in your flow if particular conditions are met. In this case, you can use an If statement, which we'll create in this lesson.
Understanding Flow Control
Understanding Flow Control
Complex flows can be slightly difficult to follow and navigate through, but flow control measures can help keep your flow easy to follow. We'll learn how to use these tools in this lesson.
Running the Flow
Running the Flow
After completing a flow, you'll need to run it. We'll see how to run a complex flow in this lesson, and learn how to use Power Automate Desktop effectively when you're automating business tasks.
