columnValidation resource type

Namespace: microsoft.graph

Important

APIs under the /beta version in Microsoft Graph are subject to change. Use of these APIs in production applications is not supported. To determine whether an API is available in v1.0, use the Version selector.

Contains metadata for validating the column.

Properties

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.

JSON representation

The following is a JSON representation of a columnValidation resource.

{
  "formula": "string",
  "descriptions": [{ "@type": "microsoft.graph.displayNameLocalization" }],
  "defaultLanguage": "string"
}