Forum Discussion

SelmaA's avatar
SelmaA
Copper Contributor
Apr 17, 2023
Solved

Set a minimum number of characters for a SharePoint list Column

Hi everyone,    So I have a SharePoint list with many columns one of them being the social security number.   In order to minimize errors, I would like for people to be able to put 15 characters ...
Lists
SharePoint Online
  • ganeshsanap's avatar
    ganeshsanap
    Apr 17, 2023

    SelmaA Can you try using List Validation settings instead of column validation?

     

    Also, try using same formula on different list (without data) in same SharePoint site and different SharePoint site (with English language) and see if it is working for you.

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

    For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

SelmaA's avatar
SelmaA
Copper Contributor
Apr 17, 2023
Thank you for your reply ! I did try it and still get the same syntax error message (I also tried with semicolon instead of comma and also by using the function equivalent in french).
Could it be that it is not working because I already have data on that column ?
ganeshsanap's avatar
ganeshsanap
MVP
Apr 17, 2023

SelmaA Can you try using List Validation settings instead of column validation?

 

Also, try using same formula on different list (without data) in same SharePoint site and different SharePoint site (with English language) and see if it is working for you.

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

  • SelmaA's avatar
    SelmaA
    Copper Contributor
    Apr 17, 2023

    Thank you !

    I tried using list Validation instead of column validation, it still doesn't work but I am able so save my formula and don't get any error message (the functions are then automatically changed to the french equivalent) however when adding a new item to the list nothing happens, I am still able to put more than 15 characters.
    I created a new list and tried again your formula, it now works, the item cannot be saved if this column is more or less than 15 characters, however the error message that appears is not the one that I wrote but rather a system message.
    I kinda found a solution to my issue.
    When creating the new SharePoint list, I tried adding a new column and chose number instead of text. I then set the minimum to 100000000000000 and max to 999999999999999 (since our social security numbers start by 1 or 2) and it seems to be working for now. I will still try to figure out why your formula is saved and working but the message not appearing. Thank you very much !

Resources