Select value based on value in variable

[aj1]

Hello- I have two variable Alias and Name

I am wanting to derive the name of the user from the alias like:

vAlias = 'T11526T'

vName = GetFieldSelection([Name], vAlias)

So that the name will be populated based on the corresponding alias.

what is the best way to do this? I have tried GetFieldSelection, and it did not work.

[aj1 · Accepted solution]

Just got this solution to work.

Used set analysis with the ONLY expression to select the name

=ONLY({$<[Alias]={$(UserAlias)}>}[Name])