Find out if a value in a list is in another list

[Gustavo_Eduardo]

Hi all. Does anyone know how to know if a value of a list is in another list?

[bonameblisto]

---

@Gustavo_Eduardo wrote:

Hi all. Does anyone know how to know if a value of a list is in another list?

---

Reformulate your question, pls:
One value from list1 present in list2
Or
All values from list1 presents in list2

In any case you can find answer here
https://help.appsheet.com/en/articles/961274-list-expressions

[Gustavo_Eduardo]

How are you bonameblisto!, thanks for your answer. I've created an "Add Item" button to a list, which should only be active if it's not in the new list, so that I can't add it twice.

I have created a "Format Rules" and, where it says:

If this condition is true
Condition to check before formatting

I must place the condition that makes the icon appear if it is not in the other table.

What I want is for the button to appear if I haven't added the item to the table.

[Darmund · Accepted solution]

Oh if you want to see if the item is in the table or not, you can use the IN() expression.

So on the format rule "If this condition is true" you can use

NOT(IN([_THISROW].[IDColumn], OtherTable[RefColumn])) 

This assumes that you have a ref column between the two tables.

[Aurelien]

Hi  @Gustavo_Eduardo 

You may want to use this expression:

ISNOTBLANK(INTERSECT(LIST1, LIST2))

For reference:

https://help.appsheet.com/en/articles/3483429-intersect

[Gustavo_Eduardo]

Hello Aurelien, thank you for your answer. I've created an "Add Item" button to a list, which should only be active if it's not in the new list, so that I can't add it twice.

I have created a "Format Rules" and, where it says:

If this condition is true
Condition to check before formatting

I must place the condition that makes the icon appear if it is not in the other table.

[Aurelien]

OK, so that should be something like:

NOT(IN([_THISROW],yourList))

It all depends on your data structure actually, but basically this is it.