Microsoft Power Apps · Schema

Contact

Person with whom a business unit has a relationship, such as a customer, supplier, or colleague. Corresponds to the contact entity type in the Microsoft.Dynamics.CRM namespace.

Business ApplicationsCloudEnterpriseLow-CodeMicrosoftNo-CodePower PlatformSaaS

Properties

Name	Type	Description
contactid	string	Unique identifier of the contact.
firstname	string	First name of the contact.
lastname	string	Last name of the contact.
fullname	string	Full name of the contact, combining first name, middle name, and last name.
middlename	string	Middle name or initial of the contact.
nickname	string	Nickname of the contact.
salutation	string	Salutation for correspondence with the contact.
suffix	string	Suffix used in the contact's name.
jobtitle	string	Job title of the contact.
department	string	Department or business unit where the contact works.
emailaddress1	string	Primary email address for the contact.
emailaddress2	string	Secondary email address for the contact.
emailaddress3	string	Alternate email address for the contact.
telephone1	string	Main phone number for the contact.
telephone2	string	Second phone number for the contact.
telephone3	string	Third phone number for the contact.
mobilephone	string	Mobile phone number for the contact.
fax	string	Fax number for the contact.
websiteurl	string	Website URL for the contact.
description	string	Additional information to describe the contact.
gendercode	integer	Gender of the contact. 1 = Male, 2 = Female.
familystatuscode	integer	Marital status of the contact. 1 = Single, 2 = Married, 3 = Divorced, 4 = Widowed.
birthdate	string	Birthday of the contact.
anniversary	string	Anniversary date of the contact.
spousesname	string	Name of the contact's spouse or partner.
numberofchildren	integer	Number of children the contact has.
address1_name	string	Descriptive name for the primary address.
address1_line1	string	First line of the primary address.
address1_line2	string	Second line of the primary address.
address1_line3	string	Third line of the primary address.
address1_city	string	City for the primary address.
address1_stateorprovince	string	State or province for the primary address.
address1_postalcode	string	ZIP code or postal code for the primary address.
address1_country	string	Country or region for the primary address.
address1_county	string	County for the primary address.
address1_telephone1	string	Main phone number for the primary address.
address1_fax	string	Fax number for the primary address.
address1_latitude	number	Latitude value for the primary address.
address1_longitude	number	Longitude value for the primary address.
address2_name	string	Descriptive name for the secondary address.
address2_line1	string	First line of the secondary address.
address2_line2	string	Second line of the secondary address.
address2_line3	string	Third line of the secondary address.
address2_city	string	City for the secondary address.
address2_stateorprovince	string	State or province for the secondary address.
address2_postalcode	string	ZIP code or postal code for the secondary address.
address2_country	string	Country or region for the secondary address.
preferredcontactmethodcode	integer	Preferred method of contact. 1 = Any, 2 = Email, 3 = Phone, 4 = Fax, 5 = Mail.
donotemail	boolean	Whether the contact allows direct email.
donotphone	boolean	Whether the contact allows phone calls.
donotfax	boolean	Whether the contact allows faxes.
donotpostalmail	boolean	Whether the contact allows direct mail.
donotbulkemail	boolean	Whether the contact allows bulk email through campaigns.
donotsendmm	boolean	Whether the contact accepts marketing materials.
creditlimit	number	Credit limit of the contact.
creditonhold	boolean	Whether the credit for the contact is on hold.
statecode	integer	Status of the contact. 0 = Active, 1 = Inactive. Inactive contacts are read-only.
statuscode	integer	Status reason for the contact. 1 = Active, 2 = Inactive.
createdon	string	Date and time when the contact record was created.
modifiedon	string	Date and time when the contact record was last updated.
versionnumber	integer	Version number of the contact record.
_parentcustomerid_value	string	Lookup property for the parent customer (account or contact) associated with this contact.
_ownerid_value	string	Lookup property for the user or team assigned to manage the record.
_transactioncurrencyid_value	string	Lookup property for the currency associated with the record.
yomifirstname	string	Phonetic spelling of the first name (Japanese).
yomilastname	string	Phonetic spelling of the last name (Japanese).
yomimiddlename	string	Phonetic spelling of the middle name (Japanese).
yomifullname	string	Phonetic spelling of the full name (Japanese).

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/Contact",
  "title": "Contact",
  "type": "object",
  "description": "Person with whom a business unit has a relationship, such as a customer, supplier, or colleague. Corresponds to the contact entity type in the Microsoft.Dynamics.CRM namespace.",
  "properties": {
    "contactid": {
      "type": "string",
      "format": "uuid",
      "readOnly": true,
      "description": "Unique identifier of the contact.",
      "example": "500123"
    },
    "firstname": {
      "type": "string",
      "maxLength": 50,
      "description": "First name of the contact.",
      "example": "example_value"
    },
    "lastname": {
      "type": "string",
      "maxLength": 50,
      "description": "Last name of the contact.",
      "example": "example_value"
    },
    "fullname": {
      "type": "string",
      "maxLength": 160,
      "readOnly": true,
      "description": "Full name of the contact, combining first name, middle name, and last name.",
      "example": "example_value"
    },
    "middlename": {
      "type": "string",
      "maxLength": 50,
      "description": "Middle name or initial of the contact.",
      "example": "example_value"
    },
    "nickname": {
      "type": "string",
      "maxLength": 100,
      "description": "Nickname of the contact.",
      "example": "example_value"
    },
    "salutation": {
      "type": "string",
      "maxLength": 100,
      "description": "Salutation for correspondence with the contact.",
      "example": "example_value"
    },
    "suffix": {
      "type": "string",
      "maxLength": 10,
      "description": "Suffix used in the contact's name.",
      "example": "example_value"
    },
    "jobtitle": {
      "type": "string",
      "maxLength": 100,
      "description": "Job title of the contact.",
      "example": "example_value"
    },
    "department": {
      "type": "string",
      "maxLength": 100,
      "description": "Department or business unit where the contact works.",
      "example": "example_value"
    },
    "emailaddress1": {
      "type": "string",
      "format": "email",
      "maxLength": 100,
      "description": "Primary email address for the contact.",
      "example": "[email protected]"
    },
    "emailaddress2": {
      "type": "string",
      "format": "email",
      "maxLength": 100,
      "description": "Secondary email address for the contact.",
      "example": "[email protected]"
    },
    "emailaddress3": {
      "type": "string",
      "format": "email",
      "maxLength": 100,
      "description": "Alternate email address for the contact.",
      "example": "[email protected]"
    },
    "telephone1": {
      "type": "string",
      "maxLength": 50,
      "description": "Main phone number for the contact.",
      "example": "example_value"
    },
    "telephone2": {
      "type": "string",
      "maxLength": 50,
      "description": "Second phone number for the contact.",
      "example": "example_value"
    },
    "telephone3": {
      "type": "string",
      "maxLength": 50,
      "description": "Third phone number for the contact.",
      "example": "example_value"
    },
    "mobilephone": {
      "type": "string",
      "maxLength": 50,
      "description": "Mobile phone number for the contact.",
      "example": "example_value"
    },
    "fax": {
      "type": "string",
      "maxLength": 50,
      "description": "Fax number for the contact.",
      "example": "example_value"
    },
    "websiteurl": {
      "type": "string",
      "format": "uri",
      "maxLength": 200,
      "description": "Website URL for the contact.",
      "example": "https://www.example.com"
    },
    "description": {
      "type": "string",
      "maxLength": 2000,
      "description": "Additional information to describe the contact.",
      "example": "A sample description."
    },
    "gendercode": {
      "type": "integer",
      "description": "Gender of the contact. 1 = Male, 2 = Female.",
      "enum": [
        1,
        2
      ],
      "example": 1
    },
    "familystatuscode": {
      "type": "integer",
      "description": "Marital status of the contact. 1 = Single, 2 = Married, 3 = Divorced, 4 = Widowed.",
      "enum": [
        1,
        2,
        3,
        4
      ],
      "example": 1
    },
    "birthdate": {
      "type": "string",
      "format": "date",
      "description": "Birthday of the contact.",
      "example": "2026-01-15"
    },
    "anniversary": {
      "type": "string",
      "format": "date",
      "description": "Anniversary date of the contact.",
      "example": "2026-01-15"
    },
    "spousesname": {
      "type": "string",
      "maxLength": 100,
      "description": "Name of the contact's spouse or partner.",
      "example": "example_value"
    },
    "numberofchildren": {
      "type": "integer",
      "description": "Number of children the contact has.",
      "example": 10
    },
    "address1_name": {
      "type": "string",
      "maxLength": 200,
      "description": "Descriptive name for the primary address.",
      "example": "example_value"
    },
    "address1_line1": {
      "type": "string",
      "maxLength": 250,
      "description": "First line of the primary address.",
      "example": "example_value"
    },
    "address1_line2": {
      "type": "string",
      "maxLength": 250,
      "description": "Second line of the primary address.",
      "example": "example_value"
    },
    "address1_line3": {
      "type": "string",
      "maxLength": 250,
      "description": "Third line of the primary address.",
      "example": "example_value"
    },
    "address1_city": {
      "type": "string",
      "maxLength": 80,
      "description": "City for the primary address.",
      "example": "example_value"
    },
    "address1_stateorprovince": {
      "type": "string",
      "maxLength": 50,
      "description": "State or province for the primary address.",
      "example": "example_value"
    },
    "address1_postalcode": {
      "type": "string",
      "maxLength": 20,
      "description": "ZIP code or postal code for the primary address.",
      "example": "example_value"
    },
    "address1_country": {
      "type": "string",
      "maxLength": 80,
      "description": "Country or region for the primary address.",
      "example": "example_value"
    },
    "address1_county": {
      "type": "string",
      "maxLength": 50,
      "description": "County for the primary address.",
      "example": "example_value"
    },
    "address1_telephone1": {
      "type": "string",
      "maxLength": 50,
      "description": "Main phone number for the primary address.",
      "example": "example_value"
    },
    "address1_fax": {
      "type": "string",
      "maxLength": 50,
      "description": "Fax number for the primary address.",
      "example": "example_value"
    },
    "address1_latitude": {
      "type": "number",
      "format": "double",
      "description": "Latitude value for the primary address.",
      "example": 42.5
    },
    "address1_longitude": {
      "type": "number",
      "format": "double",
      "description": "Longitude value for the primary address.",
      "example": 42.5
    },
    "address2_name": {
      "type": "string",
      "maxLength": 200,
      "description": "Descriptive name for the secondary address.",
      "example": "example_value"
    },
    "address2_line1": {
      "type": "string",
      "maxLength": 250,
      "description": "First line of the secondary address.",
      "example": "example_value"
    },
    "address2_line2": {
      "type": "string",
      "maxLength": 250,
      "description": "Second line of the secondary address.",
      "example": "example_value"
    },
    "address2_line3": {
      "type": "string",
      "maxLength": 250,
      "description": "Third line of the secondary address.",
      "example": "example_value"
    },
    "address2_city": {
      "type": "string",
      "maxLength": 80,
      "description": "City for the secondary address.",
      "example": "example_value"
    },
    "address2_stateorprovince": {
      "type": "string",
      "maxLength": 50,
      "description": "State or province for the secondary address.",
      "example": "example_value"
    },
    "address2_postalcode": {
      "type": "string",
      "maxLength": 20,
      "description": "ZIP code or postal code for the secondary address.",
      "example": "example_value"
    },
    "address2_country": {
      "type": "string",
      "maxLength": 80,
      "description": "Country or region for the secondary address.",
      "example": "example_value"
    },
    "preferredcontactmethodcode": {
      "type": "integer",
      "description": "Preferred method of contact. 1 = Any, 2 = Email, 3 = Phone, 4 = Fax, 5 = Mail.",
      "enum": [
        1,
        2,
        3,
        4,
        5
      ],
      "example": 1
    },
    "donotemail": {
      "type": "boolean",
      "description": "Whether the contact allows direct email.",
      "example": "[email protected]"
    },
    "donotphone": {
      "type": "boolean",
      "description": "Whether the contact allows phone calls.",
      "example": true
    },
    "donotfax": {
      "type": "boolean",
      "description": "Whether the contact allows faxes.",
      "example": true
    },
    "donotpostalmail": {
      "type": "boolean",
      "description": "Whether the contact allows direct mail.",
      "example": true
    },
    "donotbulkemail": {
      "type": "boolean",
      "description": "Whether the contact allows bulk email through campaigns.",
      "example": "[email protected]"
    },
    "donotsendmm": {
      "type": "boolean",
      "description": "Whether the contact accepts marketing materials.",
      "example": true
    },
    "creditlimit": {
      "type": "number",
      "format": "decimal",
      "description": "Credit limit of the contact.",
      "example": 42.5
    },
    "creditonhold": {
      "type": "boolean",
      "description": "Whether the credit for the contact is on hold.",
      "example": true
    },
    "statecode": {
      "type": "integer",
      "description": "Status of the contact. 0 = Active, 1 = Inactive. Inactive contacts are read-only.",
      "enum": [
        0,
        1
      ],
      "readOnly": true,
      "example": 0
    },
    "statuscode": {
      "type": "integer",
      "description": "Status reason for the contact. 1 = Active, 2 = Inactive.",
      "enum": [
        1,
        2
      ],
      "example": 1
    },
    "createdon": {
      "type": "string",
      "format": "date-time",
      "readOnly": true,
      "description": "Date and time when the contact record was created.",
      "example": "2026-01-15T10:30:00Z"
    },
    "modifiedon": {
      "type": "string",
      "format": "date-time",
      "readOnly": true,
      "description": "Date and time when the contact record was last updated.",
      "example": "2026-01-15T10:30:00Z"
    },
    "versionnumber": {
      "type": "integer",
      "format": "int64",
      "readOnly": true,
      "description": "Version number of the contact record.",
      "example": 10
    },
    "_parentcustomerid_value": {
      "type": "string",
      "format": "uuid",
      "readOnly": true,
      "description": "Lookup property for the parent customer (account or contact) associated with this contact.",
      "example": "example_value"
    },
    "_ownerid_value": {
      "type": "string",
      "format": "uuid",
      "readOnly": true,
      "description": "Lookup property for the user or team assigned to manage the record.",
      "example": "example_value"
    },
    "_transactioncurrencyid_value": {
      "type": "string",
      "format": "uuid",
      "readOnly": true,
      "description": "Lookup property for the currency associated with the record.",
      "example": "example_value"
    },
    "yomifirstname": {
      "type": "string",
      "maxLength": 150,
      "description": "Phonetic spelling of the first name (Japanese).",
      "example": "example_value"
    },
    "yomilastname": {
      "type": "string",
      "maxLength": 150,
      "description": "Phonetic spelling of the last name (Japanese).",
      "example": "example_value"
    },
    "yomimiddlename": {
      "type": "string",
      "maxLength": 150,
      "description": "Phonetic spelling of the middle name (Japanese).",
      "example": "example_value"
    },
    "yomifullname": {
      "type": "string",
      "maxLength": 450,
      "readOnly": true,
      "description": "Phonetic spelling of the full name (Japanese).",
      "example": "example_value"
    }
  },
  "x-ms-dynamics-entity": {
    "entitySetName": "contacts",
    "primaryKey": "contactid",
    "primaryNameColumn": "fullname",
    "namespace": "Microsoft.Dynamics.CRM",
    "baseType": "crmbaseentity"
  }
}