Linktofilteredview() and lists of ref_rows

[Sean_Lim]

Hello, I have a conundrum that may have a simple solution that I’m simply not seeing.

There are two tables:
Table A with column A (key) and column B (text)
Table B with column C (ref_rows of Table A)

I’m making an action for Table B to “go to another view within this app”

The action uses Linktofilteredview(“Table A View”, IN([Column A].[Column B], [Column C][Column B])

Why is this not working? It should be easy for Table A to give me rows that have its Column B value in the ref_row list [Column C][Column B]

[Bahbus]

IN() simply returns a TRUE/FLASE value of if the provided value exists in the provided list. You’ll need to use some sort of expression that returns specifically the Key you want to go to.

[LeventK]

Sean_Lim:

The action uses Linktofilteredview(“Table A View”, IN([Column A].[Column B], [Column C][Column B])

Why is this not working?

You can’t use a de-ref expression within an IN(…) expression. Also your way of introducing the [Related ColumnX_Values] (REF_ROWS) is not correct. You shall enclose it with a SELECT(…) expression.

[Steve]

One problem is with [Column C][Column B]: the IN() expression is evaluated in Table A, and Column C does not exist within Table A.

What do you want the filtered view to display?

help.appsheet.com

LINKTOFILTEREDVIEW()

Constructed deep link to filtered view

[Sean_Lim · Accepted solution]

Thank you for all yall help.

What worked for me was Linktofilteredview(“Table A View”, IN([Column B], SELECT(Table A[Column B], [Table B Key] = [_THISROW].[Table B Key])

The intention of the action is quite complex. It shows all of the related rows in Table A that has a reference row in Table B (whose key is [Table B Key]) as the current row in Table B. Table A has a column with Table B Key as a REF column.