Power Platform & Dynamics CE

Dataverse powers the heart of the Microsoft Power Platform, offering a rich relational data layer and a suite of tools for makers and developers. While low-code configurations can solve many business needs, there comes a point when complex business logic demands more. Enter Custom APIs—your way to encapsulate server-side logic in a secure, reusable, and solution-aware package. Combine this with Field Mapping—which ensures automatic data population between related tables—and you unlock a powerful pattern for building sophisticated enterprise apps. In this post, we’ll do a deep technical dive into: What Custom APIs and Field Mapping are Why they’re better together Real-world scenarios Best practices Pitfalls to avoid What is a Custom API? Custom APIs let you define your own operations in Dataverse, complete with input/output parameters and server-side logic. Unlike workflows or Power Automate flows, they’re built for high performance and enterprise ALM. Features of Custom APIs Entity-bou...

Field Mapping in Microsoft Dataverse is one of those features that rarely gets the spotlight—but it’s a game changer for building robust, user-friendly solutions in the Power Platform. Whether you’re a pro developer or a low-code maker, understanding and using Field Mapping properly can save hours of development time, simplify user experiences, and improve data consistency. In this blog, we’ll break down what Field Mapping is, how it works under the hood, its advantages and limitations, and real-world scenarios where it shines. What Is Field Mapping? In Microsoft Dataverse, Field Mapping is a feature of table relationships (1\:N or N:1) that lets you automatically copy data from a parent record to a new child record. When a user creates a new record from within the context of a related parent (like clicking + New Contact from an Account form), the system can pre-fill the child form with values from the parent record. This is done without a single line of code. How Does Field Mapping Wo...

Microsoft Dataverse (the backbone of the Power Platform) offers incredible flexibility for building business solutions. But for every Dynamics 365 or Power Apps maker, there’s often one confusing question: “When should I use Field Mapping, and when should I use Business Rules?” These two features may sound similar, but they serve very different purposes in customizing your Dataverse solutions. Let’s break them down with a technical deep dive, real-world scenarios, and best practices. What Are Field Mapping and Business Rules? Field Mapping: Auto-Populate Child Records What is it ? Field Mapping in Dataverse allows you to auto-fill fields in a child entity with values from the parent entity when creating a related record. Example: When creating a Contact from within an Account, you want the Address1 fields to copy over automatically. How It Works Go to Tables → Relationships in Dataverse. Select a relationship (1\:N or N:1). Click Mappings. Map fields between parent and child tables (mu...

 Imagine having your data not just stored—but intelligently understood, categorized, and responded to—all inside Dataverse. That’s exactly what Prompt Columns bring to the Power Platform: a seamless fusion of structured data and Generative AI. In this post, we’ll dive into what Prompt Columns are, how they work, and how you can use them to supercharge your apps with AI, all without needing to be a data scientist. What Are Prompt Columns in Dataverse? Prompt columns are a brand-new column type in Dataverse that allow you to generate values using AI prompts. Unlike traditional fields that rely on user entry or formulas, prompt columns use AI models to populate values based on your instructions. Key Capabilities: Start with a simple prompt (e.g., “Classify this feedback as positive, negative, or neutral”). Use Copilot to help draft your instructions. Choose from basic to premium AI models or bring in custom Azure AI models. Provide context (i.e., “knowledge”) using other fields in th...

In Microsoft Dataverse, data integrity and uniqueness are critical for building scalable, enterprise-grade apps. While Dataverse ensures every row has a system-generated GUID as its primary key, real-world business scenarios often require natural identifiers like Customer Numbers or Email Addresses to enforce uniqueness. This is where Keys in Dataverse—both primary and alternate—become essential. In this guide, we’ll deep dive into:  What keys are in Dataverse  Technical details for developers  Strategic insights for architects  Real-world use cases  Limitations and best practices What Are Keys in Dataverse? A key in Dataverse defines a column (or set of columns) that enforces uniqueness in a table. This means no two rows can have the same value for the key column(s). There are two types of keys in Dataverse: Primary Key (System-Managed) Every Dataverse table automatically includes a GUID primary key (e.g., `contactid`, `accountid`).  Assigned automatically...