Answered

Is there a schema of pre-set standard entities of Common Data Model?

(0) Share

Report

Posted on by summitb

I am developing a schema for Model-based PowerApps application. Since we need to re-use lots of pre-set standard entities of the Common Data Model like account, organization etc, I was wondering if there is any schema of these entities or Diagram to visualize the overall Common Data Model?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

v-monli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @summitb,

So far you cannot move/copy fields from standard entities to others. You will need to add the fields manually. Though you can create fields for Common Data Service for Apps using PowerApps solution explorer and use existing option set.

An option set (picklist) is a type of field that can be included in an entity. It defines a set of options. When an option set is displayed in a form it uses a drop-down list control. When displayed in Advanced Find it uses a picklist control. Sometimes option sets are called picklists by developers.

You can define an option set to use a set of options defined within itself (locally) or it can use a set of options defined elsewhere (globally) which can be used by other option set fields.

Global option sets are useful when you have a standard set of categories that can apply to more than one field. Maintaining two separate option sets with the same values is difficult and if they are not synchronized you can see errors, especially if you are mapping entity fields in a one-to-many entity relationship.

For more information, please refer to:

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/create-edit-global-option-sets

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/create-edit-field-solution-explorer

Regards,

Mona

Was this reply helpful? Yes No
summitb 2 on at

Like (0)

Report
Copy link

Link copied!

Is there a diagram of the pre-defined entities like account, contacts, organisation etc of Common Data Model?

Was this reply helpful? Yes No
Verified answer

summitb 2 on at

Like (0)

Report
Copy link

Link copied!

Used Entity Diagram Tool available in XRM toolkit to visualize the standard entities.

Was this reply helpful? Yes No