Course Outline
Introduction to Microsoft Power Automate
- Understanding Power Automate
- Available versions and usage contexts
- Cloud (online) versus desktop workflows
- The advantages of automation
- Low-code and no-code workflow paradigms
Workflow Types
- Automated flows and their triggers
- Scheduled flows and recurring tasks
- Instant flows and user-initiated actions
- Power Automate integration with Office 365 applications
Operational Use of Microsoft Power Automate
- Getting started with Power Automate
- Navigating the application interface
- Automating processes based on templates
- Building workflows from the ground up
- Creating cloud-based workflows with the Data Service Connector
- Modifying existing workflows
- Publishing and activating flows
- Enabling and disabling workflows
Workflows in Office 365 Applications
- Integrating with the Office 365 suite
- Online flows within SharePoint 365
- Workflows supporting Outlook 365 email management
- Automation capabilities 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
- Interacting with the Teams application
- Task approval processes within Teams
Practical Automation Techniques
- Power Platform data connectors: standard and premium tiers
- Incorporating triggers
- Adding actions
- Conditional logic using IF and SWITCH functions
- Iterating through lists using the Apply to each feature
- Implementing loops with Do/Until logic
- Utilizing expressions and variables
- Functions within expressions for strings, numbers, and time
Flow Administration and Maintenance
- Managing flow configurations
- Maintaining active flows
- Reviewing performance history and diagnosing errors
- Sharing workflows via export and import
- Managing the workflow environment
Requirements
This general-purpose course is designed for professionals involved in processing and analyzing large datasets, including analysts, accountants, software developers, and testers. The curriculum also covers 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.
