How to show the data of the row when you type the email address of the user (email address is the first column)

When you type the email address of the user it shows the data on the corresponding column.


example when you type “aa@gmail.com” it will show the data on column BCDE. thank you.

Hi, if you are using Ref field on another table and the email is a key column, you can use Deref expression like [Email].[ColumnB] for example with the initial value.