Trying to create a List with an elemental Ref

[Elijah_Magrane]

Hi I am trying to create VC list with a simple deference list expression. The expression is like so [Ref column][Deref column]

My expression parses the correct data but when I try to change the elemental type of the list to a ref it doesn’t take (it just reverts back to text).

I have also tried changing the column type to enumlist and the base type to a ref. The editor allows me to do so but the reference doesn’t go through.

Any suggestions?

[Steve]

What is the column type of Deref column?

[Bellave_Jayaram]

Elijah_Magrane:

[Ref column][Deref column]

cannot be a ref type, as
[Ref column] is itself (and the only possible for that table) ref type.

[Elijah_Magrane]

What is the column type of Deref column ?

It is a Ref type as well

[Bellave_Jayaram]

Ok, it is possible that (a ref enumlist derived from a ref by dereferencing) may not be supported yet. I would send it to support or wait for someone from AppSheet to confirm if it is or if there is a workaround.
@Aleksi?

[Elijah_Magrane]

I am bringing @QREW_Ben because he is assisting me with this

[Marc_Dillon]

I think this might be similar to:

Create List of Ref without a direct link Questions

So, B has two ref columns, to A and C? That means A should have an auto-generated virtual column called “Related Bs”, this is a list of B records ref’d to A. So to get a list of C records ref’d by that list of B records, you’d use: [Related Bs][refC] Where “refC” is the column name in table B that is the ref column to C.

[Elijah_Magrane]

Yep @Marc_Dillon. Your right I am trying to achieve the same thing as @teambelair and I am having the exact same issues. Does anyone know if this is a bug or expected behavior?

[Elijah_Magrane]

Just giving this a bump. I haven’t found a solution. Any luck @teambelair

[Steve]

Try as the App formula for a virtual column in table A:

SELECT(
  table B[table C ref],
  ([_THISROW].[table A ref] = [table A ref])
)

[teambelair]

Perfect! Thx Steve

[teambelair]

I have not. Can’t find a way to create a ref list without a direct link.