Enumlist: Update & Reset based on another column value

Hello,

I have the following data structure:

Table → Cotiza
Column → cotizaTipo (Enum)
Column → tourID (EnumList)

Table → Tour
Table → Programa

Objective
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
[_THISROW_BEFORE].[cotizaTipo]<>[_THISROW_AFTER].[cotizaTipo]

The problem
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?

Thanks

Solved Solved
1 5 966
1 ACCEPTED SOLUTION

Steve
Platinum 5
Platinum 5

Remove [_THISROW]. from that expression.

View solution in original post

5 REPLIES 5
Top Labels in this Space