Course Outline
Introduction to Microsoft Power Automate
- Understanding Power Automate.
- Available editions and usage contexts.
- Cloud (online) versus desktop workflows.
- The advantages of automation.
- Low-Code and No-Code paradigms.
Workflow Modes
- Automated flows and their triggers.
- Recurring flows and schedule management.
- Instant flows initiated by user actions.
- Integrating Power Automate with Office 365 apps.
Hands-On with Microsoft Power Automate
- Initial setup and getting started.
- Navigating the application interface.
- Building automation from templates.
- Constructing workflows from scratch, step by step.
- Creating cloud-based workflows using the Data Service Connector.
- Modifying existing workflows.
- Publishing and activating flows.
- Enabling and disabling workflows.
Workflows within Office 365 Applications
- Integration with the Office 365 ecosystem.
- Online flows in SharePoint 365.
- Workflows for Outlook 365 email.
- Automation features in OneDrive for Business.
- Workflows in 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.
- Overseeing document workflows.
- Utilizing the Teams application.
- Task approvals in Teams.
Automation in Practice
- Power Platform data connectors: standard vs. premium.
- Implementing triggers.
- Defining actions.
- Conditional logic using IF and SWITCH functions.
- List operations: the "Apply to each" feature.
- Programming loops using Do/Until logic.
- Working with expressions and variables.
- Expression functions: strings, numbers, and time.
Flow Administration and Maintenance
- Flow management.
- Maintenance procedures.
- Reviewing performance history, analyzing metrics, and diagnosing errors.
- Sharing workflows: exporting and importing.
- Managing the workflow environment.
Requirements
A general-purpose course designed for professionals involved in processing and analyzing large datasets, including analysts, accountants, software developers, and testers. The curriculum covers topics such as 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.
