using screen multi-select choice in formula uses label not value

sorry the images turned out huge and this article is hard to read

if you reference a screen multi-select choice element in a formula, the formula uses the choice label, not the choice value. #

choice with value defined #

Screenshot from 2021-06-21 13-08-24.png

choice is used in screen multiselect checkbox group : #

Screenshot from 2021-06-21 13-11-05.png

formula field references screen field #

Screenshot from 2021-06-21 13-01-23.png

output uses choice labels #

output-labels.png

but, if you first assign the screen field to a variable, and use the variable in the formula, then you get the values. #

assign screen field to variable #

asstIntermediateVar.png

formula uses variable #

formula_var.png

output uses choice values #

output-values.png

feature or bug…you decide! #

 
2
Kudos
 
2
Kudos

Now read this

Preventing duplicate junction object records

Native dupe management only allows you to reference a single lookup field. So it cannot prevent duplicate junction object records. By using a (new in spring 20) before save flow to concatenate the two IDs into a single text field, you... Continue →