Dropdown list filter by useremail()

[desmond_lee]

Hi All

In normal drop down I usually can achieved by set data type ref and valid_if stocktake[EMPD ID] from the slice. Is is possible in include another criteria the email di list only those match to the login useremail() list in the table?

In the above table prodadmin@xxxx.xxx repeated X3 and prodadmin4@xxxx.xxx X2. If the slice name is stocktake and the tab name is audit. If the ref table is audit and the valid_if is stocktake[EMP ID] all 6 item will be drop dropdown. Is is possible to have valid_if stocktake{ENP ID] + USEREMAI() condition to filter all the others and drop down S334,1231, 432 if the login USEREMAL = prodadmin@xxxx.xxx

[T_I_Phong]

If I understand you, in Valid_if:

SELECT(stocktake{ENP ID],USEREMAIL() = [Email])

[desmond_lee]

Its not possible because the item complete missing

At the moment this is the best way. ANY(SELECT(Stock Auditor[EMAIL CONTACT],[EMPLOYEE ID]=[_THISROW].[ASSET AUDITOR ID]))=[USER CTRL]