Wilson Mar bio photo

Wilson Mar


Email me Calendar Skype call

LinkedIn Twitter Gitter Instagram Youtube

Github Stackoverflow Pinterest

Power Automate is Microsoft’s low-code RPA (Robotic Process Automation) product

US (English)   Español (Spanish)   Français (French)   Deutsch (German)   Italiano   Português   Cyrillic Russian   中文 (简体) Chinese (Simplified)   日本語 Japanese   한국어 Korean


Get Started on 365

Alternately, if you’re a 365 Administrator, sign in using your Microsoft 365 credentials (@inmicrosoft.com) at:


  1. If you have an Office 365 user account, sign on to:


  2. Click the menu icon (9 dots), then “All apps” and “Power Automate”.

    Power Automate

    us.flow us.flow
    o365-menu-203x500.png powerapp-menu-408x938

    Expansion of items:

    Action Items:

    • Approvals
    • Business process flows


    • Tables
    • Connections
    • Custom connectors
    • Gateways


    • Cloud flow activity
    • Desktop flow runs
    • Desktop flow queues
    • Machines

    AI Builder:

    • Build
    • Models
    • Document automation (preview)

    Process advisor:

    • Create
    • Processes

    “My Flows” = My Worlflow Process

    “Power Automate” is the 2019 rebranding of “Microsoft Flow” introduced in 2016.

    Power Automate replaced SharePoint 2010 Flows on November 2020.

    Each “Flow” is a distinct workflow (automated).

    Power Automate is the designer GUI for Flows.

  3. On the left menu, click + Create from blank:


    That’s similar to “New flow” at another menu:


    Process Advisor

    Process Advisor requires a “Premium” license.

    Flow Types

    “Cloud flows”

    • “instant” manually triggered by human action
    • automated event driven flows
    • scheduled to run at a particular day/time

    • Desktop flows (also called “RPA flows” for Windows 10 users)
    • Business Process flows (aka Guided multi-step flows controlling Microsoft’s Dynamics 365 process)

    Microsoft charges $500/month for five flows used by an unlimited number of users.

    Flows can be created using PowerAppsMaker templates.

    AI Builder

    Each Flow is processed by a bot (as in robot) created using “AI Builder”.

    Microsoft charges $150 per bot per month, which include 5,000 AI Builder service credits. Additional credits are $500 per month.


    PROTIP: Know the cost implications of different Flow types at

    “Power Automate Desktop is available to Windows 10 users at no additional cost” means that you can install it, but using it and creating “Flows” for others to run requires licensing.

    There are two types of Flows (RPA):

    • Attended RPA (actually DPA)
    • Unattended RPA

    RPA and DPA serve different but complementary purposes in an organization’s overall business process management (BPM) strategies and initiatives. Unlike RPA, DPA is not intended to fully replace tasks completed by humans.

    Power Platform Components

  4. Open another browser tab

    “Power Automate” is one of Microsoft’s “Power Platform” offerings for citizen developers to use the low-code development platform:

    Feature Component Name
    database store Microsoft Dataverse DaaS (Database as a Service) common data services
    external interfaces Connectors to exchange data with established and custom APIs
    AI/ML form processing AI Builder -
    automation Power Automate Desktop RPA (UI Flows designer)
    app dev Power Apps low-code custom mobile/web app development environment
    analytics and visualization Power BI -
    chatbots Power Virtual Agent and visualization -


    VIDEO: Microsoft Power Platform YouTube channel

  5. Register for Microsoft’s Power Automate user group:


    There are discussion threads for each Power component.

    QUESTION: Use for functional testing and performance testing?

  6. Look at the marketing page about “Robotic Process Automation”:


    Get trial tenant account

  7. Click “Start Free” at


  8. PROTIP: Only work or school account are allowed (no personal accounts) even for trial accounts.

  9. Type your work email, Next,

    Production site

  10. PROTIP: Only work or school account are allowed (no personal accounts) to access:


  11. Choose your country/region and click “Get started”.


  12. The Environment is at the upper-right.

    This lab describes how to create a new practice environment.



    Portal provisioning takes 30 to 45 minutes.


Power Automate is Microsoft’s offering in the RPA (Robotic Processing Automation) market. But RDA.

Charles Lamanna’s demo at Ignite Nov 19, 2019 https://www.youtube.com/watch?v=o8s1_qlzzd4


