Question: How should I create this particular expression?

Hi! I am having trouble creating an expression that works for this scenario. I have two tables that I am dealing with.

Connection - A table of requests
[Requested ofโ€ฆ] - Which company the request is supposed to go to

Companies - A table with companies and their main email contact
[Company] - A company
[Main Contact] - The email contact that the request is supposed to go to

I have a workflow that is supposed to send an email to the [Main Contact] for the company indicated in the [Requested ofโ€ฆ] column. For example, if I [request ofโ€ฆ] โ€œGonnellaโ€, then it should look at the Companies table and find the email listed in the โ€œGonnellaโ€ row. I tried using lookup expressions, but could not figure it out. Any ideas? Thanks

Solved Solved
0 3 305
1 ACCEPTED SOLUTION

Maybe something likeโ€ฆ LOOKUP([_THISROW].[Requested of],โ€œCompaniesโ€,โ€œCompanyโ€,โ€œMain Contactโ€)

View solution in original post

3 REPLIES 3

Maybe something likeโ€ฆ LOOKUP([_THISROW].[Requested of],โ€œCompaniesโ€,โ€œCompanyโ€,โ€œMain Contactโ€)

That worked! Thanks!

Youโ€™re welcome

Top Labels in this Space