Formula evaluation of formula using len() function not working properly
Thank you for reporting an issue, suggesting an enhancement, or asking a question. We appreciate your feedback - to help the team understand your needs please complete the below template to ensure we have the details to help. Thanks!
Please check out the documentation to see if your question is already addressed there. This will help us ensure our documentation is up to date.
Category
[x] Bug
Version
Please specify what version of the library you are using: [ 3.20.0 ]
If you are not using the latest release, please update and see if the issue is resolved before submitting an issue.
Expected / Desired Behavior / Question
Proper evaluation of validation formula =len(internalColumnName)>6
Observed Behavior
Considers strings with length >6 to be not valid.
Steps to Reproduce
Add column with validation formula =len(internalColumnName)>6, check how it does not consider strings that are longer than 6 as valid even though the default SharePoint form does
https://github.com/pnp/sp-dev-fx-controls-react/blob/5d17c0393e79ff3cb06996480ed07f28e262334c/src/common/utilities/FormulaEvaluation.ts#L538
Here length is used as length function, but it should be len as far as I understand (https://support.microsoft.com/en-us/office/len-function-038f2e0d-57d3-4f35-ae74-9a79d66e8fc2)