Course Outline
Introduction to Microsoft Power Automate
- Understanding the fundamentals of Power Automate.
- Exploring available editions and deployment scenarios.
- Distinguishing between cloud (online) and desktop workflows.
- Evaluating the key benefits of automation.
- Overview of Low-Code and No-Code paradigms.
Workflow Modes
- Configuring automated flows and setting up triggers.
- Managing cyclic flows and schedule handling.
- Implementing instant flows for user-triggered actions.
- Integrating Power Automate with Office 365 applications.
Practical Application of Microsoft Power Automate
- Initial setup and getting started.
- Navigating the application interface.
- Automating processes using pre-built templates.
- Building custom workflows from scratch, step by step.
- Creating cloud-based workflows leveraging the Data Service Connector.
- Modifying and editing existing workflows.
- Process for publishing and launching flows.
- Toggling workflow states (enable/disable).
Workflows within Office 365 Applications
- Deep integration with the Office 365 suite.
- Implementing online flows in SharePoint 365.
- Developing workflows that support Outlook 365 email functionality.
- Leveraging automation features in OneDrive for Business.
- Creating workflows within the Forms application.
- Establishing connections to web services.
- Building flows for the Dataverse service.
SharePoint 365 Specific Workflows
- Managing lists and document libraries.
- Implementing file approval and version control.
- Overseeing document workflow management.
- Collaboration workflows involving the Teams application.
- Task approval processes within Teams.
Automation in Practice
- Utilizing standard and premium data connectors in Power Platform.
- Implementing triggers effectively.
- Adding and configuring actions.
- Logic control using conditional execution: IF and SWITCH functions.
- Processing list data using the 'apply to each' functionality.
- Implementing programming loops with Do/Until logic.
- Utilizing expressions and variables.
- Applying functions for string, number, and time manipulation in expressions.
Flow Administration and Maintenance
- Strategies for managing flows.
- Best practices for flow maintenance.
- Performance monitoring: viewing history, analyzing metrics, and diagnosing errors.
- Workflow sharing: techniques for exporting and importing.
- Understanding 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 includes practical exposure to working with SQL Server.
Testimonials (7)
Power Automate can reduce human error and save time
Bounkhong Vongbouakham - Lane Xang Minerals
Course - Microsoft Power Automate
I liked that all participants were asked to complete a matrix to identify and rank potential automation projects - this helped me a lot to see what is possible. I also feel that I better understand how each action works in a flow so I have more confidence to build my own flows.
Lisa Phommasane - Lane Xang Minerals
Course - Microsoft Power Automate
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.