In one of my client’s app, I have 2 tables: REGISTRATION and COUNTRIES respectively. You can see the COUNTRIES table in the attached image. I have created a Virtual Column in this table, with a simple CONCATENATE expression: =CONCATENATE([CODE]," - ",[COUNTRY])
In my [NATIONALITY] column in REGISTRATION table, I call this list with a simple Valid_if expression:
However, as you can see from the 2nd attached image, the content of the dropdown is way different then the content in the table. I have tried various forms of expressions like:
SELECT(COUNTRIES[VC_Name],TRUE) TOP(SELECT(COUNTRIES[VC_Name],TRUE),233) SELECT(COUNTRIES[VC_Name],ISNOTBLANK([COUNTRY])) _SELECT(COUNTRIES[VC_Name],AND(ISNOTBLANK([COUNTRY]),ISNOTBLANK([CODE]))) etc.
but no any one seems working as it’s expected. Could this be a bug on your side, or am I doing something wrong here?
Thanks for your consideration and time to reply.