So I can do this to get a list of Employee ID’s that are attached to the current record:
[Related Assigned Technicians][Employee ID]
I can do this to verify that the specified Employee ID is in the list above:
IN("N4dCeqZo", [Related Assigned Technicians][Employee ID])
However, if I do the blow, the result is empty and I assume it has to do with a clash in the [Employee ID] column name. Is there some trick I can apply to make it work?
And yes I do know that I can take out the IN clause and replace with something like
[Key] = [_THISROW].[Key] to make this expression work, but this is not the final expression I am aiming for.
I am just curious, before I find an alternate expression, if there is something simple that makes the below expression work.
SELECT(Assigned Technicians[Employee ID], IN([Employee ID], [Related Assigned Technicians][Employee ID]))