Build a Basic Cloud Flow

To build a basic cloud flow in Power Automate, follow these steps:

  1. Sign in to Power Automate and navigate to the “My flows” page.
  2. Click on “Create” and select “Automated cloud flow” to create a new flow.
  3. Choose a trigger for the flow. This could be an event in a specific app or a scheduled trigger.
  4. Add any required inputs for the trigger and configure the details of the trigger.
  5. Add any necessary actions to the flow. This could include sending an email, creating a new item in SharePoint, or sending a notification to a specific user.
  6. Configure the details of each action, including any required inputs and options.
  7. Test the flow to ensure it is working correctly.
  8. Save and publish the flow.

This basic cloud flow can be customized as needed to fit specific use cases and scenarios.

Creating a flow by using an instant, automated, or scheduled flow template

In Power Automate, a flow template is a pre-built, customizable flow that can be used to automate a specific process. There are different types of flow templates available in Power Automate, including instant flows, automated flows, and scheduled flows.

  • Instant flows: These are triggered manually, allowing users to execute the flow at any time with the click of a button.
  • Automated flows: These are triggered automatically when a specific event occurs, such as a new item being added to a SharePoint list or a new email arriving in a mailbox.
  • Scheduled flows: These are triggered on a set schedule, such as every day at a specific time, and can be used to perform regular data processing tasks.

To create a flow using a template, follow these steps:

  1. Log in to the Power Automate portal.
  2. Click the “Create” button in the top navigation bar and select “Instant cloud flow”, “Automated cloud flow”, or “Scheduled cloud flow”, depending on the type of flow you want to create.
  3. Browse the available templates or search for a specific template using keywords.
  4. Select the template you want to use, and click “Continue”.
  5. Customize the flow to meet your specific requirements by modifying the trigger, actions, and other settings as needed.
  6. Save the flow and give it a descriptive name.
  7. Test the flow to ensure that it is working as expected.
  8. Turn on the flow to activate it and automate the specified process.

Modify a cloud flow

