Welcome to another episode of Knowledge Nuggets with Mirko Peters. In this episode, we're exploring Microsoft Power Apps, Microsoft's low-code platform for building custom business applications without traditional software development. Every organization has processes that deserve a dedicated app—equipment tracking, expense reporting, employee onboarding, inspections, approvals, or customer management. Traditionally, building these applications required software developers, long development cycles, and significant budgets. Power Apps changes that by allowing business users, citizen developers, and IT professionals to build secure business applications using visual tools, familiar Excel-style formulas, and deep integration with Microsoft 365.

WHAT IS POWER APPS?
Power Apps is part of the Microsoft Power Platform, alongside:

• Power Automate
• Power BI
• Power Pages
• Microsoft Copilot

Its purpose is simple: build business applications quickly without writing thousands of lines of code. Developers design screens visually by dragging controls such as buttons, galleries, forms, text boxes, and images onto a canvas. Logic is created using Power Fx, a formula language inspired by Microsoft Excel, making it approachable for users who already work with spreadsheets. Power Apps connects directly to Microsoft 365 services including SharePoint, Teams, Outlook, OneDrive, and Dataverse, while also supporting hundreds of external systems through connectors.

LOW-CODE DOESN'T MEAN NO-CODE
Power Apps is often described as a low-code platform. Rather than writing complex C# or JavaScript applications, users build solutions visually while adding simple formulas only where needed. If you've used Excel formulas such as IF(), SUM(), or FILTER(), you'll quickly recognize the Power Fx syntax. The goal isn't to eliminate coding completely—it is to dramatically reduce the amount of technical knowledge required to create professional business applications. This allows departments to solve their own business problems instead of waiting months for traditional software development projects. 

CANVAS APPS VS. MODEL-DRIVEN APPS
Power Apps offers two primary application models. Canvas Apps Canvas Apps begin with a blank screen. Developers decide exactly where every button, image, gallery, and control appears, providing complete flexibility over the user experience. Canvas Apps work best for:

• Mobile applications
• Inspection forms
• Approval apps
• Dashboards
• Simple business processes
• Task-specific applications

They're ideal when the user experience matters most. Model-Driven Apps Model-Driven Apps start with the data rather than the interface. Developers define tables, relationships, and business rules, while Power Apps automatically generates forms, navigation, and views. Model-Driven Apps are perfect for:

• CRM systems
• HR portals
• Asset management
• Project tracking
• Customer databases
• Complex enterprise applications

Instead of designing every screen manually, developers focus on modeling the business data.

DATAVERSE: THE FOUNDATION
Behind many Power Apps solutions is Microsoft Dataverse. Dataverse is Microsoft's cloud-native business database built specifically for the Power Platform. It provides:

• Secure tables
• Relationships
• Business rules
• Role-based security
• Data validation
• Enterprise scalability

Canvas Apps can connect to Dataverse or hundreds of other data sources. Model-Driven Apps require Dataverse as their primary data platform because they depend on its structured business data model. As organizations grow, Dataverse often becomes the preferred data source because it provides significantly more governance and scalability than spreadsheets or SharePoint lists.

CONNECTING TO BUSINESS DATA
One of Power Apps' greatest strengths is connectivity. Through more than 300 connectors, applications can integrate with:

• SharePoint
• Microsoft Teams
• Outlook
• OneDrive
• Excel
• SQL Server
• Salesforce
• SAP
• Oracle
• Google services
• Dropbox
• REST APIs
• Custom business systems

Instead of replacing existing applications, Power Apps extends them by creating modern business interfaces that connect directly to current data sources.

MICROSOFT 365 INTEGRATION
Power Apps fits naturally into the Microsoft ecosystem. Applications can run:

• Inside Microsoft Teams
• In any web browser
• On iOS and Android devices
• Embedded within SharePoint pages

Security is managed through Microsoft Entra ID, meaning users authenticate using their existing Microsoft 365 accounts. Administrators control permissions using familiar Microsoft identity management tools while the Power Platform Admin Center provides centralized governance, environment management, and Data Loss Prevention policies. This deep integration allows organizations to deploy business applications without introducing separate identity systems or security models.

BUILDING YOUR FIRST APP
Creating a Power App is remarkably simple. Users can begin with an Excel spreadsheet or SharePoint list. Power Apps automatically generates:

• A Browse screen
• A Details screen
• An Edit screen

From there, developers customize colors, branding, layouts, business rules, and navigation while Power Apps handles much of the underlying application framework automatically. What once required weeks of custom software development can often be completed in less than an hour.

AI AND COPILOT IN POWER APPS 
Power Apps has changed dramatically with the introduction of Microsoft Copilot. Instead of manually designing every application, developers can now describe the app they want using natural language. For example: "Create an expense approval application with manager approvals and monthly reporting." Copilot can generate:

• Screens
• Navigation
• Tables
• Business logic
• Forms
• Power Fx formulas

Copilot also assists users inside running applications by summarizing records, generating visualizations, answering questions about business data, and helping users find information faster. With the 2026 Wave 1 release, Copilot became generally available for Model-Driven Apps and introduced autonomous AI agents capable of coordinating routine business activities with minimal user intervention.

Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-a-microsoft-mvp-podcast-by-mirko-peters--6704921/support.