columnValidation resource type

Namespace: microsoft.graph

Represents properties that validates column values.


Property name 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. For more information, see Examples of common formulas in SharePoint Lists.

JSON representation

The following is a JSON representation of a columnValidation resource.

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