Label content from combobox value

[Fa1con74]

I have a combobox that contains names 

Item = 

Filter(BdMs_New;"USAR 3" in 'UV Pompiers'.Value).Nom

I want to display in a label field the email corresponding to the name chosen in the combobox but I don't see how to do it

[RandyHayes · Accepted solution]

@Fa1con74 

Your formula is "restricting".  This means that you have added the .nom column name after the Filter table results.

So, your Filter is only going to return a table with a single column called nom.

If the email is in another column of that list, then it will not be available.

I would suggest removing the .nom from your formula and then on your label Text property, you can have the following formula:

    yourCombobox.Selected.<emailColumnNameHere>

I hope this is helpful for you.

[Fa1con74]

Thanks very much