SOLVED

Conditional Formula on Choice Fields (single select) Not working

%3CLINGO-SUB%20id%3D%22lingo-sub-2288029%22%20slang%3D%22en-US%22%3EConditional%20Formula%20on%20Choice%20Fields%20(single%20select)%20Not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2288029%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20I%20have%20a%20Modern%20SharePoint%20list%2C%20using%20conditional%20formulas%20on%20several%20text%20fields%20that%20evaluate%20properly%2C%20however%2C%20when%20I%20use%20conditional%20formulas%20on%20ANY%20choice%20column%2C%20they%20do%20not%20evaluate%20at%20all.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20my%20instance%2C%20I%20am%20attempting%20to%20show%20a%20Choice%20field%2C%20based%20on%20the%20selected%20value%20of%20another%20Choice%20field.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20choice%20fields%20are%20single%20select%20only%20(dropdown)%2C%20with%20no%20spaces%20in%20field%20names%2C%20and%20only%20single%20word%20choices.%20I%20copied%20the%20example%20directly%20from%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fdev%2Fdeclarative-customization%2Flist-form-conditional-show-hide%23specify-conditional-formula-to-show-or-hide-columns%2C%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fdev%2Fdeclarative-customization%2Flist-form-conditional-show-hide%23specify-conditional-formula-to-show-or-hide-columns%2C%3C%2FA%3E%26nbsp%3Bwhich%20works%20on%20Text%20field%20types.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20Choice%20field%20names%20are%3A%3C%2FP%3E%3CP%3ERequestType%3C%2FP%3E%3CP%3E%26nbsp%3B%20Values%3A%20Access%2C%20Modification%2C%20Internal%2C%20Other%3C%2FP%3E%3CP%3EClient%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3BValues%3A%20Client1%2C%20Client2%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EConditional%20Formula%20Applied%20to%20Client%20field%3A%26nbsp%3B%3Dif(%5B%24RequestType%5D%20%3D%3D'Access'%2C%20'true'%2C%20'false')%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20tried%20to%20show%20a%20Text%20field%20%22RequestName%22%20based%20on%20the%20value%20of%20%24RequestType%20%3D%3D%20'Access'%20and%20that%20isn't%20working%20either.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20feeling%20I%20am%20adding%20or%20omitting%20something%2C%20however%2C%20I%20haven't%20figured%20that%20part%20out%20-%20hence%2C%20I%20am%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20all%20feedback.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2289874%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formula%20on%20Choice%20Fields%20(single%20select)%20Not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2289874%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1036145%22%20target%3D%22_blank%22%3E%40JMurphyHC%3C%2FA%3E%26nbsp%3BI%20don't%20see%20any%20issue%20with%20the%20conditional%20formula%20you%20are%20using.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20we%20need%20to%20use%20the%26nbsp%3B%3CSTRONG%3Einternal%20name%3C%2FSTRONG%3E%20of%20columns%20to%20reference%20them%20in%20conditional%20formulas.%20So%2C%20can%20you%20please%20check%20if%20you%20are%20using%20correct%20internal%20name%20of%20your%26nbsp%3B%3CSTRONG%3ERequestType%20%3C%2FSTRONG%3Ecolumn%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20find%20the%20internal%20name%20of%20your%20column%20like%20mentioned%20here%3A%26nbsp%3B%3CA%20title%3D%22Find%20the%20internal%20name%20of%20SharePoint%20column%22%20href%3D%22https%3A%2F%2Fplumsail.com%2Fdocs%2Fhelp-desk-o365%2Fv1.x%2FHow%2520To%2FFind%2520the%2520internal%2520name%2520of%2520SharePoint%2520column.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EFind%20the%20internal%20name%20of%20SharePoint%20column%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CHR%20%2F%3E%3CP%3EPlease%20click%26nbsp%3B%3CSTRONG%3EMark%20as%20Best%20Response%3C%2FSTRONG%3E%26nbsp%3B%26amp%3B%20%3CSTRONG%3ELike%3C%2FSTRONG%3E%20if%20my%20post%20helped%20you%20to%20solve%20your%20issue.%20This%20will%20help%20others%20to%20find%20the%20correct%20solution%20easily.%20It%20also%20closes%20the%20item.%20If%20the%20post%20was%20useful%20in%20other%20ways%2C%20please%20consider%20giving%20it%20%3CSTRONG%3ELike%3C%2FSTRONG%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Greetings, 

  I have a Modern SharePoint list, using conditional formulas on several text fields that evaluate properly, however, when I use conditional formulas on ANY choice column, they do not evaluate at all.

 

In my instance, I am attempting to show a Choice field, based on the selected value of another Choice field.

 

All choice fields are single select only (dropdown), with no spaces in field names, and only single word choices. I copied the example directly from https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/list-form-conditional-show... which works on Text field types.

 

My Choice field names are:

RequestType

  Values: Access, Modification, Internal, Other

Client

   Values: Client1, Client2

 

Conditional Formula Applied to Client field: =if([$RequestType] =='Access', 'true', 'false')

 

I also tried to show a Text field "RequestName" based on the value of $RequestType == 'Access' and that isn't working either.

 

I have a feeling I am adding or omitting something, however, I haven't figured that part out - hence, I am here.

 

Thanks for all feedback.

2 Replies
best response confirmed by JMurphyHC (New Contributor)
Solution

@JMurphyHC I don't see any issue with the conditional formula you are using.

 

Also, we need to use the internal name of columns to reference them in conditional formulas. So, can you please check if you are using correct internal name of your RequestType column?

 

You can find the internal name of your column like mentioned here: Find the internal name of SharePoint column 


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.

@ganeshanap, That was exactly the issue. I did previously rename the columns that were not properly evaluating. I created a new Choice field, and the same formula worked. I did not previously have the link you provided, thank you.