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). |