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 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
The validation, in fact, does not affect cascading dropdowns, they both work fine.