Course Outline
Introduction to Microsoft Power Automate
- Understanding Power Automate
- Available versions and usage contexts
- Differences between cloud (online) and desktop workflows
- The advantages of automation
- Low-code and no-code workflow concepts
Workflow Modes
- Automated flows and their triggers
- Cyclic flows and schedule management
- Instant flows and user-initiated actions
- Integrating Power Automate with Office 365 applications
Working with Microsoft Power Automate
- Getting started with Power Automate
- Navigating the application interface
- Automating tasks using existing templates
- Building workflows from scratch, step-by-step
- Creating cloud-based workflows using the Data Service Connector
- Editing existing workflows
- Publishing and launching flows
- Enabling and disabling workflows
Workflows in Office 365 Applications
- Integration strategies with Office 365
- Implementing online flows in SharePoint 365
- Creating workflows for Outlook 365 email management
- Leveraging automation in OneDrive for Business
- Utilising workflows within the Forms application
- Connecting to external web services
- Creating flows for the Dataverse service
SharePoint 365 Workflows
- Managing lists and document libraries
- Implementing file approval and versioning processes
- Overseeing document workflows
- Collaborating via the Teams application
- Approving tasks within Teams
Automation in Practice
- Data connectors in Power Platform: standard and premium tiers
- Adding triggers to flows
- Incorporating actions
- Implementing conditional logic: IF and SWITCH functions
- Managing lists using 'apply to each' functionality
- Programming loops using Do/Until logic
- Utilising expressions and variables
- Applying functions within expressions: strings, numbers, and time
Administration and Maintenance of Flows
- Managing flow configurations
- Maintaining flow integrity
- Reviewing performance history, analysing metrics, and diagnosing errors
- Sharing workflows through export and import
- Managing the workflow environment
Requirements
This is a general-purpose training course designed for professionals involved in processing and analysing large datasets, including analysts, accountants, software developers, and testers. The curriculum includes 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.
