Below expression seems to work correctly.
However, Is there a better expression to use?
In(Useremail(), Select(Users[Email], In([fullName],[_THISROW].[HiringManger] ) ) )
I have a field called [HiringManager] in a table called Candidates. The record has one or more Hiring Manager’s names in that field. The Hiring Managers are an Enumlist referencing the Users table.
I want to filter a view based on the current user if they are listed as the Hiring Manager.