To modify a cloud flow in Power Automate, you can follow these steps:

  1. Sign in to the Power Automate portal (
  2. Click on the flow you want to modify in the My flows list or search for it using the search bar.
  3. Click on the Edit flow button to open the flow in the Power Automate designer.
  4. Make the necessary modifications to the flow. You can add or remove actions, modify the properties of actions, add or remove conditions, and so on.
  5. Click the Save button when you’re done making modifications.
  6. Review your changes and then click the Test button to test your flow. You can test the flow using a sample input, or you can enter your own inputs.
  7. Once you’ve tested your flow, click the Run button to run it in production.

Remember to save and test your flow frequently to ensure it works as expected. Also, consider versioning your flow, so you can easily revert to a previous version if needed.

Use Flow Controls to perform data operations

Power Automate provides several data operations that you can use in a flow to retrieve, create, update, and delete data in various systems. Here are a few examples:

  • Retrieve data: You can use actions such as “Get rows” and “List records” to retrieve data from various data sources such as Excel, SharePoint, Dynamics 365, and SQL Server.
  • Create data: You can use actions such as “Create item” and “Create record” to create new data in various systems such as SharePoint, Dynamics 365, and Common Data Service.
  • Update data: You can use actions such as “Update item” and “Update record” to update existing data in various systems such as SharePoint, Dynamics 365, and Common Data Service.
  • Delete data: You can use actions such as “Delete item” and “Delete record” to delete data from various systems such as SharePoint, Dynamics 365, and Common Data Service.

These data operations can automate data-related tasks in your organization, such as syncing data between systems, updating records in a database, and more. By using these actions in a flow, you can create powerful automation that saves time and improve productivity.

Run a cloud flow

To run a cloud flow in Power Automate, follow these steps:

  1. Open Power Automate: Go to the Power Automate website and sign in using your credentials.
  2. Select the Flow: Find and select the flow that you want to run.
  3. Test the Flow: Before you run the flow, you may want to test it to make sure it’s working properly. You can do this by clicking on the “Test” button in the top menu and selecting “Test”.
  4. Start the Flow: Once you’re ready to run the flow, click on the “Run” button in the top menu and select “Run now”.
  5. Check the Results: Once the flow has completed running, you can check the results to see if it has executed successfully. You can do this by going to the “Runs” tab and checking the status of the most recent run. You can also view the output of the flow to see what actions were taken.

It’s important to note that some flows require certain inputs, such as connection details or input data. Make sure to provide all the necessary information to ensure the flow runs properly.


Identify Common Power Automate Components

Microsoft Power Automate is a cloud-based platform that helps automate business processes. It provides several components to help you automate workflows, manage data, and integrate systems. The main components in Power Automate are:

  • Flows: A flow is a series of steps that automate repetitive tasks, like sending an email, copying data from one place to another, or updating records.
  • Connectors: Connectors are pre-built integrations that help you connect to various services and data sources, such as SharePoint, Microsoft Teams, Dynamics 365, and more.
  • Triggers: Triggers are events that initiate a flow. They can be manual or automatic and can be based on specific conditions, like a new email or a change in a data source.
  • Actions: Actions are the steps that you want to perform in a flow. You can choose from a wide range of actions to perform operations like sending an email, creating a record, or updating data.
  • Conditions: Conditions are logical statements that determine whether a specific action should be performed or not. You can use conditions to control the flow of your automation based on certain conditions.
  • Variables: Variables are a way to store values that can be used throughout a flow. They allow you to pass values from one step to another and use them in conditions or actions.
  • Scopes: Scopes allow you to group together related steps into a single unit, making it easier to manage and organize your flows.

Identify Flow Types

Microsoft Power Automate has three main flow types: cloud flows, desktop flows, and business process flows.

  • Cloud Flows: These flows are designed to run in the cloud and are created and managed through the Power Automate portal. They are best suited for automating simple, repeatable tasks that don’t require user interaction.
  • Desktop Flows: Desktop flows are designed to run on a desktop or laptop computer and require the Power Automate desktop client to be installed. They are best suited for automating tasks that require user interaction, such as sending emails or creating tasks on a to-do list.
  • Business Process Flows: Business process flows are a type of model-driven flow that allows you to automate a specific business process. They are best suited for automating complex processes that involve multiple steps and the involvement of multiple users. Business process flows are created and managed through the Power Platform admin center.

Based on the trigger type and set of available actions flows can be classified as different types. The flow types are:

  • Automated flow: Triggered by a specific event or data change, it performs a set of actions in response.
  • Scheduled flow: Triggered by a specific time, it performs a set of actions on a recurring schedule.
  • Button flow: Triggered by a manual trigger, it performs a set of actions when a user presses a button in Power Apps.
  • Instant flow: Triggered by a manual trigger, it performs a set of actions when a user initiates the flow.
  • Business process flow: Triggered by a change in a record, it guides users through a sequence of steps.
  • UI flow: Triggered by a manual trigger, it automates manual tasks performed in legacy desktop applications or web browsers.
  • API flow: Triggered by an API request, it performs a set of actions in response to a specific API request.

Use case for Flows

Microsoft Power Automate, formerly known as Microsoft Flow, has a wide range of use cases, including:

  1. Automating repetitive manual tasks such as data entry or updating records in different systems.
  2. Integrating different applications and services, such as SharePoint, OneDrive, and Dynamics 365.
  3. Sending email notifications and alerts based on specific triggers or events.
  4. Creating approval workflows for documents, expenses, or leave requests.
  5. Automating file or data transfer between different systems or applications.

Available flow templates are pre-built flows that can be used as-is or customized to meet specific needs. These templates provide a starting point and save time in creating flows. Some examples of available templates include:

  1. Copy files from one location to another.
  2. Create and send an approval email for a new item in a list.
  3. Automatically save email attachments to OneDrive.
  4. Send a daily email digest of new items in a list.
  5. Automatically save tweets that mention a specific hashtag to a SharePoint list.

These templates provide a quick and easy way to create flows and automate processes, and they can be used as-is or adapted to meet specific requirements.

How Power Automate uses Connector, Triggers, and Actions

Power Automate uses connectors to connect with other apps and services, such as Microsoft 365, Salesforce, and Twitter. Connectors provide both triggers and actions that can be used to automate tasks between different apps.

Triggers are events or conditions that start a flow. When a trigger condition is met, a flow is started and can execute one or more actions. For example, a new email in your inbox can be a trigger that starts a flow to send a push notification to your phone.

Actions are the individual steps or tasks that make up a flow. Each connector provides a set of actions that can be used to interact with the app or service. For example, actions in the Microsoft 365 Outlook connector can be used to send an email, create a calendar event, or get a list of emails from a specific folder.

Power Automate also allows users to create custom connectors to connect with custom APIs, web services, or other services that do not have a built-in connector. Custom connectors can be used to provide additional triggers and actions for a specific service or to simplify the process of working with an existing API.

Loops and conditions including switch, do until, and apply to each

In Power Automate, loops, and conditions are used to control the flow of a workflow.

  • The “Switch” control is used to evaluate multiple conditions and execute the appropriate actions for each condition. It’s useful when you want to perform a different set of actions based on a single condition.
  • The “Do Until” control is used to loop through a set of actions until a specified condition is met. It’s useful when you want to repeat a set of actions until a specific condition is satisfied.
  • The “Apply to each” control is used to iterate over a collection of items and execute the same set of actions for each item. It’s useful when you want to perform a set of actions on each item in a collection.

These controls can be combined to create more complex workflows that perform a sequence of actions based on various conditions.


Expressions in Power Automate are a type of code that allows you to manipulate and work with data in different ways. They allow you to customize and extend the functionality of your flows by enabling you to create dynamic expressions that can be used to manipulate values, parse strings, calculate numbers, and more.

Expressions can be used in various parts of Power Automate, including actions, triggers, and conditions. They use a syntax that is similar to programming languages and can be written using functions, operators, and operands.

For example, you can use expressions to format dates, extract values from JSON objects, or calculate the difference between two dates. The expression language is designed to be simple and intuitive, and there are many resources available to help you learn how to use expressions in Power Automate.

Use case for approvals

Power Automate offers approval actions that enable users to automate the process of approving requests or documents, and thereby streamline their business processes.

Some of the use cases for approvals in Power Automate are:

  • Request approvals for time off, travel, expenses, and other business processes, and get notified when the request is approved or rejected.
  • Route documents or invoices for approval to specific people or groups, and set up reminders for overdue approvals.
  • Use approvals to trigger follow-up actions, such as sending notifications, updating records, or creating new documents.
  • Create custom approval workflows for your business processes, and tailor the approval criteria, routing rules, and notifications to your specific needs.
  • Monitor and track the status of approvals in real-time, and generate reports and analytics to identify bottlenecks and optimize your workflows.
  • Combine approvals with other actions, such as sending emails, updating spreadsheets, or creating tasks, to create end-to-end solutions for your business.

Overall, approvals in Power Automate offer a flexible and scalable way to automate your approval workflows and can help you save time, reduce errors, and increase efficiency.

Power Automate Desktop, Power Automate Mobile, and Power Automate Portal

Power Automate is a workflow automation platform that allows users to create automated workflows between different applications and services. There are several different Power Automate apps, including:

  • Power Automate Desktop: A Windows desktop application that allows users to automate tasks on their local computer or across multiple applications and services.
  • Power Automate Mobile: A mobile app that allows users to create and manage workflows on the go. Users can create new workflows, view and manage existing workflows, and receive notifications when a workflow is triggered.
  • Power Automate Portal: A web portal that allows users to create and manage workflows for external users. This app is designed for businesses that need to automate workflows for external customers, partners, or vendors.

Each of these Power Automate apps has a different use case and target audience, but they all share the same underlying technology and functionality. Users can create workflows and automate tasks using a variety of triggers and actions and can customize their workflows using advanced features like loops, conditions, and expressions.

Build a Model-Driven App

A model-driven app is a type of app in the Microsoft Power Platform that is built using the Common Data Service (CDS) and the Power Apps Maker experience. Model-driven apps are designed to support business process automation and provide a form-based interface for users to interact with data stored in the Common Data Service.

To build a model-driven app, you need to first create an entity, which is a database table that stores data in the Common Data Service. Then, you can define relationships between entities, set up security roles, and create custom forms, views, and dashboards.

Once you have created the entities and defined the relationships, you can use the Power Apps Maker experience to create a model-driven app. This involves selecting the entities you want to include in the app, creating custom forms to enter and view data, and creating custom views and dashboards to display data.

You can also extend the functionality of a model-driven app by using Power Automate flows, Power BI reports, and custom code. This allows you to automate business processes and integrate data from other sources, as well as to create custom experiences for your users.

Once you have built your model-driven app, you can publish it and make it available to users through the Power Apps portal, Microsoft Teams, or SharePoint.

Create Model-Driven App from tables

To create a model-driven app from tables in Power Platform, follow these steps:

  1. Go to the Power Platform Admin Center and select “Make a custom app”.
  2. Choose “Model-driven app” and select “Create”.
  3. Provide a name for your app and select the environment you want to create the app in.
  4. Choose the entities (tables) you want to include in the app. You can create new entities or select from existing ones.
  5. Configure the entities, including field types, relationships, and forms.
  6. Select the design for the app and customize it as needed. You can add components like dashboards, charts, and forms to your app.
  7. Preview the app and make any final changes.
  8. Publish the app.

With these steps, you can create a model-driven app that provides a centralized location for storing and accessing data in Power Platform. You can also create a user-friendly experience for accessing and manipulating data in your app.

Modify Forms

In a model-driven app, forms play a crucial role in presenting data to the users and allowing them to interact with it. The forms can be modified to match the specific needs of an organization and can be customized in various ways. This includes adjusting the layout and controls, adding or removing fields, changing the form’s behavior and appearance, and adding rules and validation to the fields.

The modifications can be done using the form editor in the Power Apps Maker portal. The form editor provides a drag-and-drop interface for adding and arranging controls on the form. It also provides options for customizing the appearance of the form, such as changing the background color, adding images and other media, and adjusting the font and size of the text.

Additionally, the form editor supports the use of conditional formatting, which allows certain fields to be displayed or hidden based on the value of other fields. This is particularly useful for creating forms that are dynamic and adapt to the context in which they are used.

Once the modifications have been made, the form can be saved and published to make it available to the users. It is important to thoroughly test the form before publishing it to ensure that it functions as expected and meets the requirements of the organization.

Modifying forms in a model-driven app can be done through the Forms section of the app design. There you can create and edit the different forms associated with each entity. You can add and remove fields, control their order, and choose the layout of the form. Additionally, you can add sections, tabs, and business rules to enhance the user experience and enforce business logic. The changes made to the forms are automatically reflected in the user interface of the app.

Create and modify Views

In a model-driven app, views are used to represent data from entities in a specific format on a form, dashboard, or a list. The creation and updation of views are important steps to customize the user experience.

To create a view, you can follow these steps:

  1. Go to the Model-driven app builder.
  2. Select the entity for which you want to create a view.
  3. Click on the Views option.
  4. Click on the “New” button to create a new view.
  5. Select the type of view you want to create (e.g. basic list view, card view, calendar view, etc.)
  6. Configure the view settings such as columns, filters, sorting, etc.
  7. Save the view.

To update a view, you can follow these steps:

  1. Go to the Model-driven app builder.
  2. Select the entity for which you want to modify the view.
  3. Click on the Views option.
  4. Click on the view you want to modify.
  5. Make the necessary changes to the view.
  6. Save the changes.

It’s also possible to apply customizations to views through the use of Power Apps Component Framework (PCF) or by using custom code.

Publish and Share an App

To publish and share a model-driven app, you need to first create the app and make sure that it meets your requirements and needs. Once you have confirmed that the app is ready, you can follow these steps to publish and share it:

  1. Go to the environment where you have created the app.
  2. From the app settings, click on ‘Publish’.
  3. The app will be published and made available to your organization.
  4. To share the app with other users, you can grant access to specific users or security groups. This can be done through the app settings in the Power Platform admin center or Microsoft 365 admin center.
  5. Users who have access to the app can now use it in their environment.

It is important to keep in mind that users must have a Power Apps or Power Apps Plan 2 license in order to use the app. Additionally, sharing and publishing of model-driven apps can be governed by the organization’s policies and guidelines for data security and privacy.