New Bug Encountered: Valid If removes Duplicates

I see a difference in the Expression Assistant and the App.

I have a simple Text Column that is scanable.
In Valid If I say LIST(1,2,3)+LIST(1,2,3)

The Expression Assistant gives me the result with duplicates.
2X_c_c261a5a2ff10ba3dbfc7c35cf668394ca0fa6c2b.png
But the App removes duplicates.
2X_0_0a3381b301f901ef7e32e36b180abbcd0a969bcf.png

In my App I need to have the duplicates.

(In real Iโ€™m saying: give me all Item Numbers and substract those already added. But since some Items can be added twice, I need to have duplicates.)

I know that subtracting one list from another has the side-effect of removing duplicates, as @Steve mentioned here.
But does combining lists also has this side-effect?

0 7 333
7 REPLIES 7

Steve
Participant V

Nope.

Bahbus
Participant V

What if you make it an Enum column?

I had the same idea. But it leads to the same result.

Steve
Participant V

This appears to be a function of Valid If, as a single/non-combined list with duplicates (e.g., LIST(1, 2, 3, 1, 2, 3)) exhibits the same behavior. I can imagine this behavior being a side-effect of how list handling for Valid If is implemented.

The same thing happens when I put the expression in the Suggested Values.

Adding also @praveen

About the only other thing I can think of is to separate this โ€œlistโ€ into a seperate table with some sort of different unique ID. If you pull it as a Ref, then it shouldnโ€™t matter if there are duplicate texts because the ID key would be different. That might just take some implementation magic.

Thank you @Bahbus I will try this way.

EDIT: I see that this is no option for me.

Top Labels in this Space