I have a text column with email validation

This column is bound to a list/content type.

One of the other columns in the list is a multi select lookup column. The values for the multi select column are sourced from another list.

If the user enters an invalid email address when creating/editing an item the values in the multi select column disappear.

Any tips would be much appreciated

  • Is there any custom javascript code on your form? – Ganesh Sanap Apr 14 at 7:35
  • Not at all. This is using OOTB view/page on an OOTB column with a formula to validate the email address – user3799810 Apr 14 at 7:43
  • Is it possible for you to add the formula here in your question? That maybe helpful – Ganesh Sanap Apr 14 at 9:12
  • Sure Ganesh. The validation is as follows <Validation Message="Enter a valid email address">=OR(ISBLANK([Authors Email Address]), AND(ISERROR(FIND(" ",[Authors Email Address],1)), IF(ISERROR(FIND("@",[Authors Email Address],2)),FALSE, AND(ISERROR(FIND("@",[Authors Email Address],FIND("@",[Authors Email Address],2)+1)), IF(ISERROR(FIND(".",[Authors Email Address],FIND("@",[Authors Email Address],2)+2)), FALSE,FIND(".",[Authors Email Address],FIND("@",[Authors Email Address],2)+2)&lt;LEN([Authors Email Address]))))))</Validation> – user3799810 Apr 14 at 22:15
  • Where are you add the validation? – Lisa Chen MSFT Apr 18 at 9:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.