Multiple entries in multiple lines of text field with validation criteria in sharepoint

Freceena 1 Reputation point
2021-03-24T03:43:54.83+00:00

I have to enter the text in multiple lines of text in the format: "500387156;500345678;500123456". The validation criteria is : 

=OR(LEN([NOTIFICATION NO.])=0,AND(LEN([NOTIFICATION NO.])=9,MID([NOTIFICATION NO.],1,3)="500",ISNUMBER([NOTIFICATION NO.]+0),ISERR(FIND(".",[NOTIFICATION NO.])),ISERR(FIND(",",[NOTIFICATION NO.])),ISERR(FIND("$",[NOTIFICATION NO.])),ISERR(FIND("+",[NOTIFICATION NO.])),ISERR(FIND("-",[NOTIFICATION NO.])),ISERR(FIND(" ",[NOTIFICATION NO.]))))

Using this criteria, I could enter only one number ("500387156"). Now, required to enter in the format "500387156;500345678;500123456".

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,615 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Du-MSFT 41,786 Reputation points Microsoft Vendor
    2021-03-24T09:48:50.16+00:00

    @Freceena

    SharePoint does not support using column validation for the multiple lines of text.

    Please provide specific validation steps.

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    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.