Skip to main content
Introducing Conversational Analytics in Microsoft Teams: READ MORE
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Use QVUser to Lookup First Name in Employee table.

Hopefully this is just a quick question I’m using QVUser() to get the users login, but I want to display the users first name in a Text Box. I have an Employee table where I have stored both the login name and the users first name.

I thought it was just a quick case of using Lookup but this is not available as a function ?

Thanks Mark

2 Replies
Not applicable

Try something like this in a text box first.

= Only({<ClientUserName = {"=QVUser()"}>}  ClientFirstName)


= Only({<ClientUserName = {"QVUser()"}>}  ClientFirstName)

Not applicable

Hi Aadil

Thanks for quick reply have tried following without any luck. All Users login Id is 8 characters long, that why I have used the "Right" function just to look at the last 8 characters of the login string.

=Only({<LOGIN = {"=right(OSUser(),8"}>} EmployeeFirstName)

=Only({<LOGIN = {"=(right(OSUser(),8)"}>} EmployeeFirstName)

=Only({<LOGIN = {"(right(OSUser(),8)"}>} EmployeeFirstName)

=Only({<LOGIN = {"right(OSUser(),8"}>} EmployeeFirstName)