create_dataverse_optionset
Create global choice lists in Dataverse with predefined options to ensure consistent data entry and improve data quality across multiple tables and columns.
Instructions
Creates a new global option set (choice list) in Dataverse with predefined options. Use this to create reusable choice lists that can be used across multiple tables and columns. Option sets provide consistent data entry options and improve data quality.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| description | No | Description of the option set | |
| displayName | Yes | Display name for the option set | |
| isGlobal | No | Whether this is a global option set | |
| name | Yes | Name for the option set (e.g., 'new_priority') | |
| options | Yes | Array of options for the option set |
Input Schema (JSON Schema)
{
"properties": {
"description": {
"description": "Description of the option set",
"type": "string"
},
"displayName": {
"description": "Display name for the option set",
"type": "string"
},
"isGlobal": {
"default": true,
"description": "Whether this is a global option set",
"type": "boolean"
},
"name": {
"description": "Name for the option set (e.g., 'new_priority')",
"type": "string"
},
"options": {
"description": "Array of options for the option set",
"items": {
"additionalProperties": false,
"properties": {
"color": {
"description": "Color for the option (hex format, e.g., '#FF0000')",
"type": "string"
},
"description": {
"description": "Description for the option",
"type": "string"
},
"label": {
"description": "Display label for the option",
"type": "string"
},
"value": {
"description": "Numeric value for the option",
"type": "number"
}
},
"required": [
"value",
"label"
],
"type": "object"
},
"type": "array"
}
},
"required": [
"name",
"displayName",
"options"
],
"type": "object"
}