Microsoft Dataverse is a scalable data service and app platform which lets users securely store and manage data from multiple sources and integrate that data in business applications using a common data model to ensure ease and consistency to users. Microsoft Dataverse is the common currency that enables the components of Microsoft Power Platform to work together. It’s the foundation that enables the consolidation, display, and manipulation of data.

Connectors enable you to connect apps, data, and devices in the cloud. Among the more than 275 connectors are Salesforce, Office 365, Twitter, Dropbox, Google services, SharePoint, Outlook, and YouTube. Premium connectors require additional licensing SQL Server, Survey Monkey, and Mail Chimp.

<tt>All   Built-in   Standard   Premium   Custom   My clipboard</tt>

DOCS: Custom connectors can be built to call a publicly available API, or a custom API hosted in a cloud provider. Custom connectors can be used in Power Apps, Power Automate, and Azure Logic Apps. Custom connectors can reference an OpenAPI definition or a Postman collection.

Power Apps provides a rapid low code development environment for building custom apps for business needs. It has services, connectors, and a scalable data service and app platform (Microsoft Dataverse) to allow simple integration and interaction with existing data. Power Apps enables the creation of web and mobile applications that run on all devices, but with a simple interface.

Power Automate is used to automate repetitive business processes such as communication, data collections, and decision approvals.

Triggers are only used in Power Automate and prompt a flow to begin. Triggers can be time based, such as a flow which begins every day at 8:00 am, or they could be based off of an action like creating a new row in a table or receiving an email. You will always need a trigger to tell your workflow when to run.

Actions are used in Power Automate and Power Apps. Actions are prompted by the user or a trigger and allow interaction with your data source by some function. For example, an action would be sending an email in your workflow or app or writing a new line to a data source.

Power Virtual Agents is used to create chatbots using a guided, no-code graphical interface, without the need for data scientists or developers. It minimizes the IT effort required to deploy and maintain a custom solution by empowering subject matter experts to build and maintain their own conversational solutions. Power Virtual Agents is part of Microsoft Power Platform, therefore integration into existing systems is streamlined with out-of-the-box integration with Power Automate and its ecosystems of hundreds of connectors. Users can enable chatbots to perform an action by simply calling a Power Automate flow. Flows help users automate activities or call back end systems. Users can utilize existing flows that have been created in their Power Apps environment or they can create a flow within Power Virtual Agents authoring canvas.

Power BI (Business Intelligence) is a business analytics service that delivers insights for analyzing data. It can share those insights through data visualizations which make up reports and dashboards to enable fast, informed decisions. Power BI scales across an organization, and it has built-in governance and security allowing businesses to focus on using data more than managing it.

You can consider Power BI as the analysis and insights leg of Microsoft Power Platform. It takes business data and allows you to display it in ways that makes the most sense to users. A Power BI dashboard could potentially replace a standing meeting to report out on company metrics such as sales data, progress against goals, or employee performance.

RPA in a Day


