create_dataverse_column
Add custom fields to Dataverse tables with specific data types including text, numbers, dates, lookups, and choice lists to store structured data.
Instructions
Creates a new column (field) in a Dataverse table with the specified data type and configuration. Supports various column types including text, numbers, dates, lookups, and choice lists. Use this to add new fields to store specific data in your tables. Requires a solution context to be set first.
Input Schema
Name | Required | Description | Default |
---|---|---|---|
columnType | Yes | Type of the column | |
dateTimeFormat | No | Format for datetime columns | |
defaultValue | No | Default value for the column | |
description | No | Description of the column | |
displayName | Yes | Display name for the column (e.g., 'Customer Email') | |
entityLogicalName | Yes | Logical name of the table to add the column to | |
falseOptionLabel | No | Label for false option in boolean columns (default: 'No') | |
format | No | Format for string columns | |
isAuditEnabled | No | Whether auditing is enabled for this column | |
isValidForAdvancedFind | No | Whether the column appears in Advanced Find | |
isValidForCreate | No | Whether the column can be set during create | |
isValidForUpdate | No | Whether the column can be updated | |
maxLength | No | Maximum length for string columns (default: 100) | |
maxValue | No | Maximum value for integer/decimal columns | |
minValue | No | Minimum value for integer/decimal columns | |
optionSetName | No | Name of the option set for picklist columns | |
options | No | Options for picklist columns | |
precision | No | Precision for decimal columns (default: 2) | |
requiredLevel | No | Required level of the column | None |
targetEntity | No | Target entity for lookup columns | |
trueOptionLabel | No | Label for true option in boolean columns (default: 'Yes') |
Input Schema (JSON Schema)
{
"properties": {
"columnType": {
"description": "Type of the column",
"enum": [
"String",
"Integer",
"Decimal",
"Money",
"Boolean",
"DateTime",
"Picklist",
"Lookup",
"Memo",
"Double",
"BigInt"
],
"type": "string"
},
"dateTimeFormat": {
"description": "Format for datetime columns",
"enum": [
"DateOnly",
"DateAndTime"
],
"type": "string"
},
"defaultValue": {
"description": "Default value for the column",
"type": [
"string",
"number",
"boolean"
]
},
"description": {
"description": "Description of the column",
"type": "string"
},
"displayName": {
"description": "Display name for the column (e.g., 'Customer Email')",
"type": "string"
},
"entityLogicalName": {
"description": "Logical name of the table to add the column to",
"type": "string"
},
"falseOptionLabel": {
"description": "Label for false option in boolean columns (default: 'No')",
"type": "string"
},
"format": {
"description": "Format for string columns",
"enum": [
"Email",
"Text",
"TextArea",
"Url",
"Phone"
],
"type": "string"
},
"isAuditEnabled": {
"description": "Whether auditing is enabled for this column",
"type": "boolean"
},
"isValidForAdvancedFind": {
"description": "Whether the column appears in Advanced Find",
"type": "boolean"
},
"isValidForCreate": {
"description": "Whether the column can be set during create",
"type": "boolean"
},
"isValidForUpdate": {
"description": "Whether the column can be updated",
"type": "boolean"
},
"maxLength": {
"description": "Maximum length for string columns (default: 100)",
"type": "number"
},
"maxValue": {
"description": "Maximum value for integer/decimal columns",
"type": "number"
},
"minValue": {
"description": "Minimum value for integer/decimal columns",
"type": "number"
},
"optionSetName": {
"description": "Name of the option set for picklist columns",
"type": "string"
},
"options": {
"description": "Options for picklist columns",
"items": {
"additionalProperties": false,
"properties": {
"description": {
"type": "string"
},
"label": {
"type": "string"
},
"value": {
"type": "number"
}
},
"required": [
"value",
"label"
],
"type": "object"
},
"type": "array"
},
"precision": {
"description": "Precision for decimal columns (default: 2)",
"type": "number"
},
"requiredLevel": {
"default": "None",
"description": "Required level of the column",
"enum": [
"None",
"SystemRequired",
"ApplicationRequired",
"Recommended"
],
"type": "string"
},
"targetEntity": {
"description": "Target entity for lookup columns",
"type": "string"
},
"trueOptionLabel": {
"description": "Label for true option in boolean columns (default: 'Yes')",
"type": "string"
}
},
"required": [
"entityLogicalName",
"displayName",
"columnType"
],
"type": "object"
}