columnValidation resource type

Namespace: microsoft.graph

Represents properties that validates column values.


Property Type Description
defaultLanguage string Default BCP 47 language tag for the description.
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.
formula string The formula to validate column value. For examples, see Examples of common formulas in lists.

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.

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