How to use "this row" formula to fill a column with referring/linking it to another tableanother

2

Hey @VINAY_B_C, here’s the formula:

image
image990×178 29.8 KB

You have to find a row in the Assignee Details table that corresponds to the current email:

[Assignee Details].Filter(
  [Assignee Mail] = thisRow.[Assignee Email]
).First()

(use .First() to limit to one result and avoid getting a list-of-one)

and then read the .Team column out of that record.

2 Likes