Apr 25 2021 05:23 AM
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.
Apr 25 2021 10:37 PM - edited Apr 17 2023 04:00 AM
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.
Apr 26 2021 02:38 AM
Oct 04 2021 02:29 PM
Oct 05 2021 12:53 AM
@Jesse_Ringel You're welcome! I am glad my solution worked for you.
Please consider giving a Like if my post helped you in any way.
Apr 21 2023 08:21 AM
Apr 25 2021 10:37 PM - edited Apr 17 2023 04:00 AM
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.