Replace Useremail() with Name

[LLD]

I have a table "PERSONS" listing users of an app; columns as follows - 

_rownumber, UserID (i.e. email), Owner (i.e. name of the user)

In another table, the users add tasks. Each row of that table captures UserID i.e. Initial Value = Useremail()

For the next column, when I use the formula LOOKUP([UserID],"PERSONS","UserID","Owner"), it does not return the Owner according  to the User ID, instead, it  always returns the name of the first person in the table "PERSONS"

[Suvrutt_Gurjar · Accepted solution]

This?

 LOOKUP([_THISROW].[UserID],"PERSONS","UserID","Owner")

https://help.appsheet.com/en/articles/2357309-lookup

[Suvrutt_Gurjar · Accepted solution]

This?

 LOOKUP([_THISROW].[UserID],"PERSONS","UserID","Owner")

https://help.appsheet.com/en/articles/2357309-lookup

[LLD · Accepted solution]

Thank you Suvrutt! It worked.