How to ref inf from a email?

i have an app that get email with QR CODE
and i need that row name get the name from another table if the email is the same as QR CODE

You could use something like LOOKUP([_THISROW].[Promotor],YourTableName,Promotor,Name)