Forum Discussion

Copper Contributor

Mar 02, 2023

Solved

Use Column Validation so that single text column requires an answer from a range of answers

Hi everyone, Hope you're well. I have a SharePoint list, and in it, one of the fields is a single text field (that is used for a cascading dropdown on the form). Some users, instead of using the ...

ganeshsanap
Mar 03, 2023
Imam1375
You have to add formula to variance driver column
You have to use the correct display name of column enclosed within []
If not working using above suggestions, follow below classic experience approach:
Go to SharePoint list > Click on Settings (gear) icon > Select List settings > Scroll down to "Columns" section and click on variance column name.

Scroll down to Column Validation section and copy paste the formula in correct format like:
Click "OK" button at the bottom of the page to save the changes to column settings.
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. If the post was useful in other ways, please consider giving it Like.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

ganeshsanap

MVP

Mar 07, 2023

Imam1375 If it is a choice field and choice options are predefined, is there any reason you need to use column validation for this field?

If you don't use column validation formula, is it showing choices properly? Column validation formula should not affect choice options. Check if your Power apps formulas are correct or not.

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

Imam1375

Copper Contributor

Mar 07, 2023

Another update/question. I have to implement this column validation across other lists too, with much longer ranges. When I tried to do one of them, it said that the formula has to be 1024 characters or fewer. Is there any way to work around this? Or is this an organizational thing?

ganeshsanap
MVP
Mar 08, 2023
Imam1375 Can you show your formula? Will check if there is any change to optimize it.

You cannot change this limit of characters in validation formula. This is defined limitation by Microsoft. If column validation is not working, you can check for list validation options from list settings (not sure about the limit of characters here).

Also, I don't know why you need formula if you are using choice column with predefined choices/options. As you have predefined choices, user has to select either of them using drop down.
Please consider giving a Like if my post helped you in any way.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs