Lesson 1: Introduction to Power Apps and Dynamic Content

• Overview of Power Apps
• Licensing and access requirements
• How Power Apps integrates with Microsoft 365 and SharePoint

Lesson 2: Getting Started with Power Apps Studio

• Launching and navigating Power Apps Studio
• Creating a new Canvas app (tablet or phone layout)
• Connecting to SharePoint as a data source (including Search Library and UserProfiles lists)
• Saving, publishing, and sharing apps
• Understanding app versioning and management

Lesson 3: Building the Main Screen and User Interface

• Adding and configuring screens
• Inserting headers, tables, and galleries
• Displaying current user profile information dynamically
• Using containers for layout and navigation tabs for multi-screen apps

Lesson 4: Data Sources and Connectors

Power Apps supports a wide range of data sources, enabling you to build apps that connect to and interact with business data across your organisation and beyond. Key connectors include:

• SharePoint: For document libraries, lists, and profile-based content filtering.
• Excel Online (Business): Use Excel files stored in OneDrive or SharePoint as app data sources.
• Microsoft Dataverse: The recommended data platform for scalable, secure, relational data storage.
• Outlook / Office 365: Integrate with email, calendar, and contacts for workflow automation.
• OneDrive for Business: Access and manage files stored in OneDrive.
• Microsoft Teams: Build apps that interact with Teams channels, messages, and meetings.
• Power BI: Embed dashboards and reports, or trigger actions based on analytics.
• Adobe Sign / DocuSign: Enable electronic signature workflows within your apps (premium connectors).
• Custom Connectors: Build your own connector to integrate with any REST API or proprietary system.

Lesson 5: Filtering, User-Driven Views, and Interactivity

• Connecting to multiple SharePoint lists
• Using formulas such as LookUp() to retrieve user-specific metadata
• Filtering data tables and galleries based on user profile
• Creating dropdown controls for user-driven filtering
• Understanding limitations of data tables and workarounds using galleries

Lesson 6: Functions, Formulas, and App Logic

• Introduction to Power Apps formulas and logic
• Using variables and named formulas to manage state (e.g., sorting fields, toggling sort direction)
• Applying formulas to controls and data for dynamic behaviour
• Adding interactivity: sorting galleries by column headers, enabling file links, and customising UI

Lesson 7: App Publishing, Sharing, and Embedding in SharePoint

• Saving and publishing your app in Power Apps Studio
• Sharing apps and managing permissions
• Embedding Power Apps in SharePoint pages using the Power Apps web part
• Publishing and updating SharePoint pages with embedded apps

Lesson 8: Best Practices, Limitations, and Next Steps

• Limitations of Power Apps controls (e.g., data tables vs. galleries for clickable links)
• Workarounds and tips for richer user experiences
• Best practices for app design, layout, and navigation
• Resources for further learning and advanced topics (e.g., Power Automate integration)