question

Freceena-6388 avatar image
0 Votes"
Freceena-6388 asked Freceena-6388 commented

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

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".

office-sharepoint-online
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Freceena-6388

I'm checking how the things are going on about this issue. Whether the answer helps you?

You can accept the answer if it helps.


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.


0 Votes 0 ·

My issue is not solved yet. Can I implement this on single line of text instead of multiple line of text.

0 Votes 0 ·

1 Answer

EmilyDu-MSFT avatar image
0 Votes"
EmilyDu-MSFT answered EmilyDu-MSFT edited

@Freceena-6388

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.




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.