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
TableJSON 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) |