Select or Filter expression help with filtering a view

JLC
Bronze 3
Bronze 3

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.

Solved Solved
0 1 116
1 ACCEPTED SOLUTION

1 REPLY 1

Top Labels in this Space