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! Go to Solution.
Maybe something likeโฆ LOOKUP([_THISROW].[Requested of],โCompaniesโ,โCompanyโ,โMain Contactโ)
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |