Turning First Name Last Name into a People Reference?

I have a table of names and I want to turn them into People references so I can
Notify them. Is there a way to go from a name “Jane Doe” into a Person? I tried just turning the column with text names into People, didn’t work (even though the names matched 1:1). Also tried concatenating with “@” but to no avail.

Anyone know how?

1 Like

Hello @Ryan_Nier!
For this you would need to create a People table. Having a row for every person and then, back to your original table, filter the People table with its Name with the help of the next formula:

People.Filter(People.Name=thisRow.Name).First

1 Like