Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

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

Posted on by

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:
  • Verified answer
    summitb Profile Picture
    summitb on at
    Re: Is there a schema of pre-set standard entities of Common Data Model?

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

  • summitb Profile Picture
    summitb on at
    Re: Is there a schema of pre-set standard entities of Common Data Model?

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

  • v-monli-msft Profile Picture
    v-monli-msft on at
    Re: Is there a schema of pre-set standard entities of Common Data Model?

    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



Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,591

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,090

Leaderboard