Solved: How to compare the Useremail to a table that has e... - Page 2

Tiger1 · 06-09-2020 12:43 PM

I am having trouble comparing the current useremail() who is logged in, to the table i built that has all emails, along with corresponding names.

Table 1 (Payables)
Table 2 (Initial Table)

I need to compare the current email user with Table 2 emails - and show the corresponding name of that email user.

Jonathon

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:

ANY(
  SELECT(Initial Table[Name],
    [Email] = USEREMAIL()
  )
)

View solution in original post

How to compare the Useremail to a table that has emails, to show the corresponding name of that user?