Select value based on value in variable

aj1 — Thu, 15 Aug 2019 18:30:12 GMT

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.

Re: Select value based on value in variable

aj1 — Thu, 15 Aug 2019 18:36:35 GMT

Just got this solution to work.

Used set analysis with the ONLY expression to select the name

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