In Contact we have a custom lookup 'Country' and the BR at entity level validates: if Adress1 (composite field) has data and Country has no data, then show error message 'Country can not be empty'.
This validation works fine for a Contact Create from CRM UI and also using org service. But during import of Contact when we download the import template and try to put values for Address1 and Country along with FirstName and SurName, the import fails with the BR validation message 'Country can not be empty', even though we provided value for Country.
Up on investigating further, found that if Company Name is part of import excel, all the lookups are null during create pipeline and a separate update is being triggered for the lookup values to populate.
If we remove the Company Name Column from the import excel, then the import works fine. But we can't ask the users to delete the Company Name from the import excel everytime they download the template.
Also the field is needed in the form. Since its added on form, it automatically appears in the download template. Please help us in fixing this issue. Thanks in advance.
