Pulling data from a form to a lookup table

Copper Contributor

I'm new to this and have created a simple workflow.  It's triggered when a new form is filled out.  What I want to do next is:

1 - pull the information from a field (department)

2 - have that go to a lookup table, find the matching department and return the associated email

3 - send an email notification to the returned email address

 

Any help would be appreciated.

0 Replies