Microsoft Lists Forms throws error in combination with column validation

Question

Microsoft Lists Forms throws error in combination with column validation

Mihalyi, Levente 0

I have a sharepoint list and I have a column with this formula for column validation: =LOWER(Level1Code)="privacy"

I created a Ms Lists Forms through the designated button at the top of the sharepoint list menu.

It works perfectly fine recognizing correct entries. When I enter a wrong word, however, I get the error visible in the picture below. I tried troubleshooting with AI but couldn't find the issue, also given that it works fine in several videos I watched on youtube. Is this something my company could restrict? I don't understand how, though, when validation works fine in positive cases, I only get this page when I enter a wrong word. User's image

0 comments

1 answer

Your answer

Answer 1

Hi @Mihalyi, Levente,

Thank you for providing a detailed description of the issue you are encountering with Microsoft Lists.

It is my understanding that your validation formula is functioning correctly for valid entries; however, the system fails to display the appropriate validation message when an entry is non-compliant. Instead, the Microsoft Lists Forms interface triggers a generic “Something went wrong” error page.

This behavior suggests that the issue is not rooted in your specific formula or an intentional corporate restriction, but rather in how the modern Lists Forms experience handles failed validation responses from the server. To further isolate the root cause, please consider the following actions:

1/ Firstly, please test via the Standard SharePoint form:

By accessing your list and attempt to create a new item using the default SharePoint "New" pane (the side panel) rather than the custom Lists Form.
If the standard pane correctly displays your validation message, it confirms that the error is isolated to the Lists Forms web interface.

2/ Replicate in a controlled environment:

Attempt to recreate this validation rule on a new, simplified sample list with a single text column.
Determining if the error persists in a fresh environment will help identify if the behavior is systemic.

If the issue remains unresolved after performing the steps above, I recommend contacting your IT department to request the opening of a support ticket with Microsoft Support. For detailed instructions on how to get support, please refer to Get support - Microsoft 365 admin.

A Microsoft support agent will be able to perform a deeper investigation into the backend telemetry and logs to identify why the interface is failing to catch the validation rejection. This level of analysis is necessary to determine if a service-side fix is required for your environment.

I hope these recommendations assist you in reaching a resolution. Please feel free to reach out if you have any additional questions.

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.

Ian-Ng 14,150 Reputation points Microsoft External Staff Moderator

2026-04-29T19:42:52.1633333+00:00

Hi @Mihalyi, Levente,

Have a good day.

May I kindly ask whether you have had a chance to review my previous response?

If you have any further questions, please feel free to contact me.

I look forward to hearing from you.
Mihalyi, Levente 0 Reputation points

2026-05-04T16:08:52.5166667+00:00

Hi,

it seems creating a new table magically solved the problem. Will see in the next days if it works when implementing with our planned concept.

Thanks for your help so far.
Ian-Ng 14,150 Reputation points Microsoft External Staff Moderator

2026-05-04T21:59:04.4766667+00:00

Hi @Mihalyi, Levente,

Thanks for the update, that’s great news. If recreating the table resolved the behavior, it points to something specific to the original list’s form configuration rather than the validation logic itself.

Should you have any questions or updates, please feel free to reach out.