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!