Going from List to Reference

[ni_developer]

My reference is like this
Table A has Table B & C
Table B & C Each have Table D

This expression works to get a list of IDs of Table D in A
[Related Bs][Related Ds] + [Related Cs][Related Ds]
When I try to convert this list of ids into list of ‘Ref’ - it’s not working

I also tried this expression, which just returns empty - But I’m able able to configure this expression as List of Ref
FILTER("D", IN([ID], [Related Bs][Related Ds] + [Related Cs][Related Ds] ) )

[Steve]

I would expect [Related Bs][Related Ds] + [Related Cs][Related Ds] to be a List of Ref to table D. Is that not what you want?

[ni_developer]

@Steve Appsheet changes this expression [Related Bs][Related Ds] + [Related Cs][Related Ds] from List of Ref to List of List upon save.

Which makes sense as Related Ds is a List of Ref in Table B.
Not able to figure out why the Filter Expression is not working.

[Steve]

Try:

SPLIT(([Related Bs][Related Ds] + [Related Cs][Related Ds]), " , ")

You may have to set the base type and referenced table manually.