InfoPath Form – SharePoint Field Validation Rules

Microsoft SharePoint InfoPath form provides some types of Rules to perform the action on the controls of the form. Validation Rule is one of them. The InfoPath form validation rules mean that an InfoPath form automatically validates the data you entered and if does not match with the required condition, it fires the error message. To validate the data of the field, we use the Validation Rule. This Rule prevents your form from the invalid or empty data until the error does not fix. The SharePoint Form validation Rule also provides the ability to create a user-friendly message. This Rule can be applied to any field, on Page Load event or any Button’s onclick event.

Appearance of SharePoint field validation message

The SharePoint data validation error message can be displayed in either of the following 2 ways:

In line error message: In line error message displays the message with the control. It highlights the control with the red dashed border when the data of control does not match with the required condition.

Dialog box error message: Dialog box error message opens a dialog and displays the message in that dialog when the data of control does not match with the required condition.

Setting a condition on a Rule

To apply the Validation Rule for the field’s data, it is mandatory to set the required condition. For single field’s validation, you can apply the multiple conditions using “And” or “Or” operators. Below is demonstrated to set a Validation Rule on the field:

1) Open the InfoPath form and select the control on which you want to apply the Validation Rule.

2) When you selected the control, then on top ribbon of InfoPath designer, you will get the “Manage Rules” option under “Home” tab. Click on “Manage Rules” button.

3) A “Rules” window will get open on right to the InfoPath designer.

4) Open the “New” dropdown and select the “Validation” option.

IP-Validation

5) In “Details for” section, you can add the name of your rule.

6) Click on “None” link in “Condition” section, a “Condition” dialog will get open.

7) First, down-down will show you all the fields of the form. Select the field name which field’s data you want to validate.

IP-FieldName

8) Next, select the condition which you wanted to be apply on the field. There is an “And” operator button provided to apply the multiple conditions on the field and validate the data. Now click “OK” to save the condition.

IP-Conditions

9) In “ScreenTip” box, write the error message you which you want to display on UI of the form.

10) In the Rules window, there is a link “Show more options”. When you click on that you will get the option to show the error message in the dialog box.

IP-ErrorMsg

Save and publish the form

After applying the Rule to the control, save and publish the form in the Form library. Now, when you will going to submit the form and the required condition does not match then it will fire the error message.

IP-ValidationMsgOutput

You can also include SharePoint Online column validation to the columns that are created at the site or app level. Column validations options are what allows the user to define any additional constraints or limits for their data. So, it is important to know this as well.

If you have any questions about SharePoint field validation rules or if you would like to start using SharePoint Online for your business, reach out to our SharePoint experts at Ignatiuz today. Ignatiuz is a Microsoft SharePoint partner, and our consultants can work with you, understand your unique business processes, and let you know what SharePoint Online features will work best for you, in terms of your current business goals and future goals. This way, Ignatiuz and SharePoint can help take your business to the next level.

Related Posts

Leave a comment