Receiving the error “Expressions in schema ‘Leads_Schema’ have a circular definition. Check app formulas and initial values for column ‘Full Name’” when using the expression:
SWITCH(
[_THISROW].[Manufacturer],
GM, LOOKUP([_THISROW].[Pin Code], “GM”, “Pin Code*”, “Full Name*”),
CDJR, LOOKUP([_THISROW].[Pin Code], “CDJR”, “Pin Code*”, “Full Name*”),
Honda, LOOKUP([_THISROW].[Pin Code], “Honda”, “Pin Code*”, “Full Name*”),
Ford, LOOKUP([_THISROW].[Pin Code], “Ford”, “Pin Code*”, “Full Name*”),
KIa, LOOKUP([_THISROW].[Pin Code], “Kia”, “Pin Code*”, “Full Name*”),
Nissan, LOOKUP([_THISROW].[Pin Code], “Nissan”, “Pin Code*”, “Full Name*”),
Hyundai, LOOKUP([_THISROW].[Pin Code], “Hyundai”, “Pin Code*”, “Full Name*”),
Toyota, LOOKUP([_THISROW].[Pin Code], “Toyota”, “Pin Code*”, “Full Name*”),
LOOKUP([_THISROW].[Pin Code], “Manifest”, “Pin Code*”, “Full Name*”)
)
The same expression works for other fields like “Address”, but not “Full Name”.
LinkedIn
Twitter
