How to configure a conditional column validation in SharePoint Online?

Conditional column validations

Using Crow Canyon Forms Manager App, we can configure a conditional column validation in a SharePoint online site.

Use Case: "Resolution Notes" field should be a required field while closing a ticket (Tickets list; Request Status = Closed).

Go to Application Administration –> Crow Canyon Nitro Apps –> Crow Canyon Forms Manager app –> Select Tickets list –> Go to Column Validations section –>  Select "Resolution Notes" column.

Configure new validation with a condition like below.

Note: This validation does not apply for the tickets which are being closed using a custom action like "Close" button in the ticket ribbon or  in "Quick Edit" mode. This validation will be applied only in the standard SharePoint forms.

Leave a Reply