I have a Combo Box for a Choice column, but I'd like to change the labels to be a bit more informative.
I've attempted to use the value of the choice column to lookup another table, but I get [object Object] instead, which isn't the intended behaviour.
Ideally, my labels would be "Value" & First(Filter(...)) & Last(Filter(...))
So for example, I'd like the entry of the dropdown for CAN/US to show "CAN/US 0-18", or split across 2 fields if necessary (which I've been trying in the screenshot)
If necessary I could set up another table to hold label information.

Report
All responses (
Answers (