Requirement
We are using Easy Import functionality to import data into a custom table from an Excel file. When users click Preview Imported Data, validation errors should be displayed for any records that fail the custom validation rules.
I need to add a new custom validation that validates all imported rows and displays the corresponding error message in the Preview Imported Data screen.
What I Tried
I created a Business Rule on the staging table because the Preview Imported Data screen reads and displays messages from the Template Import Log Message field on the staging record.
The Business Rule contains the custom validation logic and is designed to populate the Template Import Log Message field when validation fails.
However, the Business Rule is not getting triggered during the Easy Import process. I am not seeing any logs from the Business Rule, and the validation message is not being populated.
Interestingly, if I open a staging record manually and save it, the Business Rule runs successfully and the validation message is populated as expected.
Issue
How can I execute custom validation during the Easy Import process so that validation errors are populated in the Template Import Log Message field and displayed in the Preview Imported Data screen before the records are imported?
