Filtered Enumlist won't allow multiple choices

[Jairo_Rodriguez]

I have an EnumList field which pulls a list from a filtered virtual column.

When choosing several options, it gives me an “This entry is invalid” error

I’ve spent hours troubleshooting.

Please help!

[Steve]

[Jairo_Rodriguez]

I have the settings as you show, however the error persists.
Any ideas?

[Steve]

What is the column’s Valid If expression?

[Jairo_Rodriguez]

The Valid if expression is [actividad2], which refers to a virtual column which has the following formula:

list(select(actividades por pieza[actividad],([pieza]=[_THISROW].[codigo pieza]),true))

[Steve · Accepted solution]

Remove the LIST() wrapping the SELECT().

[Jairo_Rodriguez]

Did that. Still gives me error.

This one is a doozy

[Jairo_Rodriguez]

I checked on the field details and it had reverted back to base type=text, changed it back to Enumlist and it works now!

Thank you for your guidance and patience!

[Daniel_Arguello]

Might you help me?
I have the same problem, the code I have is the following:

        Select (Inventory [Normalized],

OR (ISBLANK ([_THISROW]. [Responsible]), [Responsible] = [_THISROW]. [Responsible])
)

I am making use of two virtual columns linked together, as a filter.
The “responsible” leaves me the “Normalized” elements that I want to select, but if I select more than 1, it marks the error, I want to have more than one “Normalized” to add.
Thanks a lot!

[Steve]

Daniel_Arguello:

I have the same problem

What problem? I’m not going to go back and reread the entire thread to figure it out.

Daniel_Arguello:

it marks the error,

What error? Please post a screenshot.

Daniel_Arguello:

I want to have more than one “Normalized” to add.

Typically, choosing more than one requires the use of an EnumList-type column.