The parse with option isn’t suitable for validating, as a validation will return true or false if validation passes or not. While parsing is converting an input to a specific out put. i.e. a string into a integer
My general approach on importing excel, when it is a standard/often used feature in the app, is to do a shadow import.
Using this approach, you have full control on how the data is mapped, validated, converted. When you try to do that inside the import mapping, it might work, it might cause conflicts or give unexpected results. While you don’t have full control.
If you don’t mind, I’d like to share sample project with you.
Your advice is much flexible than “parse with”.
Let me adjust my flow.