How To Implement List Validation In SharePoint Online

In this tutorial, Louie explains how to implement List Validation in SharePoint Online, highlighting the differences between List Validation and Column Validation. List Validation allows users to create rules that compare data across multiple fields within a list, while Column Validation is limited to rules that apply to individual fields.

Key Concepts:

• List Validation vs. Column Validation:
  • List Validation: Can check values across different columns in a list or document library.
  • Column Validation: Self-contained rules that cannot reference other fields.
• Examples of List Validation:
  • Date Validation: Ensures that a project end date is later than the start date.
  • Numeric Validation: Checks that a contingency amount is less than the project budget.
  • Conditional Requirement: Makes a justification field required if the budget exceeds a specified amount.
• Implementation Steps:
  • Access validation settings through the list settings menu.
  • Create validation rules using formulas that must evaluate to true for data entry to be accepted.
  • Provide user messages for guidance when validation rules fail.
• Limitations:
  • Only one List Validation rule can be implemented per SharePoint list, although it can contain multiple conditions or nested statements.
• Modification of Rules:
  • Users can modify existing validation rules to include additional criteria or change conditions.

Additional Resources:

Louie references an in-depth tutorial on column-level validation available in the video description.

Main Speaker:

• Louie Acabellas, the presenter of the tutorial.