Enumlist dependent on enumlist

references
expressions
(Christian Kryger) #1

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! :slight_smile:

(Aleksi Alkio) #2

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 Kryger) #3

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 Alkio) #4

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

(Aleksi Alkio) #5

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

(Christian Kryger) #6

Yep of course! Thanks!