
Hi everyone,
I think I'm facing a very easy problem, I want to obtain different Items for a dropdown box by selecting a different column from the table "Options". The information of the column to select is in the ColumnVariable.
Distinct(Filter(Options;ID=13);ColumnVariable).Result
My problem is that if I run the code above I get the ColumnVariable as the only item in the dropdown.
Any Ideas?
Thanks
Hi @ForDrone94,
Do you want to select different column values dynamically from the Options table?
Could you please share a bit more about your scenario?
Actually, if you want to get distinct column values from the data source, you should reference to column name with a literal text rather than a variable.
If you want to select column dynamically, you should use the exhaustive list of method.