Extract email from newly added row on table to be used in task

I’m creating a task to send email but I want the email address extracted from the newly added row I’m not sure how I can execute this I’m new to this thank you

How is the email address recorded in the newly-added row?

1 Like

So I created a simple Time off request app, the email address is added by user when they select their manager, I was able to setup the task sending email notification to HR but I want to send a copy to the manager since I need them to review the request.

That changes the problem from what you originally posted.

Please describe the complete problem in one post.

1 Like

I’m sorry about that but I think I solve the problem by using LOOKUP() but thanks for the help I will probably have more questions in the future.