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. ?
Yes We can use Slice in Lookup and get the Slice Data
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.
Expression assistant says " could not find the table "
Try to Save the Changes of Slice and write lookup function. It will be automatically come in the list of tables