Loading...

Dynamics 365 Dataverse : Customer Type Field

Dynamics 365 Dataverse : Customer Type Field
Dynamics 365 Dataverse : Customer Type Field joao.neto Thu, 01/18/2024 - 15:04
Body

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.

Customer Field Relationships

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.

Field Usage

 

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.

Related 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):

XRM WebApi

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.

 

 

Image
/sites/default/files/2024-02/NewCustomerColumn.png

Published on:

Learn more
Need help with this product?

We can help you with Dynamics 365 Dataverse : Customer Type Field

If you want help implementing, troubleshooting, or improving this product, contact us and we’ll point you in the right direction.

Featured Articles | Dynamics Chronicles
Featured Articles | Dynamics Chronicles

Welcome to our blog, the content is entirely dedicated to Microsoft Dynamics 365, CRM, Power Platform, Common Data Service (CDS) but also Azure. Follow us !

Share post:

Related posts

Dynamics 365 plugins for Copilot Cowork: an admin setup checklist

The ERP, Sales and Customer Service plugins bring Dynamics 365 data into Copilot Cowork through MCP servers. What to configure, and where it b...

12 hours ago

Migrate a Power Pages site to the enhanced data model with PAC CLI

A step-by-step guide to moving a Power Pages site off the adx_ tables with pac pages migrate-datamodel: modes, ALM sequence, remediation and r...

12 hours ago

Copilot features retiring from Power Apps and Power Automate

Between November 30 and December 31, 2026, several in-studio Copilot and collaboration features disappear. What goes, what stays and what to u...

12 hours ago

Unmanaged developer environments are ending: what to do before December 15

Unmanaged developer environments can no longer be created, are suspended on December 15, 2026 and deleted in January. Who is affected and how ...

8 days ago

Backfill Dataverse prompt columns on existing records

Prompt columns only ran on new or updated rows. A bulk option now fills existing records as a system job: the two settings, the steps and the ...

8 days ago

Reveal a masked Dataverse column with Dataverse.Unmask

A new Power Fx function lets authorised users of a canvas app reveal one masked Dataverse value on demand, while column security stays in char...

8 days ago

Generative pages in model-driven apps: a practical guide

What generative pages are, where they stand in November 2026, the two ways to build them, the code they produce, and the limits to plan for.

11 days ago

Big Update — CRMJetty Dynamics 365 Portal Now Comes with Powerful New Integrations

Enterprise portals are evolving rapidly. They are no longer mere portals through which CRM records can be viewed. Portals are now expected to ...

8 months ago

Power Apps Code Apps in Practice: Recreating Model-Driven App Patterns

Power Apps Code Apps went from preview to general availability in record time. With that, Microsoft has sent a clear signal that it is taking ...

8 months ago

Newsletter

Get the latest Dynamics 365 and Power Platform content in your inbox

A curated digest of community blogs, product news, videos, and podcasts — delivered without the noise.

Weekly updates Unsubscribe anytime Fresh community picks
We use your email only for the newsletter and you can unsubscribe at any time.
By subscribing, you agree to the privacy policy.