create_dataverse_table
Create custom tables in Microsoft Dataverse to store business data with configurable ownership, activity tracking, and data management features.
Instructions
Creates a new custom table in Dataverse with the specified configuration. Use this when you need to create a new entity to store business data. Requires a solution context to be set first.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| description | No | Description of the table | |
| displayName | Yes | Display name for the table (e.g., 'Test Table') | |
| hasActivities | No | Whether the table can have activities | |
| hasNotes | No | Whether the table can have notes | |
| isAuditEnabled | No | Whether auditing is enabled | |
| isConnectionsEnabled | No | Whether connections are enabled | |
| isDocumentManagementEnabled | No | Whether document management is enabled | |
| isDuplicateDetectionEnabled | No | Whether duplicate detection is enabled | |
| isMailMergeEnabled | No | Whether mail merge is enabled | |
| isValidForQueue | No | Whether records can be added to queues | |
| ownershipType | No | Ownership type of the table | UserOwned |
| primaryNameAttribute | No | Logical name of the primary name attribute (will be auto-generated if not provided) | |
| primaryNameAutoNumberFormat | No | AutoNumber format for the primary name column using placeholders like 'PREFIX-{SEQNUM:4}-{RANDSTRING:3}-{DATETIMEUTC:yyyyMMdd}'. If specified, the primary name column will be created as an AutoNumber column. |
Input Schema (JSON Schema)
{
"properties": {
"description": {
"description": "Description of the table",
"type": "string"
},
"displayName": {
"description": "Display name for the table (e.g., 'Test Table')",
"type": "string"
},
"hasActivities": {
"default": false,
"description": "Whether the table can have activities",
"type": "boolean"
},
"hasNotes": {
"default": false,
"description": "Whether the table can have notes",
"type": "boolean"
},
"isAuditEnabled": {
"default": false,
"description": "Whether auditing is enabled",
"type": "boolean"
},
"isConnectionsEnabled": {
"default": false,
"description": "Whether connections are enabled",
"type": "boolean"
},
"isDocumentManagementEnabled": {
"default": false,
"description": "Whether document management is enabled",
"type": "boolean"
},
"isDuplicateDetectionEnabled": {
"default": false,
"description": "Whether duplicate detection is enabled",
"type": "boolean"
},
"isMailMergeEnabled": {
"default": false,
"description": "Whether mail merge is enabled",
"type": "boolean"
},
"isValidForQueue": {
"default": false,
"description": "Whether records can be added to queues",
"type": "boolean"
},
"ownershipType": {
"default": "UserOwned",
"description": "Ownership type of the table",
"enum": [
"UserOwned",
"OrganizationOwned"
],
"type": "string"
},
"primaryNameAttribute": {
"description": "Logical name of the primary name attribute (will be auto-generated if not provided)",
"type": "string"
},
"primaryNameAutoNumberFormat": {
"description": "AutoNumber format for the primary name column using placeholders like 'PREFIX-{SEQNUM:4}-{RANDSTRING:3}-{DATETIMEUTC:yyyyMMdd}'. If specified, the primary name column will be created as an AutoNumber column.",
"type": "string"
}
},
"required": [
"displayName"
],
"type": "object"
}