convert_to_autonumber
Convert text columns to AutoNumber format in Microsoft Dataverse, generating sequential identifiers using customizable patterns like PREFIX-{SEQNUM:4}-{RANDSTRING:3} for consistent record numbering.
Instructions
Converts an existing text column to an AutoNumber column by adding an AutoNumberFormat. The column must be a String type with Text format and should be empty or contain compatible data.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| autoNumberFormat | Yes | AutoNumber format to apply using placeholders like "PREFIX-{SEQNUM:4}-{RANDSTRING:3}" | |
| columnLogicalName | Yes | Logical name of the existing text column to convert | |
| entityLogicalName | Yes | Logical name of the table containing the column | |
| maxLength | No | New maximum length if needed (ensure enough room for format expansion) |
Input Schema (JSON Schema)
{
"properties": {
"autoNumberFormat": {
"description": "AutoNumber format to apply using placeholders like \"PREFIX-{SEQNUM:4}-{RANDSTRING:3}\"",
"type": "string"
},
"columnLogicalName": {
"description": "Logical name of the existing text column to convert",
"type": "string"
},
"entityLogicalName": {
"description": "Logical name of the table containing the column",
"type": "string"
},
"maxLength": {
"description": "New maximum length if needed (ensure enough room for format expansion)",
"maximum": 4000,
"minimum": 1,
"type": "number"
}
},
"required": [
"entityLogicalName",
"columnLogicalName",
"autoNumberFormat"
],
"type": "object"
}