Solved: Create List of Ref without a direct link - Page 2

teambelair · 03-04-2020 12:32 PM

Hi All,

Context:

I have a table A and C that do not have link to each other
I have a table B is a mapping table between A and C (B has a link to A and another link to C)

Goal: I would like to see the list of C under each record A in detail view.

Is it possible without having to create a dynamic dashboard?

Steve

Try as the App formula for a virtual column in Classes:

SELECT(
  Table B[Activity],
  ([_THISROW].[Class] = [Class])
)