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?
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.
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.