Step into the future of productivity with our Power Automate training! Learn how to streamline repetitive tasks, connect your favorite apps and services, and build powerful automated workflows — all without writing a single line of code.
Introduction to Power Platform & Licensing
• Overview of Power Platform: Power Automate, Power Apps, Power BI
• Understanding the Microsoft ecosystem (M365, Dataverse, SharePoint)
• Types of connectors: Standard vs Premium
• Power Platform licensing overview:
- Power Automate per user, per flow
- Power Apps per app, per user
- Power BI Pro, Premium
• Demo: Navigating Power Automate portal
• Hands-on: Sign up and environment setup
Power Automate with SharePoint – Basics
• SharePoint Lists vs Libraries: structure & fields
• Triggers and actions in SharePoint
• Build a basic flow:
- Trigger: When an item is created
- Action: Send an email with item details
• Hands-on:
- Create a SharePoint list
- Build & test a flow
• Use Case: Leave application approval notification
Advanced SharePoint Automation
• Conditional logic and expressions
• Using parallel branches, scopes, and switches
• Lookup another list item using 'Get Items'
• Use Case: Auto-update manager info from Employee list
• Hands-on: Build a flow to auto-fill metadata
Approval Workflows
• Types of approvals: Start and wait vs Create/Wait separately
• Multi-level approvals with conditions
• Timeout & Reassign functionality
• Hands-on:
- Build a multi-stage leave approval flow
• Use Case: Purchase Request approval with finance and admin
Error Handling & Flow Optimization
• Using 'Configure Run After'
• Retry policy, Scopes for try-catch logic
• Flow performance tips
• Logging flow execution to SharePoint or Excel
• Use Case: Robust data sync between two SharePoint lists
• Hands-on: Build a flow with full error handling
Power Apps & Power Automate Integration
• Intro to Power Apps: canvas vs model-driven
• Connect Power Apps with SharePoint
• Trigger a flow from Power Apps
• Pass parameters from app to flow
• Use Case: Employee submits IT request form from Power App
• Hands-on: Design Power App → trigger flow → store in SharePoint
Power BI Integration
• Intro to Power BI: Desktop vs Service
• Connecting Power BI with SharePoint List
• Schedule refresh & dataflow basics
• Power Automate triggers from Power BI alerts
• Use Case: Trigger email when KPI threshold exceeded
• Hands-on:
- Create Power BI report
- Link alert → trigger Power Automate flow
Approvals & Task Automation in Power Apps
• Customize forms with Power Apps
• Use Power Apps for viewing pending tasks
• Hands-on: Create task approval interface in Power Apps
• Use Case: Service request dashboard for managers
Use Cases & Best Practices
• Multiple platform use cases:
- Vacation request system
- Asset approval workflow
- Automated invoice approval and archiving
• Use of OneDrive, Outlook, Teams in flows
• Governance and security best practices
• Hands-on: Combine SharePoint + Outlook + Teams in one flow
Project | Questions & Answers
• Group mini-project:
- Requirement gathering
- Build: Flow + App + BI Report
- Demo presentation
• Review of licensing boundaries
• Real-world deployment tips
• Final Q&A & Certification of Completion
Course Fee
● Online 12,000/- Total
- Once paid, the fee is non-refundable and non-transferable
Account Details
Bank: Habib Bank Limited
Account Title: AIN GenX
Account No: 5910-70000512-03
IBAN No: PK08 HABB 0059 1070 0005 1203