LookupValue function not working in workflow condition
Hi,
I am using following condition in a cancel save workflow for contact record:
[<AlternateProvince>] = LookupValue("OCC_CUST_LOV_CONTACT_2", [<AlternateProvince>]
This condition is used to compare the value of State field(When country selected is Australia) and if the value entered is not in the picklist 'OCC_CUST_LOV_CONTACT_2', it should through an error.
However, this condition is not working and is allowing any value to be entered in the state field.
Could you please suggest if there is any issue in the condition or can suggest any alternate method to achieve the required functionality?
Regards,
Ritesh Soni