Course Outline
Introduction to Microsoft Power Automate
- Overview of Power Automate
- Available versions and applicable use cases
- Differences between Cloud (online) and Desktop workflows
- The key advantages of automation
- Understanding Low-Code and No-Code workflows
Workflow Types
- Automated flows and their triggers
- Cyclic flows and schedule management
- Instant flows initiated by user actions
- Integration with Office 365 applications
Using Microsoft Power Automate
- Initial steps with Power Automate
- Navigating the application interface
- Automating processes using templates
- Building a workflow from scratch step by step
- Creating cloud-based workflows with the Data Service Connector
- Editing existing workflows
- Publishing and activating flows
- Toggling workflow status
Workflows in Office 365 Apps
- Integration strategies for Office 365
- Online flows in SharePoint 365
- Workflows for Outlook 365 email management
- Automation capabilities 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
- Handling document workflows
- Integration with the Teams application
- Task approval processes in Teams
Practical Automation
- Power Platform data connectors: standard and premium
- Implementing triggers
- Configuring actions
- Conditional logic using IF and SWITCH functions
- List operations using the 'apply to each' function
- Programming loops with Do/Until logic
- Using expressions and variables
- Expression functions for strings, numbers, and time
Flow Administration and Maintenance
- Flow management techniques
- Maintenance best practices
- Performance history review, analysis, and error diagnosis
- Workflow sharing through export and import
- Understanding the workflow environment
Requirements
This general-purpose training is designed for professionals involved in processing and analyzing large datasets, including analysts, accountants, software developers, and testers. The curriculum also covers topics related to working with SQL Server.
Testimonials (7)
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.
Alex
Course - Microsoft Power Automate
The structure was very well designed to suit beginners like myself, and gradually increase the complexity of topics to demonstrate interesting and relevant use cases that are all applicable in my work.
Luminita
Course - Microsoft Power Automate
Shaun's adaptability to questions and scenarios proposed by the group.
Ethan Bennett - Sustainalytics
Course - Microsoft Power Automate
That is was very interactive, Shaun was very open to listen and answer to every question we had, in some cases he offered tips also outside the scope of the training (i.e. Power Automate desktop, Power Apps, Power Bi). Shaun as a trainer has a really natural style, it was not like "following a script and lecture" - this made the training really comfortable and not formal at all.
Aniko - Sustainalytics
Course - Microsoft Power Automate
it is really useful, i have learned a lot and it's application is unlimited
