=Concat(DISTINCT [ID], ',' ) is not working all the time

[jduluc12]

Hi,

I am using "=Concat(DISTINCT [ID], ',' )" to fetch the possible values from a list box and store it in a variable but sometimes it returns all the values from the list box.  If I just open and close the expression for the variable then it again shows the correct value. 

It is not very reliable. Is there any way to fix it?

Thanks,

Jean

[jonathandienst]

If nothing is selected then the Concat() will return all the values. How about:

=If(GetPossibleCount(ID) < Count({1} Distinct ID), Concat(Distinct ID, ', '))