Forum Discussion
Use Column Validation so that single text column requires an answer from a range of answers
- 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
Imam1375 Use column validation formula like:
=OR([Variance Driver]="Machine Costs",[Variance Driver]="Employee Costs",[Variance Driver]="Tech Costs")
Column settings:
Output:
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 Hi Ganesh, thanks for your answer. Problem is, that it doesn't seem to work for me. The formula keeps returning #NAME? where variance driver is written.
I have made sure that it is spelt exactly as it should be.
- 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
- Hi again. Just an update. The field that I wanted to use this for, has a cascading dropdown on the form (which is customized through power apps). When I put in the column validation formula, the choice selection in the cascading dropdown completely disappears, i.e the cascading dropdown shows no choices, it is completely blank. Do you know any solution to this? Thanks
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
- Thank you, trying it via list settings worked