Autopopulate a Field based on a previous Enumlist select values (multiselect)

[Romulo88]

Hi all,

I have quite a similar problem to this thread: LINK.

I have the following:

• Table "Source" with columns "A", "B" ,"C"
• Table "Dropdown" with columns "Ax", "By", "Cz".

Columns "Cz" ist just a column that are the initials or a shortname of the fields in Column "By".

Event 1:Column "A" (from Table Source) is a Dropdown field. (Type: Text)

Under Data Validity/Valid IF: Sort(Dropdown[Ax], false), my users must select a single value from that list.

Event 2: Column "B" (from Table Source) is a conditional Dropdown field. It should only show to the user values which were selected in Column "A". (Type: Enumlist /Base type: List / Input mode: Dropdown / Item Separator: ;). 

Under Autocompute/Suggested Values: Select(Dropdown[By],[_THISROW].[Ax]=[A])

Event 3: What I want to do now is to have an autopopulated field in Column "C" based on the selection in Column "B" both in Table Source. It should only display the Initials/Acronyms located in Table Dropdown "Cz"

Under Autocompute/Suggested Values: SPLIT(LOOKUP([_THISROW].[Column "B"], "Dropdown", "By", "Cz"),";")

However, it does not work. Whenever I select a single field from Column "B" in Event 2, I do get the autopopulated field on Column "C". Once I select more than one, i get the value: NULL.

I am aware there is a mistake. Any help, highly appreciated.