Microsoft 365 Developer Team Training

1. Introduction to Microsoft Power Platform and Power Apps
2. Understanding Canvas apps, model-driven apps, and Microsoft Dataverse
3. Power Apps licensing, environments, and developer setup
4. Exploring Power Apps Studio and the app-building interface
5. Creating apps from blank, templates, SharePoint, and Dataverse
6. Understanding data sources and standard versus premium connectors
7. Connecting apps to SharePoint, Excel, Dataverse, Outlook, and OneDrive
8. Working with screens, navigation, app properties, and themes
9. Designing responsive layouts using containers
10. Working with text inputs, labels, buttons, and selection controls
11. Using date pickers, checkboxes, toggles, and other input controls
12. Building galleries to browse and display records
13. Creating new, edit, and display forms
14. Working with images, attachments, camera, and barcode controls
15. Building reusable components and component libraries
16. Previewing, saving, publishing, and sharing apps

1. Understanding Power Fx syntax, operators, and data types
2. Working with global variables, context variables, and With()
3. Creating and managing collections
4. Understanding tables, records, and record scope
5. Searching and filtering records with Filter(), Search(), and LookUp()
6. Sorting data and displaying unique values
7. Building conditional logic with If(), Switch(), and related functions
8. Working with text, date, and mathematical functions
9. Creating and updating records with Patch() and SubmitForm()
10. Updating, deleting, and refreshing data
11. Managing form modes, resets, and validation
12. Building navigation, notifications, and user-specific experiences
13. Working with ForAll(), Sequence(), and Concurrent()
14. Transforming tables with column and grouping functions
15. Introduction to JSON, ParseJSON(), and user-defined functions
16. Understanding delegation and improving app performance
17. Handling errors and troubleshooting formulas
18. Applying naming conventions and formula-writing best practices

Build a practical business solution using Power Apps, SharePoint, and Power Automate.

1. Understanding Power Apps and SharePoint integration
2. Preparing SharePoint lists for app development
3. Working with SharePoint column types and attachments
4. Customizing SharePoint list forms with Power Apps
5. Creating tabbed forms and multi-section layouts
6. Building repeating-table scenarios
7. Submitting data to multiple SharePoint lists
8. Creating cascading dropdowns and dynamic filters
9. Implementing form validation and business rules
10. Controlling field visibility and editability
11. Retrieving logged-in user information
12. Creating role-based app experiences and reviewing SharePoint permissions
13. Adding search, sorting, and filtering to galleries
14. Building dashboards and navigation menus
15. Integrating Power Automate with Power Apps
16. Exporting and importing customized SharePoint forms

1. Introduction to Microsoft Dataverse and model-driven apps
2. Creating tables, columns, and relationships
3. Building your first model-driven app
4. Configuring forms, views, and the Power Apps grid
5. Creating charts and dashboards
6. Implementing business rules and business process flows
7. Integrating Power Automate with Dataverse
8. Understanding Dataverse security roles
9. Working with business units, teams, and record sharing
10. Importing data and introducing dataflows
11. Creating and managing solutions
12. Understanding managed versus unmanaged solutions
13. Working with environment variables and app migration
14. Exporting, importing, and upgrading solutions
15. Introduction to Power Apps Component Framework: architecture and use cases
16. Setting up PCF tooling and creating a first custom control
17. Introduction to React and Fluent UI for PCF development
18. Testing, debugging, packaging, and deploying PCF controls
19. Final project review, troubleshooting, and development best practices

1. Introduction to Microsoft Power Automate and business automation
2. Understanding automated, instant, scheduled, and desktop flows
3. Power Automate licensing and subscription overview
4. Understanding Power Platform environments
5. Exploring the Power Automate portal and cloud flow designer
6. Understanding standard and premium connectors
7. Working with SharePoint, Outlook, Teams, Excel, OneDrive, and Dataverse connectors
8. Understanding connections and authentication methods
9. Creating flows from scratch, templates, and Copilot
10. Working with triggers, actions, and dynamic content
11. Introduction to expressions and expression syntax
12. Testing expressions using the Compose action
13. Initializing, setting, incrementing, and appending variables
14. Building decision logic with Condition and Switch
15. Working with Apply to each and Do until loops
16. Using string, array, and date-time functions
17. Grouping actions using Scope
18. Testing flows, reviewing run history, and troubleshooting errors

