Entities in Dynamics 365 and Power Platform


In this article, we will see what entity is, different types of entities and how to identify entities in Dynamics 365 and Power Platform

What is an entity

An entity is an abstraction from the physical implementation of database tables. It is a combination of multiple tables where you can combine data from multiple sources or single source. It has structure like your database table such as fields, index, calculated columns.

Types of entities in Dynamics 365 F&O

  • Standard entity – Standard entities are developed by Microsoft and if you want to add or modify then you need to create an extension.
  • Composite entity. Composite entity is allowing you to build a single entity by leveraging multiple entities that are related to each other. The concept is heavily used in scenarios where an entity can be represented as a single document, like Sales header/line, Invoice header/line and Vendor Catalog.
  • Custom entity – Custom entity allows to build/ develop according to your business need.
  • Virtual entity – Virtual Entity allows you to represent data from external systems natively in Dynamics without the data actually residing in the database. 

Types of entities in Dynamics 365 CE

  • Standard entity – Standard entities are developed by Microsoft and it can be used for general purpose.
  • Activity Type entity – A special type of entity which is used to store all the interaction with the customer and have special party list attributes like From, Sender, Regarding… etc.
  • Virtual entity – Virtual Entity allows you to represent data from external systems natively in Dynamics without the data actually residing in the database. 

How to identify entities in Power Platform

TypePrefixExample
Virtual entitymserp_Mserp_hcmworkerentity
Dataverse/cds entitycdm_cdm_worker

If you like this article, feel free to share it with others who might find it helpful! If you have any questions, feel free to reach out to me.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a website or blog at WordPress.com

Up ↑

%d bloggers like this: