I get this error
Unable to find column '_ThisRow', did you mean 'Region'?
from this formula which sets the value of a column in an action
IF(
ISNOTBLANK(ANY(Select(Xref2[Response],[Postcode]=LEFT([_ThisRow].[Postcode],4)))),
ANY(Select(Xref2[Response],[Postcode]=LEFT([_ThisRow].[Postcode],4))),
IF(
ISNOTBLANK(ANY(Select(Xref2[Response],[Postcode]=LEFT([_ThisRow].[Postcode],3)))),
ANY(Select(Xref2[Response],[Postcode]=LEFT([_ThisRow].[Postcode],3))),
IF(
ISNOTBLANK(ANY(Select(Xref2[Response],[Postcode]=LEFT([_ThisRow].[Postcode],2)))),
ANY(Select(Xref2[Response],[Postcode]=LEFT([_ThisRow].[Postcode],2))),
""
)))
Simplifed to this
ANY(Select(Xref2[Response],[Postcode]=[_ThisRow].[Postcode]))
same error message ๐
As far as I can see there is nothing wrong with the formula. The action works fine. When I save & verify I get no errors. Its just the syntax checker AFAIK.
New Bug?
LinkedIn
Twitter