Microsoft’s “RPA in a Day” is beginner-level hands-on training designed to on-board and train everyone, in a single day using UI flow. Microsoft Partners can deliver the content.

  1. Download zip file “RPAinADay - Student.zip”


  2. Expand it:

    |-- RPA\ in\ a\ Day\ -\ Release\ Notes.docx
    |-- lab\ manuals\ in\ pdf
    |   |-- Lab\ 1.1\ Prerequisite\ -\ Setup\ Tenant\ and\ environment.pdf
    |   |-- Lab\ 1.2\ Prerequisite\ -\ Create\ a\ browser\ profile.pdf
    |   |-- Lab\ 1.3\ Prerequisite\ -\ Install\ required\ software.pdf
    |   |-- Lab\ 10\ Run\ the\ scenario\ in\ unattended\ mode.pdf
    |   |-- Lab\ 11\ (Optional)\ Error\ handling.pdf
    |   |-- Lab\ 12\ (Optional)\ Monitor\ desktop\ flow\ runs\ and\ manage\ gateway\ queue.pdf
    |   |-- Lab\ 2\ How\ to\ generate\ insights\ to\ optimize\ and\ automate\ your\ process\ using\ process\ advisor.pdf
    |   |-- Lab\ 3\ Create\ your\ first\ Power\ Automate\ Desktop\ flow.pdf
    |   |-- Lab\ 4\ Use\ Input\ and\ Output\ Parameters.pdf
    |   |-- Lab\ 5\ Use\ desktop\ flow\ in\ a\ cloud\ flow\ (create\ gateway,\ connection).pdf
    |   |-- Lab\ 6\ Use\ Outlook\ email\ to\ trigger\ desktop\ flows\ and\ pass\ input.pdf
    |   |-- Lab\ 7\ Add\ AI\ model\ to\ process\ invoice\ forms.pdf
    |   |-- Lab\ 8\ Integrate\ with\ teams\ to\ get\ approval.\ E2E\ integration.pdf
    |   `-- Lab\ 9\ Automate\ web\ scenario\ using\ Power\ Automate\ Desktop.pdf
    |-- student\ lab\ data\ packages
    |   |-- ContosoInvoicingSetup.exe
    |   |-- ContosoInvoicingSetup.msi
    |   |-- Lab\ #10\ email\ attachments\ to\ use\ for\ unattended
    |   |   |-- Contoso_INVOICE_(Fabrikam_UK).jpg
    |   |   |-- Contoso_INVOICE_(Litware_CAN).jpg
    |   |   |-- Contoso_INVOICE_(Proseware_NY).jpg
    |   |   |-- Contoso_INVOICE_(TailSpin).jpg
    |   |   `-- Contoso_INVOICE_(WingTip).jpg
    |   |-- Lab\ #2\ Solutions\ to\ import\ for\ process\ advisor
    |   |   `-- RPAinadayProcessAdvisor-1-0-0-2.zip
    |   |-- Lab\ #6,7,8,10\ email\ attachment\ to\ use
    |   |   `-- newinvoice.JPG
    |   |-- Lab\ #7\ Training\ Data\ for\ AI\ builder\ for\ lab\ #7
    |   |   |-- Contoso_INVOICE_(Fabrikam_UK).pdf
    |   |   |-- Contoso_INVOICE_(Litware_CAN).pdf
    |   |   |-- Contoso_INVOICE_(Proseware_NY).pdf
    |   |   |-- Contoso_INVOICE_(TailSpin).pdf
    |   |   |-- Contoso_INVOICE_(WingTip).pdf
    |   |   `-- newinvoice.JPG
    |   |-- Lab\ #8\ Advanced\ Topic\ -\ Adaptive\ Cards\ code
    |   |   `-- AdaptiveCard-lab8.json
    |   `-- Lab\ #9\ excel\ file\ to\ use\ in\ Power\ Automate\ Desktop
    |       `-- Contoso\ Invoices.xlsx
    `-- ~$A\ in\ a\ Day\ -\ Release\ Notes.docx

Module 1: Overview and prerequisites

Module 2: Identify automation opportunities and process bottlenecks using process advisor

Module 3: Build your first Power Automate Desktop flow

Module 4: Use input and output parameters

Module 5: Trigger your Power Automate Desktop flow

Module 6: Integration with Outlook connector

Module 7: Use AI builder to process invoice forms

Module 8: Create approvals using Microsoft Teams connector and adaptive cards

Module 9: Web and Microsoft Excel automation using Power Automate Desktop

Module 10: (Optional) Run Power Automate Desktop flows in unattended mode

Module 11: (Optional) Enhanced error handling in Power Automate Desktop (new)

Module 12: (Optional) Monitor Desktop flow runs and manage gateway queues (new)

PL-900 Certification Exam

https://docs.microsoft.com/en-us/learn/certifications/power-platform-fundamentals/#certification-exams $99

https://docs.microsoft.com/en-us/learn/certifications/power-platform-fundamentals/ “Microsoft Certified: Power Platform Fundamentals”

https://github.com/MicrosoftLearning/PL-900-Microsoft-Power-Platform-Fundamentals by chandler syal

9 hour “Microsoft Power Platform Fundamentals” to Learn the business value and product capabilities of Microsoft Power Platform. Create simple Power Apps, connect data with Microsoft Dataverse (formerly Common Data Service), build a Power BI Dashboard, automate a process with Power Automate, and build a chatbot with Power Virtual Agents.

PL-100 App Maker


PL-200 Functional Consultant


  • LAB[PL-200]_M00L00_Validate_Lab_Environment.md
  • LAB[PL-200]_M03L01_Create_an_app.md
  • LAB[PL-200]_M03L02_Create_entities.md
  • LAB[PL-200]_M03L03_Create_relationships.md
  • LAB[PL-200]_M03L04_Additional_entity.md
  • LAB[PL-200]_M04L01_App_Designer.md
  • LAB[PL-200]_M04L02_Modify_forms.md
  • LAB[PL-200]_M04L03_Modify_views.md
  • LAB[PL-200]_M04L04_Build charts.md
  • LAB[PL-200]_M04L05_Build_dashboard.md
  • LAB[PL-200]_M04L06_Build_Canvas.md
  • LAB[PL-200]_M04L07_Work_with_data.md
  • LAB[PL-200]_M04L08_UX.md
  • LAB[PL-200]_M05L01_Users.md
  • LAB[PL-200]_M05L02_Security_roles.md
  • LAB[PL-200]_M05L03_Business_rule.md
  • LAB[PL-200]_M05L04_Adv_Business_Rules.md
  • LAB[PL-200]_M05L05_Flow.md
  • LAB[PL-200]_M05L06_Approval_flow.md
  • LAB[PL-200]_M05L07_BPF.md
  • LAB[PL-200]_M05L08_Branching_BPF.md
  • LAB[PL-200]_M06L01_PVA.md
  • LAB[PL-200]_M07L01_Bulk_Delete.md
  • LAB[PL-200]_M07L02_Word_template.md
  • LAB[PL-200]_M07L03_Excel_template.md
  • LAB[PL-200]_M07L04_Duplicate.md
  • LAB[PL-200]_M07L05_Import_data.md
  • LAB[PL-200]_M07L06_Export_data.md

PL-400 Developer


PL-600 Solution Architect


Microsoft Dataverse


Power Apps


Power Apps Portals


Canvas Apps


Model-driven app


Power Automate


VIDEO: Cartoon illustration of what Power Automate Flow can do with API connectors:

  1. Recognize a new Twitter follower
  2. Sends a nice reply
  3. Adds the name ot a spreadsheet
  4. Email the spreadsheet to you
  5. Adds spreadsheet contents to Salesforce or Dynamics 365 CRM.

Microsoft Power Automate overview

Power Automate Desktop - Invoice Processing Microsoft Power Platform

https://www.youtube.com/watch?v=4ZnI0_atYUo Power Automate Approval Workflow Basics Reza Dorrani

by Jon Levesque

  • https://www.youtube.com/watch?v=GMk7xe3-9zc Microsoft Power Automate Introduction
  • https://www.youtube.com/watch?v=5000Kw7aIRc Microsoft Power Automate Tutorial - Flow + Forms + Teams = Awesome

https://www.youtube.com/watch?v=8O68-cc-QNo Top 25 Power Automate flow tips and tricks for 2021 - hidden gems and new features by Reza Dorrani


on Microsoft Power Platform YouTube channel

Use cases

https://www.youtube.com/watch?v=IQ_KpBC8fwo How to use Microsoft Power Automate Desktop - Full tutorial Feb 9, 2021 by Kevin Stratvert

VIDEO: Power Automate Desktop - Invoice Processing

How to use

  1. Install Power Automate Desktop
  2. Define steps
  3. Record
  4. Replace text with variables

Workflow Automate Auzure itself

  1. Login
  2. Open Power BI Desktop
  3. Click Performance Analyzer
  4. Collect metrics and save it to historical data.
  5. Display metrics with historical data.


Power Virtual Agents


Chatbot with Power Virtual Agents


https://www.youtube.com/watch?v=nWxguR5B5-s How to Build (automated, no code) Chatbots with Microsoft Power Virtual Agents Microsoft Mechanics

Power BI


https://www.youtube.com/watch?v=DRfxM6B62Gw Python in Power BI 2018



Videos Referenced

https://www.youtube.com/watch?v=8O68-cc-QNo&list=RDCMUCvBYTqRx-n_8KzFO0MJlUVw&start_radio=1&rv=8O68-cc-QNo Top 25 Power Automate flow tips and tricks for 2021 - hidden gems and new by Reza Dorrani

https://www.youtube.com/watch?v=SUsik0FGzI0&list=RDCMUCJtUOos_MwJa_Ewii-R3cJA&start_radio=1&rv=SUsik0FGzI0 Feb 16, 2021 Learn to Use Power Automate with Examples | Create Bulk PDF Files | Planner to Outlook Leila Gharani

More about Azure

This is one of a series about Azure cloud: