| author | title | description | ms.localizationpriority | doc_type | ms.subservice |
|---|---|---|---|---|---|
swapnil1993 |
columnValidation resource type |
Contains data for validating column values. |
medium |
resourcePageType |
sharepoint |
Namespace: microsoft.graph [!INCLUDE beta-disclaimer] Contains metadata for validating the column.
| Property | Type | Description |
|---|---|---|
| formula | string | The formula to validate column value. For examples, see Examples of common formulas in lists |
| descriptions | Collection(microsoft.graph.displayNameLocalization) | Localized messages that explain what is needed for this column's value to be considered valid. User will be prompted with this message if validation fails. |
| defaultLanguage | string | Default BCP 47 language tag for the description. |
SharePoint formulas use a syntax similar to Excel formulas. See Examples of common formulas in SharePoint Lists for more information.
The following is a JSON representation of a columnValidation resource.
{
"formula": "string",
"descriptions": [{ "@type": "microsoft.graph.displayNameLocalization" }],
"defaultLanguage": "string"
}