To me it seems strange that the 'parse with' microflow isn't called upon when the value you want to import form Excel is empty.
It would be a big help if I could use logic to, for example, set a specific boolean value or enumeration when the imported value is empty. Now it is not possible to import a boolean from an empty value, and for enumerations the imported value will allways return 'empty'.
Also other kind of import logic will not be applied if the imported value is empty, which is not very consistent!
Also agree. It makes it much easier to create default values in a microflow expression if the field is empty. Otherwise the workaround is to populate all the empty spreadsheet cells with a value, even just one blank space ‘ ‘.
I agree, this sounds like a logical thing to implement. Dealing with empty values can be extremely useful!