How to Filter the table based on a list?

[Ameteet]

Hi, I have a sample scenario here, please help me how to filter the table based on a list?

Data:

Description	Quantity
Apple	2
Banana	3
Apple	6
Banana	5
Orange	7
Grapes	9

I want to filter the table based on the list the user has access. Sample if User1 should only view banana & apples, he can only see this:

Description	Quantity
Apple	2
Banana	3
Apple	6

I tried to use the combination of ANY & SELECT formula, but unfortunately it would only filter to one item either Apple or Banana.

Formula:

[Description]=ANY(SELECT(XXXXX[XXXXX],XXXXX=XXXXX))

Kindly help me what is the best formula for this one. 

Thank you!

[1minManager]

Select(TableName[Description],OR([Description]="Apple",[Description]="Banana"))

But this really depends in the context of where you are using this.  Also the Select function should be choosing the Key Column, which I presume description isn't as it has duplicate values.

Simon@1minManager.com

[Steve]

Slices: The Essentials - AppSheet Help