Forum Discussion
Multiple Lines of Text - Minimum Entry Requirement
I have a SharePoint page where people can give findings reports and they provide information about these findings in a Multiple Lines of Text type of column. This is because they often have to give follow up information after we have addressed their findings, for example:
1/1/2023, A.A.: This item did not work, I received this error and the system crashed
2/1/2023, A.A.: The update has not solved the issue
3/1/2023, A.A.: The most recent update has solved the issue, case is resolved
To ensure that users are putting in sufficient information, I want to add a "minimum character" rule. 20 characters covers the date and initials, so I want to set it to probably 30.
Ideally, with a pop-up warning stating that "Description is insufficient, please provide more information using the following format: dd/mm/yy, A.A.: _____"
I have seen this question in other places, but the resolution does not satisfy my case:
Set a minimum number of characters for a SharePoint list Column - Microsoft Community Hub
Any help would be highly appreciated!
Unfortunately, this is not possible using column or list validation formula in SharePoint as multiple lines of text columns are not supported in SharePoint formulas.
You will have to customize the list form using Power Apps and add such validations using Power Apps functions. You can use Len() function to check the length of text input.
For example:
Len(myTextColumn.Text)Where myTextColumn is the name of your text input control in Power Apps form.
Check:
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.
1 Reply
Unfortunately, this is not possible using column or list validation formula in SharePoint as multiple lines of text columns are not supported in SharePoint formulas.
You will have to customize the list form using Power Apps and add such validations using Power Apps functions. You can use Len() function to check the length of text input.
For example:
Len(myTextColumn.Text)Where myTextColumn is the name of your text input control in Power Apps form.
Check:
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.