How to check whether a value is in an enumlist

[Jared12345]

Hi

I am struggling with an IN expression for a Dashboard view.

Its my first time trying it and I cannot seem to get it right

if(
ISBLANK(ANY(User Purchases Dashboard Filter[Query_ILI_Allocation])),TRUE,IN([ILI_Allocation],ANY(User Purchases Dashboard Filter[Query_ILI_Allocation]))),

This one does not return anything when I choose an option from my enumlist.

I've checked and the user table where I am entering the filter value matches the value in my Allocation table in the case of my example being ALL001 but nothing is returned.

What is wrong with my expression?

These are the other expressions I've used and they seem to be working.

AND(
If(
ISBLANK(
ANY(User Purchases Dashboard Filter[Query_Store_Name])),TRUE,[ILI_IT_Link].[Invoice_BFTD_Link].[BFTD_Store_Name]=ANY(User Purchases Dashboard Filter[Query_Store_Name])),


If(ISBLANK(ANY(User Purchases Dashboard Filter[Query_Start_Date])),TRUE,[ILI_LineItemDate]>=ANY(User Purchases Dashboard Filter[Query_Start_Date])),


If(ISBLANK(ANY(User Purchases Dashboard Filter[Query_End_Date])),TRUE,[ILI_LineItemDate]<=ANY(User Purchases Dashboard Filter[Query_End_Date])),

if(
ISBLANK(ANY(User Purchases Dashboard Filter[Query_ILI_Supplier_Name])),TRUE,[ILI_Supplier_Name]=ANY(User Purchases Dashboard Filter[Query_ILI_Supplier_Name])),

if(
ISBLANK(ANY(User Purchases Dashboard Filter[Query_ILI_Product])),TRUE,[ILI_Product]=ANY(User Purchases Dashboard Filter[Query_ILI_Product])),

if(
ISBLANK(ANY(User Purchases Dashboard Filter[Query_ILI_Allocation])),TRUE,IN([ILI_Allocation],ANY(User Purchases Dashboard Filter[Query_ILI_Allocation]))),

if(
ISBLANK(ANY(User Purchases Dashboard Filter[Query_ILI_Expense_Type])),TRUE,[ILI_Expense_Type]=ANY(User Purchases Dashboard Filter[Query_ILI_Expense_Type])),


if(
ISBLANK(ANY(User Purchases Dashboard Filter[Query_ILI_Payment_Type])),TRUE,[ILI_Payment_Type]=ANY(User Purchases Dashboard Filter[Query_ILI_Payment_Type]))




)

[Joseph_Seddik · Accepted solution]

Regarding the first expression:

• You don't have to use ANY() with ISBLANK(); this is redundant.
• You cannot use ANY() with IN(); IN() requires a list as its second argument.

Just get rid of your ANY()s.

[Jared12345]

Hi Joseph,

Thanks for the response. When I remove the ANY() from 

ANY(User Purchases Dashboard Filter[Query_Store_Name])),TRUE,[ILI_IT_Link].[Invoice_BFTD_Link].[BFTD_Store_Name]=ANY(User Purchases Dashboard Filter[Query_Store_Name])),

Appsheet gives me "Cannot compare Ref with List in ([ILI_IT_Link].[Invoice_BFTD_Link].[BFTD_Store_Name] = User Purchases Dashboard Filter[Query_Store_Name])"

[Joseph_Seddik]

@Joseph_Seddik wrote:

Regarding the first expression :

😃