Forum Discussion
Set a minimum number of characters for a SharePoint list Column
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 Are you trying to have the exact 15 characters in the column? If yes, then use formula like:
=IF(ISBLANK([column 1]), TRUE, IF(LEN([column 1])=15, TRUE, FALSE)
Use correct display name of your column. Also, as you are using non-English language try using LEN function equivalent in your language.
Note: Sometimes comma( , ) does not work in formula (it is based on language or regional settings on your site). So in that case use semicolon( ; ) instead of comma( , ).
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
Could it be that it is not working because I already have data on that column ?
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
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 !SelmaA It maybe showing error message something like this: Error: The server was unable to save the form at this time. Please try again.
This is a issue/bug from Microsoft's end as other SharePoint users are also facing this issue while using validations in SharePoint lists.
Here's related thread where you can find more information: Microsoft List validation not working in SharePoint Online - Error: The server was unable to save the form at this time. Please try again
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