New Item Column Validation Formula not working in modern list

%3CLINGO-SUB%20id%3D%22lingo-sub-124205%22%20slang%3D%22en-US%22%3ENew%20Item%20Column%20Validation%20Formula%20not%20working%20in%20modern%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-124205%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20simple%20formula%20to%20check%20length%20of%20columns%20in%20a%20list.%20The%20formula%20looks%20like%20this%3A%3C%2FP%3E%3CP%3E%3DLEN(TRIM(Title))%26lt%3B41%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20formula%20is%20entered%26nbsp%3Bon%20each%20target%20column.%20This%20seems%20to%20work%20fine%20when%20in%20edit%20mode%20-%20by%20displaying%20the%20validation%20message%20when%20violated.%20But%20when%20creating%20new%20item%2C%20if%20the%20validation%20is%20violated%2C%20you%20will%20see%20the%20validation%20message%20appear%20briefly%2C%20but%20the%20page%20is%20re-loaded%20back%20to%20the%20list%20items.%20The%20new%20item%20is%20not%20created%20though%2C%20but%20interrupt%20the%20user%20experience%2C%20and%20user%20will%20have%20to%20fill%20the%20form%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20issue%20exist%20when%20in%20modern%20experience.%20If%20i%20switch%20to%20classic%20experience%2C%20then%20everything%20works%20as%20expected.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20an%20option%20to%20use%20the%20Validation%20Settings%20in%20the%20list%20settings%20page%2C%20which%20works%20as%20expected%20when%20creating%20new%20item%20in%20modern%20UI%2C%20but%20you%20can%20only%20add%20one%20validation%20rule%20in%20this%20section.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20a%20known%20issue%2C%20if%20so%20are%20there%20plans%20to%20correct%20this%20in%20near%20future%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-124205%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-133706%22%20slang%3D%22en-US%22%3ERe%3A%20New%20Item%20Column%20Validation%20Formula%20not%20working%20in%20modern%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-133706%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20experiencing%20exactly%20the%20same.%20Michael%2C%20did%20you%20manage%20to%20solve%20this%3F%20Did%20you%20report%20this%20to%20Microsoft%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1462922%22%20slang%3D%22en-US%22%3ERe%3A%20New%20Item%20Column%20Validation%20Formula%20not%20working%20in%20modern%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1462922%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F88097%22%20target%3D%22_blank%22%3E%40Michael%20Kuforiji%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EComing%20on%20June%2015th%202020%2C%20still%20searching%20about%20this%20problem%3A)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I have a simple formula to check length of columns in a list. The formula looks like this:

=LEN(TRIM(Title))<41

 

This formula is entered on each target column. This seems to work fine when in edit mode - by displaying the validation message when violated. But when creating new item, if the validation is violated, you will see the validation message appear briefly, but the page is re-loaded back to the list items. The new item is not created though, but interrupt the user experience, and user will have to fill the form again.

 

This issue exist when in modern experience. If i switch to classic experience, then everything works as expected. 

 

There is an option to use the Validation Settings in the list settings page, which works as expected when creating new item in modern UI, but you can only add one validation rule in this section.

 

Is this a known issue, if so are there plans to correct this in near future?

 

 

Many thanks

2 Replies

We are experiencing exactly the same. Michael, did you manage to solve this? Did you report this to Microsoft?

@Michael Kuforiji 

Coming on June 15th 2020, still searching about this problem:)