Hi @DoStep and welcome to the community!
Here is a simplified example project:
ValidateRows.morph (6.0 KB)
Its workflow is as follows:
- Use the “Rule” action to create a column with validation errors. Note that only the first found error will be added to that column.
- Use the “Derive table” action and filters to separate valid and invalid rows
- Use the “Derive table” action in the “On condition” mode to handle invalid rows (this example
stores invalid rows in a CSV file and sends it via email).
Please refer to the following tutorial for more details on the “On condition” mode:
https://easymorph.com/learn/conditional-workflows.html