Enumlist dependent on enumlist

[Christian_Kryge]

Hi all

I need a way for an enumlist to be dependent on another enumlist.

I have three tables. One for user data, one for projects and one for activities.

The user data contains emails of employees (email type column) - Users[Email].

The project table has different projects with uniqueid’s and a “project team” enumlist, with valid_if Users[Email].

Now I would like a enumlist in my activities table that only show the employees on that specific project team, when assigning activities. How do I do that??

At the moment I have implemented the following in the valid_if for my enumlist in activities table:

IN(Users[Email], LOOKUP([_THISROW].[Project Key], Projects, Key, Project team))

It returns the correct values, but gives me an invalid input error…

Thanks in advance!

[Aleksi]

If the “Project team” is an enumlist, you should be able to read the list with
LOOKUP([_THISROW].[Project Key],Projects,Key,Project team)

[Christian_Kryge]

Yep and I can do that, but the next enumlist reads it as one point on a list, so I get the whole project team list as one option instead of multiple.

[Aleksi]

And you are sure the original column is an EnumList field?

[Aleksi · Accepted solution]

Aaa… my mistake. Use…
SPLIT(LOOKUP([_THISROW].[Project Key],Projects,Key,Project team)," , ")

[Christian_Kryge]

Yep of course! Thanks!