Filter a Slice to a Column value from another Table

[Bill_Hyde]

I would like to filter a Slice where column [Technician] = [Name 1] from another table which contains only one row.

Table = Technician Log , origin of Slice “Technician_Out 1”
[Technician] is Text format.

Table with value to use for the filter = Access
[Name 1] is Text format.

[Steve · Accepted solution]

Either:

IN([Technician], Access[Name 1])

or:

([Technician] = ANY(Access[Name 1]))

See also:

help.appsheet.com

ANY()

One arbitrary list item

help.appsheet.com

IN()

Is item in list?

help.appsheet.com

List from Table-Column Reference

Create a list from the values in a column of a table.

[Bill_Hyde]

Thank you Steve. It works well.