Skip to main content
Glama

Dataverse MCP Server

by mwhesse

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

NameRequiredDescriptionDefault
columnTypeYesType of the column
dateTimeFormatNoFormat for datetime columns
defaultValueNoDefault value for the column
descriptionNoDescription of the column
displayNameYesDisplay name for the column (e.g., 'Customer Email')
entityLogicalNameYesLogical name of the table to add the column to
falseOptionLabelNoLabel for false option in boolean columns (default: 'No')
formatNoFormat for string columns
isAuditEnabledNoWhether auditing is enabled for this column
isValidForAdvancedFindNoWhether the column appears in Advanced Find
isValidForCreateNoWhether the column can be set during create
isValidForUpdateNoWhether the column can be updated
maxLengthNoMaximum length for string columns (default: 100)
maxValueNoMaximum value for integer/decimal columns
minValueNoMinimum value for integer/decimal columns
optionSetNameNoName of the option set for picklist columns
optionsNoOptions for picklist columns
precisionNoPrecision for decimal columns (default: 2)
requiredLevelNoRequired level of the columnNone
targetEntityNoTarget entity for lookup columns
trueOptionLabelNoLabel 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" }

Other Tools from Dataverse MCP Server

Related Tools

    MCP directory API

    We provide all the information about MCP servers via our MCP API.

    curl -X GET 'https://glama.ai/api/mcp/v1/servers/mwhesse/mcp-dataverse'

    If you have feedback or need assistance with the MCP directory API, please join our Discord server