I have the following data structure:
Table → Cotiza
Column → cotizaTipo (Enum)
Column → tourID (EnumList)
Table → Tour
Table → Programa
The objective is that column tourID (EnumList) shows either the list of Tours or Programa based on the value of CotizaTipo
Progress so far
Based on the request I incorporated the following valid if expression:
IF([_THISROW].[cotizaTipo] = "Tours", Filter(Tour, TRUE), Filter(Programa, TRUE))
I also included a Reset on edit expression just to make sure that the EnumList will refresh its values if a change happened on cotizaTipo
So far the update of the EnumList doesn’t feel natural.
When I change between the values of cotizaTipo the list on tourID doesn’t update inmediatly.
It updates only when I select a few items, and then clear the list, which is odd.
It might be a little hard to understand so just in case I recorded the case:
Another thing I would like to ask is if we can show the label of the columnID instead of the ID itself.
For example, the Programa table has programID column as ID, but I would like to show programName column value in the EnumList dropdown, is it possible?