Slice

AppSheet AppSheet Q&A
1 
Hello, I need help to make a slice.

Table A has a column called ID.
Table B has two columns:
- ID (same as Table A)
- Useremail

I need the slice to display the IDs from table A based on the logged in user. Please note: a UserEmail can be linked to several IDs. 
I have tried with lookup() but it only shows the first value.

[ID]=lookup(Useremail(),"Table B","Useremail","ID")

Thank you!
2

https://help.appsheet.com/en/articles/2357277-in

https://help.appsheet.com/en/articles/2357314-select

3

Thanks, Marc_Dillon,

So, how the syntax would be?

I’ve tried the following expressions and they didn’t work:

SELECT(Table B[ID],[Useremail]=USEREMAIL())

Table A[ID] = SELECT(Table B[ID],[Useremail]=USEREMAIL())

[ID] = SELECT(Table B[ID],[Useremail]=USEREMAIL())

Thank you for your help

4

You’ve got the SELECT portion right. Now combine it with IN().

5 
 Hello, I'm sorry but I don't know how to incorporate it. If someone can help me with the formula, I appreciate it.
6

SELECT() returns a List. The 2nd parameter of IN() requires a List. Therefore:

IN( [column] , SELECT(…) )

7

many thanks! it worked properly!