Using dropdown to populate a label

[erin_lynch]

I am currently trying to get a label to populate with a name when a number is select from a drop down. 

For example if 1 is select then the label will fill with john smith, 2 would fill the label with Jane doe. 

The current code I have is below. and I am putting this in the text function of the Label

Lookup('Sharepointlist', 'Number' = DataCardValue1.Selected.Value).'Name'

From looking at other posts this should work, but for me it seems to take the first value in the sharepoint list to be the default and then not change to the other names when a number is selected. 

Any help would be appreciated. 

[eka24 · Accepted solution]

Try

Lookup(Sharepointlist,Number=DataCardValue1.Selected.Value,Name)

If it doesn't work show the dropdown items

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.