How to Filter the table based on a list?

AppSheet AppSheet Q&A
, , ,
1

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!

2

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

1 Like
3

Slices: The Essentials - AppSheet Help