I have a SharePoint Online List.
It has some fields that are 'Required' fields.
I am also trying to use List Validation so that:
- IF the value of
- THEN the
AdditionalInformationtext field requires a value
MyChoiceColumn is a
Choice field with two values -
AdditionalInformation is a
Single Line of Text column.
I have entered this formula into
List Settings >
(note: the space in
[Additional Information] is intentional and correct)
The formula syntax looks correct to me and I have seen the same syntax demonstrated here.
When I try and submit the form, it shows this error at the very TOP of the form:
The user message that I have entered in the list validation settings is not displayed.
The form also produces some quirky behaviour where a required Date field 'date picker' is automatically opened (even though a date was chosen prior to trying to submit the form).
Steps To Reproduce
Create a Microsoft List
Add a Date column named
MyDateColumnand make it a required field
Add a Choice column named
MyChoiceColumnwith two values -
Add a Single Line of Text column named
AdditionalInformationcolumn so it has a space, i.e
Go to List settings > Validation settings
Enter this formula:
OR this formula:
- Enter this custom user message:
You have selected a response that requires further information be entered into this form
Save those settings
Go to the frontend of the form
Enter a date in the required date field
Saveto submit the form
The following things happen:
My custom error message is not displayed
This error is displayed at the very top of the form:
Error: The server was unable to save the form at this time.
Please try again
- The data picker for the Date column pops open
This is what should be happening:
- The form displays my custom error message in a position that is relevant to where the error is occurring OR at the bottom of the form near the