When it says ‘one randomly’, it really means it is taking the first item from the returned list. However, in this case, the returned list should only have one entry: that entry which the column [Email] matches USEREMAIL(). Therefore, the ‘one randomly’ statement isn’t a concern.
It’s not immediately obvious why @tvinci’s expression isn’t working - it appears correct. Make sure that:
- Your application requires login, otherwise USEREMAIL() does not return anything;
- The table and column names are correct.
Also, an equivalent way to write the lookup statement would be:
[Email] = USEREMAIL()