Working with N:N Relationships
In the world of business applications, relationships between entities play a crucial role in structuring and managing data efficiently. Microsoft Dynamics 365 and Microsoft Dataverse, the underlying data platform for….
Tag: Entity Relationships
Best Practices for Entity Mappings
Entity mappings form the backbone of applications that use object-relational mapping (ORM) to interact with relational databases. These mappings translate between in-memory objects and database records, ensuring that application data….
Using Configuration Migration Tool
The Configuration Migration Tool in Microsoft Dynamics 365 and the Power Platform is a powerful utility designed to assist administrators, developers, and consultants in migrating configuration data between different environments…..
Lookup not resolving selected value
When using lookup fields in Power Pages, the field may fail to resolve or display the selected value, and this can result in confusion and a poor user experience. This….
Subgrids and Quick View Forms
Table of Contents 1. Introduction to Subgrids Subgrids are powerful components in Dynamics 365 that allow you to display related entity records directly on a form. They provide a convenient….
Calculated and Rollup Fields
Introduction One of the fundamental goals of data management and business applications is to extract meaningful insights from the data. Microsoft Dataverse, the underlying data platform that powers Power Apps,….
Lookup vs Option Set vs Two Options
Introduction Data modeling is the foundation of every successful business application, and choosing the right type of field (column) in your data tables can have a profound effect on performance,….
Custom Entity Creation and Relationships
Introduction At the core of any application in Microsoft Power Platform and Dynamics 365 lies its data structure—defined by entities (now known as tables in Dataverse). While Microsoft provides a….
Multi-Table Lookups and Design Patterns
Multi-Table Lookups — At a Glance Multi-table lookups occur when a field (or lookup) in a table can reference data in more than one other table. They’re used to model….
Polymorphic Lookups in Dataverse
1. Introduction to Polymorphic Lookups Polymorphic lookups (also called “party list” fields) in Dataverse allow a single lookup field to reference multiple entity types. This powerful feature enables flexible relationship….