Edit

Share via

columnValidation resource type

  • Article

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"
}