Validation in Excel Importer

I am importing an excel file wherein I am mapping one column to the attribute in another table through association.So value is getting saved into the second table directly. Is there any way to validate that column before setting the value to second table?
1 answers

Two ways I can think of:

  • create a small microflow that validates the incoming data as you would like to validate it. Then call that microflow in the import template. You can specify which microflow to use for each column in your template using the Parse With field. Note that this won't stop the import, it can inspect the data and change it as you see fit.
  • Load the date into an import table, not the final entity it is intended for. Once it is loaded, create a microflow to validate, massage and track changes as you wish. Then, assuming that the data passes the validation, put it into the target entity.