The Library · Insights
Deep dives across data, automation & AI
108 in-depth articles — from Excel foundations to production machine learning. Filter by topic or difficulty to find exactly what you need.
Power AppsExpert
Adding Custom Pages to Model-Driven Apps: Canvas Power in a Model-Driven Shell
Custom Pages let you embed fully expressive canvas app experiences inside model-driven apps — dashboards, bulk editors, and operational hubs that standard forms and views simply can't deliver. This lesson covers the architecture, authoring, context-passing, security, and performance patterns you need to build Custom Pages that work in production.
31 min read
Power AppsPractitioner
Customizing the Model-Driven Command Bar with Power Fx
Stop making users leave the record to trigger their most-needed actions. Learn how to add custom buttons, write dynamic visibility rules, and call Power Automate flows directly from the model-driven app command bar using Power Fx — no JavaScript required.
21 min read
Power AppsPractitioner
Formula Columns and Rollup Columns in Dataverse: Calculated Data Without Code
Learn how to embed business logic directly into your Dataverse data model using formula columns and rollup columns. Build margin calculations, pipeline aggregates, and deal status signals — no code, no flows required.
22 min read
Power AppsPractitioner
Column-Level Security and Record Sharing in Dataverse
Table-level security controls who can access records, but real production environments often need finer control — down to individual columns and specific records. This lesson teaches you how to implement Field Security Profiles, configure column-level access, and use record sharing to grant targeted exceptions without restructuring your entire security model.
25 min read
Power AppsPractitioner
Dataverse Security: Business Units, Security Roles, and Teams
Learn how to architect a production-grade Dataverse security model using business units, custom security roles, owner teams, access teams, and AAD-linked teams. This complete lesson covers real-world design patterns, privilege configuration, and troubleshooting for multi-team organizations.
24 min read
Power AppsPractitioner
Business Process Flows: Guiding Users Through Multi-Stage Processes in Power Apps
Business Process Flows (BPFs) transform inconsistent, documentation-dependent workflows into structured, in-form guidance that enforces data quality at every stage. Learn how to design, build, and deploy BPFs that actually guide users — including branching logic, stage-gating, and security configuration.
20 min read
Power AppsFoundation
Business Rules in Dataverse: Validation and Field Logic Without Code
Business Rules in Dataverse let you enforce data quality and control form behavior without writing a single line of code—but scope, condition logic, and action types have sharp edges that trip up even experienced makers. This lesson goes deep on every mechanism so you can build rules that actually work in production.
31 min read
Power AppsFoundation
Creating and Customizing Views in Model-Driven Apps: Filters, Sorting, and Editable Grids
Views are the primary lens users interact with in model-driven apps — and most of them are badly designed. Learn how to build purpose-built views with multi-condition filters, strategic sort orders, FetchXML for complex queries, and editable grids for inline record editing.
26 min read
Power AppsFoundation
Designing Model-Driven Forms: Sections, Tabs, Subgrids, and Quick View Forms
A cluttered model-driven form kills adoption before your app ever gets a chance. Learn how to design professional forms using tabs, sections, subgrids, and Quick View forms — the building blocks that turn raw Dataverse data into a tool people actually want to use.
18 min read
Power AppsFoundation
Building Your First Model-Driven App: Site Map, Tables, Forms, and Views
Learn how to build a complete model-driven app from scratch — designing tables, configuring forms with subgrids and quick views, creating operational views, and building a site map that organizes everything into a deployable, role-aware application. This is the deep-dive lesson that teaches you to think in model-driven architecture, not just click through a designer.
34 min read
Power AppsFoundation
Designing a Dataverse Data Model: Relationships, Lookups, and Choice Columns
Learn how to design production-quality Dataverse schemas using the right relationship types, lookup configurations, and choice columns. This lesson goes beyond the basics to cover cascade behavior, referential integrity, and the lookup-vs-choice decision that determines your app's long-term maintainability.
24 min read
Power AppsFoundation
Dataverse Fundamentals: Tables, Columns, and Rows Explained for Power Apps Makers
Dataverse is the cloud database that powers serious Power Apps — but only if you understand how it's organized. This lesson teaches you exactly how tables, columns, and rows work together, with hands-on exercises and real business examples that build genuine competence from scratch.
20 min read