1. Introduction to SharePoint automation with Power Automate
2. Working with SharePoint item creation, modification, and deletion triggers
3. Creating, retrieving, and updating SharePoint list items
4. Working with SharePoint Person and Lookup columns
5. Managing SharePoint files and document libraries
6. Uploading, moving, renaming, and deleting files
7. Using trigger conditions to control flow execution
8. Filtering records using OData queries
9. Optimizing Get items actions and handling large lists
10. Understanding approval actions and approval types
11. Building first-to-respond and everyone-must-approve workflows
12. Creating multi-level sequential approvals
13. Configuring custom approval responses
14. Capturing approval decisions and comments
15. Designing reminder, escalation, reassignment, and cancellation scenarios
16. Integrating approvals with Microsoft Teams and Microsoft Forms
17. Customizing approval emails and monitoring approval history
18. Implementing error handling with Scope and a try–catch pattern

1. Introduction to AI Builder and AI-powered automation
2. Understanding AI Builder use cases and model types
3. AI Builder licensing and credits overview
4. Understanding model inputs, outputs, and confidence scores
5. Exploring prebuilt AI models
6. Using invoice-processing models in cloud flows
7. Extracting information from receipts and forms
8. Using text recognition in automation scenarios
9. Introduction to custom AI models
10. Creating document-processing models
11. Training, testing, and publishing prediction models
12. Exploring category classification models
13. Introduction to object detection scenarios
14. Understanding prompts in Microsoft Power Platform
15. Creating, editing, sharing, and managing prompts
16. Using prompts inside Power Automate flows
17. Working with AI-generated outputs in subsequent flow actions
18. Combining AI processing with business workflow steps

1. Introduction to robotic process automation and Power Automate Desktop
2. Understanding cloud flows versus desktop flows
3. Installing and setting up Power Automate Desktop
4. Exploring the desktop flow designer and available actions
5. Creating and running your first desktop flow
6. Working with desktop flow variables and data types
7. Building logic using conditions, loops, and Switch
8. Automating Excel data reading, writing, and updates
9. Managing data tables in desktop flows
10. Working with PDF extraction, merging, and splitting actions
11. Automating email tasks using Outlook actions
12. Building web automation and data extraction scenarios
13. Exploring SharePoint automation from desktop flows
14. Connecting desktop flows with cloud flows
15. Exporting, importing, and managing desktop flows
16. Introduction to solutions in Power Automate
17. Reviewing and troubleshooting an end-to-end automation project
18. Final project demonstration and individual feedback

1. Introduction to Generative AI, AI Agents, and Business Use Cases
2. Understanding Microsoft Copilot, Copilot Studio, and Power Platform
3. Exploring the Latest Copilot Studio Authoring Experience and UI Changes
4. Navigating Build, Preview, Evaluate, and Monitor Where Available
5. Understanding Licensing, Capacity, Environments, and Admin Prerequisites
6. Setting Up Your Tenant and Creating Your First Agent
7. Defining Agent Purpose, Scope, Audience, Tone, and Boundaries
8. Writing Effective Natural-Language Agent Instructions
9. Understanding Generative Orchestration and Agent Decision-Making
10. Creating Reusable Skills in the Supported Agent Experience
11. Building Skills with Guided Authoring and Markdown or ZIP Uploads
12. Understanding Topics and Designing Structured Conversation Logic
13. Grounding Agents with SharePoint, Dataverse, Files, and Websites
14. Preparing Knowledge Content and Improving Grounded Responses
15. Configuring Authentication and Knowledge Access Permissions
16. Designing Clarification Questions, Fallback Responses, and Escalation
17. Exploring Available AI Models and Model-Selection Considerations
18. Testing Conversations and Refining Instructions, Skills, and Knowledge
19. Applying Responsible-AI Practices and Handling Unsupported Requests
20. Build a Real Service Agent with Instructions, Skills or Topics, and Knowledge Grounding

