SLICE - USED IN EXPRESSIONS

[jaichith]

Hi, 

Is it possible to use a slice as a table in lookup () expression ? . 

LOOKUP(USEREMAIL(),"USERS SLICE", "EMAIL", "USER ROLE")

 the above doesn't work for me . Is there any work around for it ? Is it same for all other expressions like select(), filter() etc. ?

[VarunChandran]

Yes We can use Slice in Lookup and get the Slice Data

[jaichith]

Expression assistant says " could not find the table "

[VarunChandran]

If you are using this lookup in the formula field then try to edit the column and you will see that user role is in that particular field.

[VarunChandran]

Try to Save the Changes of Slice and write lookup function. It will be automatically come in the list of tables