Course Outline
Introduction to Microsoft Power Automate
- Understanding Power Automate.
- Available versions and deployment scenarios for Power Automate.
- Cloud (online) versus desktop workflows.
- The advantages of process automation.
- Low-code and no-code workflow development.
Workflow Modes
- Automated flows and flow triggers.
- Recurring flows and schedule management.
- Instant flows initiated by user actions.
- Integrating Power Automate with Office 365 applications.
Operating Microsoft Power Automate
- Getting started with the Power Automate interface.
- Navigating the application environment.
- Implementing automation using pre-built templates.
- Building custom workflows from scratch, step by step.
- Creating cloud-based workflows using Data Service Connectors.
- Modifying and editing existing workflows.
- Publishing and activating flows.
- Toggling workflow status (enabling/disabling).
Workflows within Office 365 Applications
- Integration strategies for Office 365.
- Configuring online flows in SharePoint 365.
- Automating Outlook 365 email processes.
- Leveraging automation in OneDrive for Business.
- Utilising workflows in Microsoft Forms.
- Connecting to external web services.
- Building flows for the Dataverse service.
SharePoint 365 Workflows
- Managing lists and document libraries.
- Implementing file approval and version control.
- Overseeing document workflow management.
- Integrating with the Microsoft Teams application.
- Handling task approvals within Teams.
Practical Automation
- Utilising data connectors in the Power Platform: standard and premium tiers.
- Configuring flow triggers.
- Implementing workflow actions.
- Conditional logic using IF and SWITCH functions.
- Processing lists with the "Apply to each" functionality.
- Implementing logic loops using Do/Until structures.
- Working with expressions and variables.
- Expression functions for strings, numbers, and time.
Flow Administration and Maintenance
- General flow management.
- Ongoing flow maintenance.
- Monitoring performance history, analysing metrics, and diagnosing errors.
- Sharing workflows through export and import processes.
- Managing the workflow environment.
Requirements
This general-purpose course is designed for professionals involved in processing and analysing large datasets, including analysts, accountants, software developers, and testers. The curriculum covers 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.
