Hi, How can I handle missing values in an Excel document if I want to import it using ExcelImporter? Leaving the field blank does not import all the rows, and replacing the blanks with ‘?’ throws an error since it expects a different attribute type. Any suggestions?
An alternative to resolve these whites values in a import is handle this values in a microflow before. When you import data you can call a microflow and then in loop for you can check if the attribute value is empty. then in a conditionally you dicide what you do.