Good Morning,
A little confused,
I have a Table with 3 Columns.
Column A: Type Ref
Column B: Type EnumList Base is Ref
Column C: Type EnumList Base is Ref
Wanted Behaviour:
User Select Column A,
Based on Selection is Column A, Populate Column B.
Based on Selections from Column B Populate Column C
User Chooses Item/'s from Column C
This is what I have.
Column B has a Valid if from Column A.
Expression
Select(ColumnBRefTable[ID], [Column in Ref] = [_Thisrow].[Column A])
This is Working,
My Problem is trying to get a Valid if Select Expression for column C Based on Selected Values in Column B.
Expression:
Select(ColumnCRefTable[ID], [Column in Ref] = [_ThisRow].[Column B])
Column C Valid if expression is Telling me
Cannot compare List with Ref
How would one Typically go about this?
Solved! Go to Solution.
Perfect
Thanks
Can you please share the properties of these columns?
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |