Slice not working with LOOKUP, USEREMAIL

I have a table REGISTER of action items with an [Owner] column ref to another table call OWNERS
The OWNERS table has the columns [Email], [Name], and [Login]
Since some users are using a Gmail account to Login different than the email on the action item list, I have modified the slice Filter on REGISTER table from: [Owner] = USEREMAIL() to

LOOKUP(USEREMAIL(),โ€œOwnersโ€,โ€œLoginโ€,โ€œEmailโ€) = [_THISROW].[Owner]

But it is not working.

I have also tried [_THISROW].[Owner].[Login] = USEREMAIL() but with no success

Thanks for your help.

#################

UPDATE: I found the error: I had a security filter on the OWNERS tableโ€ฆ

3 0 212
0 REPLIES 0
Top Labels in this Space