Multiselect field values with customized bullet colors

Hi Bhargavi,

I have found a solution to this! It does require another table; I've called this table 'Colors'. All you are doing in this table is aligning one of the names in your multiselect field to a hex color. In my example you would just substitute the Color Names to the options in your multiselect. See below:

Now use this formula in the same table as your Workstream field: 

//Change the value of 7 at the end to whatever the FID of your hex color field is. 
var textlist colorone = GetFieldValues(GetRecords("{6.EX." & Part(ToText([Workstream]), 1, ";") & "}", [_DBID_COLORS]), 7);
var textlist colortwo = GetFieldValues(GetRecords("{6.EX." & Part(ToText([Workstream]), 2, ";") & "}", [_DBID_COLORS]), 7);
var textlist colorthree = GetFieldValues(GetRecords("{6.EX." & Part(ToText([Workstream]), 3, ";") & "}", [_DBID_COLORS]), 7);
var textlist colorfour = GetFieldValues(GetRecords("{6.EX." & Part(ToText([Workstream]), 4, ";") & "}", [_DBID_COLORS]), 7);
var textlist colorfive = GetFieldValues(GetRecords("{6.EX." & Part(ToText([Workstream]), 5, ";") & "}", [_DBID_COLORS]), 7);
var textlist colorsix = GetFieldValues(GetRecords("{6.EX." & Part(ToText([Workstream]), 6, ";") & "}", [_DBID_COLORS]), 7);
var textlist colorseven = GetFieldValues(GetRecords("{6.EX." & Part(ToText([Workstream]), 7, ";") & "}", [_DBID_COLORS]), 7);
var textlist coloreight = GetFieldValues(GetRecords("{6.EX." & Part(ToText([Workstream]), 8, ";") & "}", [_DBID_COLORS]), 7);
var textlist colornine = GetFieldValues(GetRecords("{6.EX." & Part(ToText([Workstream]), 9, ";") & "}", [_DBID_COLORS]), 7);
var textlist colorten = GetFieldValues(GetRecords("{6.EX." & Part(ToText([Workstream]), 10, ";") & "}", [_DBID_COLORS]), 7);

If(Part(ToText([Workstream]), 1, ";") <> "", "<span style='color: " & ToText($colorone) & "'>" & "• " & "</span>"  & Part(ToText([Workstream]), 1, ";") & "<br>") & 
If(Part(ToText([Workstream]), 2, ";") <> "", "<span style='color: " & ToText($colortwo) & "'>" & "• " & "</span>"  & Part(ToText([Workstream]), 2, ";") & "<br>") & 
If(Part(ToText([Workstream]), 3, ";") <> "", "<span style='color: " & ToText($colorthree) & "'>" & "• " & "</span>"  & Part(ToText([Workstream]), 3, ";") & "<br>") & 
If(Part(ToText([Workstream]), 4, ";") <> "", "<span style='color: " & ToText($colorfour) & "'>" & "• " & "</span>"  & Part(ToText([Workstream]), 4, ";") & "<br>") & 
If(Part(ToText([Workstream]), 5, ";") <> "", "<span style='color: " & ToText($colorfive) & "'>" & "• " & "</span>"  & Part(ToText([Workstream]), 5, ";") & "<br>") & 
If(Part(ToText([Workstream]), 6, ";") <> "", "<span style='color: " & ToText($colorsix) & "'>" & "• " & "</span>"  & Part(ToText([Workstream]), 6, ";") & "<br>") & 
If(Part(ToText([Workstream]), 7, ";") <> "", "<span style='color: " & ToText($colorseven) & "'>" & "• " & "</span>"  & Part(ToText([Workstream]), 7, ";") & "<br>") & 
If(Part(ToText([Workstream]), 8, ";") <> "", "<span style='color: " & ToText($coloreight) & "'>" & "• " & "</span>"  & Part(ToText([Workstream]), 8, ";") & "<br>") & 
If(Part(ToText([Workstream]), 9, ";") <> "", "<span style='color: " & ToText($colornine) & "'>" & "• " & "</span>"  & Part(ToText([Workstream]), 9, ";") & "<br>") & 
If(Part(ToText([Workstream]), 10, ";") <> "", "<span style='color: " & ToText($colorten) & "'>" & "• " & "</span>"  & Part(ToText([Workstream]), 10, ";") & "<br>")

This is the end result:

This is quite a process, so if you have any questions about how to format anything, please let me know! 

Thanks,

Tyler