Hi all,
Working on some cosmetic changes to a functional dashboard. In a standard dropdown, I have a field that populates a token. I fill this dropdown from a lookup table with the following columns:
Institution existingName newName
In this lookup, one item has a one to many relationship -- IE one newName value has 2 existingName values. To get around this, I changed that selection to be static, and modified the search to ignore it.
Static:
Name Value
Z "X" OR "Y"
Search:
| inputlookup lookup.csv
| where newName!="Z"
Functionally, this produces the results I want. The dashboard uses the token properly from both the static option and the lookup table. However, the static option is at the top, with the rest sorted properly. This is a minor nitpick, but I'd like to sort the results of both the lookup table and the static option together.
Is this possible? Should I pass the "X" or "Y" into the lookup instead?
