Sharepoint List Validation Problem

Copper Contributor
I have created a Sharepoint List that has StartDate and EndDate columns. When a user creates a 'New' item, I want to Validate that the EndDate is greater than the StartDate. I have added this validation to Settings>Validations Settings using the following formula '=EndDate>StartDate'. This validation appears to work (when condition is true, the item is added) BUT when the condition is NOT TRUE, I am NOT seeing the 'User Message' I have specified. I instead see the following message... "Network error when using Patch function: The requested operation is invalid." I have search everywhere but can't find why this is happening... Can anyone help?
1 Reply

Hi @BogDog33,

The error doesn't directly relate to the validation formula itself, but indicates that there could be an issue with data submission when the validation condition is not met.

You can try to use these steps to resolve your issue:

1. Make sure the validation formula you entered ('=EndDate>StartDate') is correct and doesn't have any mistakes. Check if the column names match exactly with those in your SharePoint list.

2. Test the Validation Condition: try to create a new item in the list and intentionally enter an EndDate that is not greater than the StartDate. So you can see if the validation works as expected and prevents the item from being added.

3. Double check the 'User Message' you specified in the Validation Settings. It should be written and without any characters or elements that might cause conflicts or issues.

5. Test in Different Environment: try testing the same validation formula in a different SharePoint environment, like a test site or. This can help determine if the issue is specific to your current environment (site)

 

Start and End dates validations in Sharepoint list - Microsoft Community


Please click Mark as Best Response & Like if my post helped you to solve your issue.
This will help others to find the correct solution easily. It also closes the item.


If the post was useful in other ways, please consider giving it Like.


Kindest regards,


Leon Pavesic