1. Adding Agent Tools Using Connectors, Custom Actions, and Power Automate
2. Configuring Tool Descriptions, Inputs, Outputs, Connections, and Permissions
3. Building Inventory-Lookup and Order-Status Tools
4. Configuring Supported Microsoft 365 Actions for Email, Meetings, and Documents
5. Handling Tool Errors and Confirming Sensitive or Data-Changing Actions
6. Connecting Agents and Designing Multi-Agent Delegation Scenarios
7. Integrating MCP Servers and Reviewing External-Tool Security
8. Exploring the Workflow Designer and Combining Structured Steps with Agent Capabilities
9. Configuring Supported Scheduled, Email, and Event-Based Triggers
10. Passing Data Between Agents, Tools, and Workflows
11. Building Notification, Approval, and Store-Operations Workflows
12. Testing Workflow Steps, Troubleshooting Failures, and Managing Versions
13. Inspecting Agent Activity Traces, Tool Calls, and Execution Results
14. Creating Test Sets and Evaluating Agent Quality and Reliability
15. Monitoring Usage, Analytics, Errors, and Task-Completion Outcomes
16. Applying Governance Controls, Data Policies, and Available Agent Review Processes
17. Managing Agent Owners, Collaboration, Authentication, and Access
18. Publishing to Supported Teams, Microsoft 365 Copilot, Demo Website, and Embedded Channels
19. Preparing Deployment Checks, a Best-Practices Checklist, and a 30-Day Adoption Roadmap
20. Build, Test, Review, and Publish a Retail Agent with an Integrated Workflow

1. Introduction to SharePoint Framework and Microsoft 365 Extensibility
2. Understanding SPFx Architecture, Supported Platforms, and Development Prerequisites
3. Setting Up the Development Environment with Compatible Node.js, npm, and Yeoman Versions
4. Understanding the Modern Heft-Based Build Toolchain
5. Creating Your First SPFx Client-Side Web Part
6. Exploring Solution Structure, Configuration Files, and Component Manifests
7. Working with Web Part Context, Properties, and Lifecycle Methods
8. Building Web Part Interfaces with React Components
9. Styling Web Parts with Scoped SCSS and Responsive Layouts
10. Configuring Property Panes, Default Properties, and Preconfigured Entries
11. Running, Testing, and Debugging Web Parts in SharePoint
12. Building and Packaging a Web Part for Initial App Catalog Deployment

1. Working with SharePoint REST APIs Using SPHttpClient
2. Configuring PnPjs for SharePoint Data Access in SPFx
3. Implementing List Item Create, Read, Update, and Delete Operations
4. Working with Lists, Libraries, Columns, and Common Field Types
5. Uploading Files and Managing Document Library Content
6. Implementing Filtering, Sorting, Paging, and Efficient Data Retrieval
7. Handling Asynchronous Operations, Loading States, and API Errors
8. Accessing Microsoft Graph Using MSGraphClient
9. Requesting API Permissions and Managing Administrator Approval
10. Retrieving Microsoft 365 User and Organizational Information
11. Integrating External APIs Using HttpClient and AadHttpClient
12. Hands-on Project: Build a SharePoint Business App with Data Operations and Microsoft Graph Integration

1. Using SPFx-Compatible Fluent UI React Components
2. Building Business Forms with Input, Selection, and Date Controls
3. Implementing Form Validation, Submission Feedback, and Error Messages
4. Displaying Records with Details Lists, Selection, and Command Actions
5. Designing Navigation with Tabs, Menus, and Breadcrumbs
6. Working with Panels, Dialogs, and Contextual Actions
7. Using PnP React Controls for People, Lists, Sites, and Taxonomy Selection
8. Building File-Upload and Document-Management Interfaces
9. Creating Reusable Components and Shared Library Components
10. Connecting Web Parts with SPFx Dynamic Data
11. Applying Theme Support, Accessibility, and Responsive Design
12. Hands-on Project: Build a Business Dashboard with Search, Forms, and Document Views

1. Understanding SPFx Extension Types and Their Use Cases
2. Building Application Customizers for Page-Level Experiences
3. Building Field Customizers for List Column Rendering
4. Building ListView Command Sets for Custom List and Library Actions
5. Building Form Customizers for New, Edit, and Display Forms
6. Configuring Extension Registration, Association, and Deployment
7. Introduction to Adaptive Card Extensions for Viva Connections
8. Exposing SPFx Web Parts as Microsoft Teams Tabs
9. Designing Host-Aware Experiences for SharePoint and Teams
10. Managing App Catalogs, Tenant-Wide Deployment, and skipFeatureDeployment
11. Updating Solutions, Managing Versions, and Reviewing Production Security and Performance
12. Capstone Project: Package and Deploy a Business Solution with a Web Part, Extension, and Teams Experience