Hi Bright Amalraj,
The error is most likely produced because cells are imported without a TRUE or FALSE value.
You can use a custom microflow to parse data for a column. Such a microflow should have one parameter of the same type as the column in the Excel. This will receive the data field from Excel. The microflow should return the value to put in the field you want to map (meaning, a DateTime
if you are mapping to a DateTime
attribute). This does not apply to numbers (Integer, Long, Decimal), because Excel reads the raw data as Decimal and hence the Parsing microflow should always return Decimal. The eventual conversion of this returned Decimal value into either Integer, Long or Decimal will be done by the module.
This field also has quicksearch functionality. Type in the box to the left of the reference selector and press Tab to search for the value you typed.
By default, the selected microflow is not applied to empty cells. The parsing of empty cells can be enabled by setting the ExcelImporter.ParseEmptyCells
constant to true
.
Go Make It