I've created a flow that updates the Contact Owner to match the Account Owner, if the current Contact Owner is an inactive or frozen user and the Account Owner is not.
Here is my criteria:
AND(
OR(
CONTAINS([Contact].Owner.FirstName, "Inactive"),
CONTAINS([Contact].Owner.FirstName, "Frozen")),
NOT(CONTAINS([Contact].Account.Owner.FirstName, "Inactive")),
NOT(ISNULL([Contact].AccountId)),
)
I've been getting this error: The flow failed to access the value for myVariable_current.Account.Owner.FirstName because it hasn't been set or assigned, but I've included criteira to not run the flow if there is no Account associated to the Contact: NOT(ISNULL([Contact].AccountId))
Every Contact record creating this error has not had an Account assoicated (unsure how users have added these contacts in the past, since an Account is always requried)
Any thoughts on why my criteria would not be excluding these?
Thanks!
6 Antworten
Try isBlank instead of ISNULL
AND(
OR(
CONTAINS([Contact].Owner.FirstName, "Inactive"),
CONTAINS([Contact].Owner.FirstName, "Frozen")),
NOT(CONTAINS([Contact].Account.Owner.FirstName, "Inactive")),
NOT(ISBLANK([Contact].AccountId)),
)
