Course Outline
Introduction to Microsoft Power Automate
- Understanding what Power Automate is.
- Available versions and usage scenarios for Power Automate.
- Cloud (online) and desktop-based workflows.
- The advantages of automation.
- Low-Code and No-Code workflow concepts.
Workflow Modes
- Automated flows and their triggers.
- Cyclic flows and schedule management.
- Instant flows triggered by user actions.
- Using Power Automate with Office 365 applications.
Working with Microsoft Power Automate
- Getting started with Power Automate.
- Navigating the application interface.
- Automating processes based on templates.
- Creating workflows from scratch, step by step.
- Building cloud-based workflows using the Data Service Connector.
- Editing existing workflows.
- Publishing and activating flows.
- Enabling and disabling specific workflows.
Workflows in Office 365 Applications
- Integration with Office 365.
- Online flows in SharePoint 365.
- Workflows supporting Outlook 365 email.
- Automation features in OneDrive for Business.
- Workflows within the Forms application.
- Connecting to web services.
- Creating flows for the Dataverse service.
SharePoint 365 Workflows
- Managing lists and document libraries.
- File approval and version control.
- Managing document workflows.
- Integration with the Teams application.
- Approving tasks within Teams.
Practical Automation
- Data connectors in the Power Platform: standard and premium tiers.
- Adding triggers to workflows.
- Incorporating actions.
- Conditional logic: IF and SWITCH functions.
- Working with lists using the "apply to each" functionality.
- Programming loops using Do/Until logic.
- Expressions and variables.
- Functions within expressions: handling strings, numbers, and time.
Flow Administration and Maintenance
- Managing flows.
- Maintenance practices for flows.
- Reviewing performance history, analyzing performance, and diagnosing errors.
- Sharing workflows through export and import features.
- Understanding the workflow environment.
Requirements
This general-purpose training is designed for individuals who process and analyze large volumes of data, including analysts, accountants, software developers, and testers. The curriculum includes topics related to working with SQL Server.
Testimonials (7)
The most valuable takeaway was learning how to apply the concepts in real-world scenarios and understanding the tools and processes.
Marcel Tansae - DB Technology
Course - Microsoft Power Automate
The most valuable takeaway is the way I can work with the Power Automate tool to increase my efficiency
Adrian Dumitrascu - DB Technology
Course - Microsoft Power Automate
Understanding how to interact with the tool and learn about its capabilities
Sofia Ioana Gheorghe - DB Technology
Course - Microsoft Power Automate
Lot's of hands on and collaboration in Teams rooms
Daniel Savu - DB Technology
Course - Microsoft Power Automate
Useful and practical, the knowledge gained in training can be applied immediately.
Daria
Course - Microsoft Power Automate
The training was clear, practical and well structured. Shaun explained the concepts very effectively and answered all questions with patience. 10/10 trainer.
Bogdan M
Course - Microsoft Power Automate
The fast-paced action and the depth of the explanations. Also, a modern approach that stimulates growth and trial and error.