Hey all,
So I’m a bit stumped on where I’ve gone wrong.
Please note the below code for a slice row level filter:
IN([_THISROW].[EMPLOYMENT LEVEL],SPLIT(LOOKUP(USEREMAIL(),ENUM LISTS,EMAIL,VIEW SLYC)," , "))
I’m also uploading what the tables and date currently looks like.
Essentially, the filter should look up the useremail in the enum lists table and return a cell filled with applicable employment levels comma seperated lists.
This should be compared to a column in the views table as to whether that particular view is filtered or not.
I’ve based this off another app which I created working fine, yet I can’t figure out for the life of me where I’m going wrong.
Any assistance would be greatly appreciated.
Please try
IN([_THISROW].[EMPLOYMENT LEVEL],SPLIT(LOOKUP(USEREMAIL(),“ENUM LISTS”,“EMAIL”, “VIEW SLYC”)," , "))
1 Like
That should work, but alas it does not.
I might contact support and get them to check if there is something incorrect.
Yes, you are correct. It should work.
When I tested in similar environment with same column names except table name, it worked for me. It shows yes for the views where the employment level permits it. I am sure you have already ensured it, but just in case, you may also want to double check you have entered USEREMAIL() of the email ID that you are testing with.
1 Like
You certainly don’t need the “[_THISROW].” portion in the expression.
I would also change the SPLIT(LOOKUP()) to instead be SPLIT(TEXT(SELECT()))
1 Like
