Dynamics 365 Dataverse : Customer Type Field
What is?
This field it's provisioned along with some of the traditional Dynamics 365 licenses (sales, customer service) and it's a specialized type of lookup field designed specifically for establish a relationship between records in different entities ("linking records") to account or contact entities, often used in the Opportunity entity.
When adding new table columns based on this field type two new relationships are added to the entity making it the interesting part of this field.
When end users uses this field they will have the choice to link only to one account or contact and they can search trough both entity records or filter only for one of them.
Trick 1: Roll-up tasks around accounts or contacts
Opportunities, Invoices, Orders, and Cases have the "Customer" field type included out of the box and that allows any task linked to one of these record types and using the "Regarding" field to be visible from the contact or account forms under activities.
On top of this we can also add the same functionality to custom entities and have tasks around a custom order or invoice records!
Trick 2: Using the Customer field for developers
Using the fetch xml with the opportunity entity, where we have a field called Customer (new_customer):
Using the XRM.WebApi to update the customer column in the opportunity entity, where we have a field called Customer (new_customer):
That calls an HTTP PATCH over https://operations-elcaniederhorn.crm4.dynamics.com/api/data/v9.0/opportunities(3cbbd39d-d3f0-ea11-a815-000d3a33f3c3)
with the payload: {"[email protected]":"/account(27c95fa8-8375-ed11-81ab-6045bd8c5759)"} and the same principle can be also used under a Power Automate flow.
Published on:
Learn moreRelated posts
Power Platform – Track, manage and scale Copilot adoption in PPAC new functionality
We are announcing an update for the Copilot Studio page in the Copilot Hub within the Power Platform admin center (PPAC). When you select an a...
Microsoft 365 & Power Platform Community Call – January 15th, 2026 – Screenshot Summary
Call Highlights SharePoint Quicklinks: Primary PnP Website: https://aka.ms/m365pnp Documentation & Guidance SharePoint Dev Videos I...
New Content Moderation Settings for AI Prompts in Microsoft Copilot Studio and Power Platform
We are announcing the ability to configure content moderation levels for AI prompts in Microsoft Copilot Studio and Power Platform. This featu...
Microsoft 365 & Power Platform Call (Microsoft Speakers) – January 13th, 2026 – Screenshot Summary
Call Highlights SharePoint Quicklinks: Primary PnP Website: https://aka.ms/m365pnp Documentation & Guidance SharePoint Dev Videos Issues...
What Copilot “Agents” Change for Real Automation in D365 & Power Platform?
For a long time, enterprise automation has promised speed, accuracy, and scope. In reality, though, most automation projects slow down early a...
Microsoft 365 & Power Platform Community Call – January 8th, 2026 – Screenshot Summary
Call Highlights SharePoint Quicklinks: Primary PnP Website: https://aka.ms/m365pnp Documentation & Guidance SharePoint Dev Videos Issues...
Designing Secure Power Platform Solutions with Dataverse Security Roles
Understanding Dataverse Security Roles is essential for anyone working with Microsoft Power Platform and Dynamics 365—whether you are a busine...
Power Platform admin center – Manage external authentication provider governance
We are announcing the ability of new controls, in the Power Platform admin center, that let admins select which external identity providers ca...
Power Platform Fundamentals #1: Plan Designer in Power Platform: Architecting Enterprise Solutions the Right Way: Quick Read Series
Transforming Business Requirements into Scalable Enterprise Solutions 1. Executive Summary Large enterprises often struggle with a common prob...