How to only show a selected few from a long list in a dependent dropdown?

***strong text***Hi,
If the ValidIf expression Surgery List[Surgery Title] shows all of the values in [Surgery Title] column of “Surgery List” table,
and, if the Valid if expressiong Surgery List[Surgery Title]-List("Colonoscopy","Sigmoidoscopy","UGIE","ERCP","Rigid Sigmoidoscopy","Proctoscopy","EUS") removes those 7 values from the long list of values in [Surgery Title],
if I wanted to only show those 7 values in a different dropdown menu, fetching from the long list of values in the [Surgery Title] column in the “Surgery List” table, what should the expression be for that? (because since the [Surgery Title] column has over 150 unique values in it, and I cannot write an expression to remove all those 150 values just to show those 7 values using the same -LIST() expression).

Thanks!

0 8 539
8 REPLIES 8
Top Labels in this Space