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

ganeshsanap's avatar
ganeshsanap
MVP
Apr 17, 2023

SelmaA Here are some similar threads for reference:

  1. How to set the minimum length of a single line text in SharePoint online? 
  2. Column validation on a non required field 

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

Resources