About the Course

Module 1: An Introduction to Power Platform

• Power Apps
• Power BI
• Power Automate/Flow
• Power Virtual Agents

Module 2: An Introduction to Power Automate

• What is Microsoft Power Automate?
• Features of Power Automation.
• The benefits of automation
• How to get to Power Automate?
• How to Set up Power Automate in Office 365
• What is a Flow?
• Types of Flow.
• Environment Setup

Module 3: Getting Started with Power Automate

• Exploring Power Flow Interface
• Using Power Automate Home page
• Creating Power Flow
• Navigating in Power Automate
• Editing a Power Automate
• Publish and trigger a Power Automate
• Turn off or delete a Power Automate

Module 4: Types of Automate

• Using Automated Flow
• Using Instant Flow
• Using Scheduled Flow
• Using UI Flow
• Using Business Process Flow(Papps)

Module 5: Creating Flow using Template

• Creating Flow using Templates
• Understanding flow template
• Running your first flow
• Flow Details
• Flow pages, Flow Diagrams
• Editing your flow
• Sharing your flow
• Creating Automated flow from a Template

Module 6: Creating Flows as Blank

• Creating Flow from scratch
• Creating flow Triggers
• Flow Actions
• Understanding Dynamic Contents
• Testing your flow

Module 7: Understanding Expression, Logics 

• Introduction to expressions
• Expression testing
• Adding single and multiple actions
• Working with Files
• Approval Process
• Looping, Condition
• Expression
• Variables
• Creating and Testing conditions
• Schedule Flow
• Examples of scheduled flow
• Using Different inputs
• Triggering Power Apps applications
• Testing Power Apps applications

Module 8: Built-in Functions 

• Setting Expression
• String Function – Concatenate, Substring, IndexOf, Split etc
• Collection functions
• Datetime function

Module 9: Conditions and Looping 

• Variables
• If statements
• Logical Comparison operators
• Other expression functions

Module 10: Creating UI Flows and Business Process Flow

• Understanding UI Flow
• Create and Manage UI Flow
• Benefits and limitation of UI Flows
• Creating Business Process Flow (BPF)

Module 11: Integration (Using Connectors)

• Exploring various connectors
• Standard and premium connectors
• Connecting to web services
• Using Flow with on-premises data

Module 12: Using Data

• Entities
• Connections
• Gateway
• Sharepoint Data

Module 13: Flow with Power Apps

• Using Power Apps
• Automate using Power Apps

Module 14: Good Development Practices

• Good Development Practices
• Naming and connecting
• Static results
• Documentations
• Using Physical button to trigger flow
• Trigger based on location
• Error Handling

Module 15: Deployment, Administration and Maintenance

• Maintaining a Power Automate
• View history and analytics
• Sharing a Power Automate
• Export and import Power Automates
• Office 365 administration for Power Automate
• Environments
• Data integration
• Deploying Microsoft Power Automate flows from one environment to another

RPA with Power Automate Desktop

• Introduction to the Power Automate Desktop
• How to Install Power Automate Desktop
• Create  a simple Desktop Flow
• Working with Variable Actions (Set Variable, Truncate Number, Get Random Numbers , Increase Variable , Decrease Variable , Create New List, Add Item to List, Remove Item From List, Clear List , Remove Duplicate items from  List, Reverse List, Shuffle List, Merge Lists, Subtract Lists, Find Common List items)
• Working with Conditional Actions (If and Else, If , Else If, Switch, Case, Default Case , If File / Folder  Exists and If Process )
• Working with Loops
• Working with Excel Automation
• Working with Database Automation
• Working with File Actions
• Working with Folder Actions
• Work with Compression Actions (Zip and Unzip Files)
• Work with Text Actions
• Working with Date and Time Actions
• Working with Email Automation Actions
• Working with Outlook Automation Actions
• Working with web recorder
• Working with web Automation Actions
• Working with UI Automation Actions
• Working with Desktop recorder
• Working with  PDF Automation Actions
• Working with XML Automation Actions
• We  will  learn Every action step by step with basic examples.

The intended audience for this course would be those who have been using Office 365 for some time and are now looking at optimizing their existing business processes and designing new ones.

• Understand when to use Power Automate
• Describe the components of Power Automate and their correct use
• How to create and edit Power Automates
• Benefits of Power Automate
• Integration with Power Automate

Ganesh Kannan has more than 15 years of IT experience in Software testing, test Consulting, Project and Change management. He has worked for Investment Banks like Barclays Capital and IT services firm like Zensar Technologies. He has managed the testing tools and process function for a top tier investment bank and have managed large off-shore testing teams. He possess extensive project management and consulting experience in delivering IT applications and spearheads the classroom Fundamentals of software testing in Singapore.