SuperLookup Error

Panorama X
1

In troubleshooting an error that the field “To” does not exist in a SuperLookup, I turned to the Formula Workshop. I’m don’t understand the results and why the lookup is failing.

As shown below, the field exists and has contents. If I enter the value of the To field into the SuperLookup, it works as expected. Changing only the quoted value to the fieldname results in the error. Here it does not identify the field or variable. But in a Text Display, it identifies it as “To”.

Screenshot 2026-04-05 at 10.30.41 AM
Screenshot 2026-04-05 at 10.30.41 AM1392×800 141 KB

2

I’m pretty sure it expects your To field to be in Contacts, rather than Composer.

3

Two ways to deal with this. Use double chevrons

superlookup("Contacts",{ArrayFirst(lftocr(«Email Address»),cr())=««To»»},{Salutation})

or move the To field outside the braces

superlookup("Contacts",{ArrayFirst(lftocr(«Email Address»),cr())="}+To+{"},{Salutation})