SharePoint List Validation - SharePoint Form

Question

I am creating a list validation formula:

"=AND([EndDate] >= [StartDate], [EndDate] <= [StartDate] + 365)"

This is to ensure that users cannot submit the form if they select an End Date that exceeds 365 days from the Start Date.

The validation works when I test it using New Item in the SharePoint list. However, when I submit using the SharePoint Form, I get the following error:

“Something went wrong. Try refreshing or contact the owner of the form.”

 

 

May I know anyone can provide advice on this?

Answer 1

It sounds like you are encountering a validation error when submitting a form in SharePoint, despite your validation formula working correctly in the New Item form. The error message you are receiving, "Something went wrong. Try refreshing or contact the owner of the form," can be indicative of several issues, including:

1. Formula Syntax: Ensure that your validation formula is correctly formatted and that the field names [EndDate] and [StartDate] are spelled correctly and match the exact names used in your SharePoint list.
2. Field Types: Check that both [EndDate] and [StartDate] are of the correct data type (Date and Time). If they are not, the validation may fail.
3. Form Settings: Sometimes, the form settings may not properly reflect the validation rules set in the list. Ensure that the form is correctly configured to enforce the list validation rules.
4. Permissions: Verify that you have the necessary permissions to submit the form. Sometimes, permission issues can lead to generic error messages.
5. Browser Issues: Try clearing your browser cache or using a different browser to see if the issue persists.
6. SharePoint Limitations: If you're using a custom form or a third-party tool, there may be limitations or bugs associated with that tool. Consider testing the form without any customizations to isolate the issue.

If the problem continues, you might want to check the SharePoint logs for more detailed error messages or consult with your SharePoint administrator for further assistance.

Answer 2

Hello @JunWen Wong,

Thank your for reaching out to the Q&A forum!

Based your information you provide, it seems the issue is not caused by the formula itself, but by the form submission process (the tool rendering the form) not handling SharePoint validation messages properly.  

To support you better, please provide me more detail: 

1.Are you using the default SharePoint list form, or have you customized the form with Power Apps? 

2.Or are you submitting data from Microsoft Forms via Power Automate into SharePoint? 

3.Are the StartDate and EndDate columns set to Date only or Date & Time? 

4.You shared the error message, however, if possible, could you provide a detail screenshot?   

Note: I can help you blur or hide any personal information if needed.     

Please understand that our initial response may not always resolve the issue immediately. However, with your help and more detailed information, we can work together to identify the root cause and find a solution.             

Looking forward to hearing from you.       

---

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.